Payroll Data Analyst

Zone IT Solutions; Melbourne; On-site; AUD 90,000 - 130,000; Full time

Job summary

Zone IT Solutions is seeking an experienced Payroll Data Analyst to work with live payroll data across Oracle HCM, Kronos, SAP, JD Edwards and ServiceNow. You will define data reads, profile extracts, establish baselines and validate the prototype against payroll results.

You will obtain and document field definitions, volumes and quality for each source, support data mapping, and ensure accurate reconciliation and data quality throughout the project.

Qualifications

• Experience profiling real payroll and time extracts.
• Strong SQL and data quality experience.
• Familiarity with Oracle HCM Cloud data and HCM Extracts.

Responsibilities

• Obtain and profile real extracts from Oracle HCM, Kronos, SAP and JDE pay results, ServiceNow tickets, and document each source's fields, volumes and quality.
• Agree the classification per data set with Downer Cyber, defining what is tokenised and who may see it.
• Specify the HCM objects, fields, extracts and Atom feeds the platform needs, the drift by attribute and the starter and change field sets per payroll.
• Build the de-identified validation set using real people, periods and their actual pay results, and run comparisons against the prototype's engine with the AI Engineer, classifying every difference.
• Define the target data model, finance feed format and reconciliation the platform must pass.

Skills

SQL

Data profiling

Data quality

Payroll data

Tools

Oracle HCM Cloud

HCM Extracts

REST APIs

Kronos

SAP

JD Edwards

ServiceNow

Job description

We are looking for an experienced Payroll Data Analyst who can work with Downer's real data across Oracle HCM, Kronos, SAP, JD Edwards and ServiceNow. The role involves obtaining and profiling data extracts, defining what the platform needs to read from each source, establishing baselines and validating the prototype against actual payroll results.

Key Responsibilities:

• Obtain and profile real extracts from Oracle HCM, Kronos, SAP and JDE pay results, ServiceNow tickets, and document each source's fields, volumes and quality.
• Agree the classification per data set with Downer Cyber, defining what is tokenised and who may see it.
• Specify the HCM objects, fields, extracts and Atom feeds the platform needs, the drift by attribute and the starter and change field sets per payroll.
• Build the de-identified validation set using real people, periods and their actual pay results, and run comparisons against the prototype's engine with the AI Engineer, classifying every difference.
• Define the target data model, finance feed format and reconciliation the platform must pass.

Required Skills:

• SQL and data profiling over raw payroll and time extracts.
• Reconciliation and data quality experience with payroll data.
• Oracle HCM Cloud data, HCM Extracts or REST resources, from an integration or migration.

About Us

We specialize in Digital, ERP, and larger IT Services. We offer flexible, efficient and collaborative solutions to any organization that requires IT, experts. Our agile, agnostic, and flexible solutions will help you source the IT Expertise you need.

Zone IT Solutions is an equal opportunity employer and our recruitment process focuses on essential skills and abilities. We encourage applications from a diverse array of backgrounds, including individuals of various ethnicities, cultures, and linguistic backgrounds, as well as those with disabilities.