Data Analyst – Power Query

Data Analyst – Power Query

Your new 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.



LHS 297508

Summary

Job Type
Contract
Industry
Education & Training
Location
NSW - Sydney CBD
Specialism
Data & Advanced Analytics
Ref:
3001963

Talk to a consultant

Talk to Philip Beacom, the specialist consultant managing this position, located in Sydney
Level 14, Chifley Tower, 2 Chifley Square

Telephone: -

Similar jobs to Data Analyst – Power Query

  • Senior Data Analyst

    Senior Data Analyst
    NSW - Sydney CBD
  • Senior Data Engineer (Azure)

    Senior Data Engineer (Azure)
    NSW - Sydney CBD
  • Test Coordinator

    Test Coordinator
    NSW - Sydney CBD
  • Business Intelligence Analyst

    Support the broader business by providing meaningful and actionable data
    NSW - Sydney CBD$90K + Super
  • Power BI Reporting Lead

    Power BI Reporting Lead | Contract Role | Large Telecom client
    NSW - Sydney CBD