Payroll Data Analyst Lead

HCR Permanent Search is currently working with a top manufacturing company in Brampton who needs to hire a Data Lead onsite hybrid.

Work Setting: Hybrid

Shift Schedule: Days

Location: Brampton

Contract Duration:Now through January 2, 2027.

Role Overview

The Data Lead is responsible for data conversion, extraction, transformation, validation, and sign off activities for payroll and time & attendance (WFM) systems. This role requires a highly organized, detail driven professional who can coordinate across divisions, resolve data issues, and deliver accurate, production ready data to Dayforce (or equivalent systems).

Responsibilities:

• Lead data extraction from legacy systems and validate divisional data requirements.
• Build and execute data transformation logic for Dayforce load templates.
• Review and sign off on payroll and WFM data mappings and functional documents.
• Perform post load validation across multiple data load cycles.
• Triage and resolve data errors; coordinate with divisions to correct source data.
• Ensure divisions update Workday and other source systems on schedule.
• Collaborate with leads on conversion strategy.
• Provide status updates, escalate risks, and maintain audit ready documentation.

Qualifications:

• Strong functional knowledge of US payroll data and processes.
• Advanced Excel (VLOOKUP/XLOOKUP, INDEX/MATCH, pivots, Power Query preferred).
• Experience with data extraction, transformation, and validation for payroll/WFM.
• Strong organizational skills and ability to meet tight deadlines.
• Excellent communication and stakeholder management skills.
• High attention to detail and accuracy.

Apply Now!

If you believe you are an outstanding candidate for this opportunity, we invite you to submit your resume and all relevant information to HCR Permanent Search in confidence to:

Matthew Snider

[email protected]

Please indicate the name of the position you are applying for in the subject heading. Only those selected to move forward in the consideration process will be contacted. Thank you for your interest!

HCR Permanent Search is recruiting on behalf of our client for an existing vacancy within their organization.

HCR Personnel Solutions Inc. welcomes applications from people with disabilities. Accommodation is available upon request for candidates taking part in all aspects of the recruitment and selection process.