Payroll Data AnalystCarePartners • Guelph, ON
Payroll Data Analyst
CarePartners • Guelph, ON
4 days ago
Job type
- Full-time
Job descriptionAnalyze payroll data to identify trends, discrepancies, and anomalies across pay periods. Support payroll variance analysis including earnings, deductions and retroactive pay. Assist with payroll reconciliations including payroll to GL, benefits, pension, and statutory remittances. Validate payroll outputs to ensure accuracy, completeness, and compliance with legislative and collective agreement requirements. Investigate payroll data issues and partner with Payroll Manager, HR, and Finance on root cause resolution. Support payroll audits, internal controls, and compliance reviews by preparing data, reconciliations, and documentation. Prepare regular and ad-hoc payroll reports for Finance, HR, and management teams. Develop and maintain standardized payroll reporting tools and dashboards. Conduct data audits to ensure consistency across payroll, HRIS, and financial systems. Support union and regulatory reporting requirements as needed. Translate complex payroll data into clear, actionable insights for stakeholders. Build and maintain Excel-based reporting tools using advanced formulas, pivot tables, and Power Query. Support payroll system reporting and data extracts. Assist with payroll system implementations, upgrades, testing, and data validation. Identify opportunities to streamline, automate, and improve payroll reporting and data processes. Maintain documentation related to payroll data flows, reports, and controls. Maintain working knowledge of payroll administration processes to support operational continuity. Provide backup support for payroll administrative functions during peak processing periods, planned absences, or unplanned coverage needs. Assist with year-end processes including T4 preparation, reconciliations, and audit support. Assist with payroll data entry validation, reconciliations, and issue resolution as required to ensure timely and accurate payroll execution. Support knowledge transfer, documentation, and cross-training to strengthen payroll team continuity. Escalate risks, capacity gaps, or operational concerns impacting payroll delivery. Other duties as assigned. College or university diploma in Analytics, Accounting, Business, Finance, Information Systems, or a related field. Minimum 3 years of experience in a data analyst or similar analytical role, ideally within a payroll, benefits, HR or healthcare environment. Payroll Compliance Practitioner (PCP) is an asset. Demonstrated expertise in data analysis, validation, and reconciliation with the ability to interpret large, complex datasets with a high degree of accuracy. Expert knowledge in Microsoft Excel. Advanced knowledge of data validation and automation techniques such as PowerBI, PowerQuery or equivalent reporting and analytics platforms. Proven experience developing recurring and ad hoc reports, reconciliations, variance analysis and audit ready documentation. Knowledge of Canadian payroll legislation and statutory requirements preferred with the ability to apply legislative context to data analysis and reporting. Experience working with payroll and / or HRIS systems. Ability to maintain confidentiality and handle sensitive information with discretion. Experience in a unionized or multi-entity payroll environment considered an asset. Excellent written and verbal communication skills, with the ability to translate complex data into clear, actionable insights for HR, Finance, and senior leadership. Strong stakeholder engagement skills, including requirements gathering, presenting findings, and supporting data-driven decision-making. Familiarity with data governance principles, including data quality controls, documentation, access controls, and privacy standards, metadata documentation, security controls, and data privacy standards. Proven ability to conduct ad hoc analysis in response to urgent or complex payroll, compliance inquiries. Demonstrated ability to collaborate with cross-functional teams to resolve data discrepancies, improve reporting accuracy, and enhance process controls. Strong partnership mindset with HR, Finance, and Payroll Operations to align analytics with business and compliance needs.
Overview
The Payroll Data Analyst is responsible for supporting the accuracy, integrity, and analysis of payroll data through reporting, reconciliation, audit support, and process improvement. This role bridges payroll operations and analytics, transforming complex payroll and benefits data into reliable insights that support compliance, internal controls, and informed decision-making. With strong analytical and technical expertise, the Payroll Data Analyst plays a critical role in maintaining payroll data integrity, identifying trends and variances, and supporting continuous improvement across payroll operations.
In addition, the Payroll Data Analyst provides contingency support to payroll operations by maintaining working knowledge of payroll administration processes and assisting during peak periods, absences, or business continuity events.
This is a full-time position based out of our Waterloo Corporate office.
What We Offer
- Competitive Salary
- Comprehensive benefits package including Life Insurance
- Matching RRSP contribution
- Paid time off
- Leadership development programs
- Access to exclusive employee deals and discounts
- This position offers a competitive compensation range. The salary range is $55,000 to $70,000 , and placement within the range will be determined in accordance with company policies and procedures, as well as the candidate’s knowledge, skills, qualifications, and relevant experience.
What The Role Involves
What You Bring
CarePartners In Your Community
In addition to providing home-based personal support, rehabilitation, therapy, nursing and palliative care across Ontario, CarePartners also serves the community through clinics, transitional care units, and provides relief in nursing homes and shared care settings. Through our Community Nursing Services outreach program, we’ve been organizing medical care and clinics in countries with poor access to health care since 2009.
Accessibility
CarePartners welcomes and encourages applicants from people with disabilities. Candidates can request accommodations at any time in the hiring process.
Artificial Intelligence
CarePartners uses iCIMs as part of our recruitment and hiring process. While we incorporate select Artificial Intelligence (AI) features to enhance process efficiency, we remain committed to human-led decision making. All AI-generated outputs are subject to human review to ensure accuracy and fairness.
This job posting is available due to an existing vacancy.
Create a job alert for this search
Payroll Data Analyst • Guelph, ON
Similar jobs
We're now accepting participants for focus group studies! You can earn up to $750 per week working part-time from home.Simply register to see if you qualify—no experience as an administrative assis...Show more
Duckcreek Business Analyst with Policyholder experience.We at Coforge are hiring a Duckcreek Business Analyst with Policyholder experience with the following skillset : .
Duck Creek Expertise : Hands-...Show more
Superprof is Canada's #1 tutoring platform, and we're actively recruiting passionate tutors! Whether you're a student, a professional, or simply someone who loves teaching, join the largest communi...Show more
Position Summary : We are seeking an experienced UKG Timekeeping Lead to lead the strategic oversight a...Show more
Dayforce WFM / Time, HR Core with Entitlements experience.Dayforce WFM (HR Core, Time, Entitlements) module.Support and Testing background could be beneficial.
Client-facing skills; Excellent written ...Show more
A leading Canadian financial services co-operative is seeking a Metrics and Data Reporting Analyst to improve operational efficiencies and support data-driven decisions.
This role requires three yea...Show more Superprof is Canada's #1 tutoring platform, and we're actively recruiting passionate tutors! Whether you're a student, a professional, or simply someone who loves teaching, join the largest communi...Show more 
Senior Lead Consultant – Oracle Cloud HCM (Payroll – Canada).Calling all Canadian payroll experts.Senior Lead Consultant, Oracle Cloud HCM (Payroll).
Oracle Cloud HCM Payroll implementation focused ...Show more
Job Title : Payroll and HR Specialist.Location : Hybrid (Cambridge, Arthur, Drayton, Woodstock, and Guelph).Report to : Strategic HR and OD Manager.
The Payroll & HR Specialist is responsible for the a...Show more
Week 1 : Monday, Tuesday, Friday, Saturday.Week 2 : Sunday, Wednesday, Thursday.Must hold an Ontario or Inter-Provincial 433A Millwright Certificate.
As a Maintenance Millwright at Cargill, you will b...Show more
ABOUT THE UPPER GRAND DISTRICT SCHOOL BOARD (UGDSB).The UGDSB employs a team of approximately 6,500 dedicated staff who serve more than 35,000 students attending a variety of programs across 66 ele...Show more Senior Lead Consultant – Oracle Cloud HCM (Payroll – Canada).Calling all Canadian payroll experts.Senior Lead Consultant, Oracle Cloud HCM (Payroll).
Oracle Cloud HCM Payroll implementation focused ...Show more 
Equity Partner – Location : Remote (Canada) Jurisdiction : Global Minimum commitment : 20 hours per week Reports To : IT lead Overview A Technic...Show more
The Enrollment Consultant is responsible for engaging and enrolling candidates into their Right Management service benefit program by providing a ‘best in class’ customer service ...Show more
Note : Dayforce Payroll implementation experience required.Requires a strong Dayforce Payroll consultant who has directly led the payroll workstream and has hands-on experience configuring, testing,...Show more
Note : Dayforce Payroll implementation experience required.Requires a strong Dayforce Payroll consultant who has directly led the payroll workstream and has hands-on experience configuring, testing,...Show more
We’re looking for enthusiastic, self-driven, individuals to assist existing and prospective clients within our organization.
This position will work with multiple clients throughout the day pr...Show more
Our client is hiring an Full Stack Developer to support internal software development initiatives.The ideal candidate brings strong backend development experience, solid database...Show more
Administrative Assistant Admin Work At Home - Part-Time Online Focus Group Panel
ApexFocusGroup • Amaranth, Ontario, Canada
Remote
Full-time +2
Last updated: 30+ days ago • Promoted
Duckcreek Business Analyst with Policyholder experience
Coforge • guelph, on, ca
Full-time
Last updated: 27 days ago • Promoted
Accounting Private Tutoring Jobs Dufferin County
Superprof • Dufferin County, Canada
Full-time +1
Last updated: 30+ days ago • Promoted
UKG Timekeeping Lead
Quality IT Resourcing • guelph, ON, ca
Full-time
Last updated: 6 days ago • Promoted
Payroll Consultant - guelph
Insight Global • guelph, on, ca
Temporary
Last updated: 3 days ago • Promoted
Hybrid Data & Metrics Reporting Analyst
Co-operators Group • Guelph
Full-time
Last updated: 2 days ago • Promoted
Statistics Private Tutoring Jobs Dufferin County
Superprof • Dufferin County, Canada
Full-time +1
Last updated: 30+ days ago • Promoted
Payroll Consultant
Codex • guelph, on, ca
Full-time
Last updated: 3 days ago • Promoted
Payroll and HR Specialist
CG Wellington • Guelph, Guelph / Eramosa
Full-time
Last updated: 13 days ago • Promoted
Licensed Millwright - Dunlop Facility
Cargill • Grand Valley, ON, CA
Full-time
Last updated: 27 days ago • Promoted
26OCT03 - Payroll Analyst - Guelph Board Office - REPOST
Upper Grand District School Board • Guelph, ON, Canada
Full-time +1
Last updated: 6 days ago • Promoted
Payroll Consultant - Codex
Codex • guelph, on, ca
Full-time
Last updated: 3 days ago • Promoted
Technical Lead
Anime Universe • guelph, ON, ca
Full-time
Last updated: 4 days ago • Promoted
Enrollment Consultant
Right Management • guelph, ON, ca
Full-time +1
Last updated: 20 days ago • Promoted
Dayforce HCM Payroll Implementation Consultant
PayTech • guelph, ON, ca
Full-time
Last updated: 15 days ago • Promoted
Dayforce HCM Payroll Implementation Consultant - guelph
PayTech • guelph, on, ca
Full-time
Last updated: 15 days ago • Promoted
Sales Representative - 60k / Year - Remote
Spade Recruiting • Melancthon, Ontario
Remote
Full-time
Quick Apply
Last updated: 5 days ago • Promoted
Full Stack Engineer
Set 2 Close | B Corp • cambridge, ON, ca
Full-time
Last updated: 11 days ago • Promoted