Data Analyst - Power Query Your recent company
My client is undergoing a major ERP transformation, moving from a legacy Oracle system to Workday. This programme is a high-impact initiative focused on improving financial data integrity, reporting capability, and system efficiency.
Your new role
As a Data Analyst, you will play a key role in supporting the data migration and validation activities across the ERP transformation.You will be responsible for:

- Extracting, transforming, and loading data using Excel (Power Query is essential)
- Migrating and reconciling financial data from Oracle into Workday
- Building data validation tools and frameworks to ensure accuracy and consistency
- Identifying and resolving discrepancies across legacy and new systems
- Developing dashboards and reporting using Power BI
- Supporting testing phases including UAT and validation cycles
- Documenting data mappings, business rules, and transformation logic

What you'll need to succeed
- Strong experience as a Data Analyst in transformation or migration environments
- Advanced Excel skills, including Power Query (mandatory)




- Hands-on experience with Power BI (data modelling, DAX, dashboards)
- Experience working on ERP transformations or data migration projects
- Solid understanding of financial data and reconciliation processes
- Strong attention to detail and data quality focus
- Ability to work with both technical and non-technical stakeholders
Desirable:

- Exposure to Oracle and/or Workday systems
- Experience building reusable validation tools
- SQL knowledge

What you'll get in return

- Opportunity to work on a major ERP transformation program
- Exposure to Workday implementation and financial data migration
- A collaborative and high-performing project environment

What you need to do now

If you're interested in this role, click 'apply now' to forward an up-to-date copy of your CV, or call us now.
If this job isn't quite right for you, but you are looking for a new position, please contact us for a confidential discussion on your career.
#3001963

📌 Data Analyst - Power Query (Sydney)
🏢 Recognized
📍 Sydney