Data Analyst – Power Query

Job description

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 #3001963 - Philip Beacom

Login is optional, you may send application via email

Login to Save Login to Apply

Get AI to assess your suitability to this job

Assess My Fit with AI Beta — Free during trial period

Login to upload your resume and get an instant match score, strengths, and gaps.


Or use your preferred AI chat tool manually:

Use AI chat of your choice: ChatGPT, Gemini, Claude — and:

  1. Paste this into the prompt:
    I am a jobseeker. Below is a job posting. Please: 1. Give a match score (0–100) based on my resume vs the job requirements 2. List my 3–5 key strengths that align with this role 3. List 2–3 areas to improve or gaps to address before applying 4. Give a one-sentence verdict: should I apply, apply with adjustments, or skip? Job posting URL: https://australia.job-q.com/jobs/detail/data-analyst-power-query After reading the job, ask me to upload or paste my resume.
  2. Upload your resume in the same chat.

Job Summary

  • Published on: 10 Jun, 2026
  • Category: Data & Advanced Analytics
  • Vacancy: 1
  • Job type: Contractor
  • Salary:
  • Location: NSW - Sydney CBD
  • Job Nature: Contractor

Company Details

  • Name: Hays
  • Location: NSW - Sydney CBD