CarePartners · 18 hours ago
Payroll Data Analyst
CA-ON-Waterloo
Full-time
Onsite
Mid Level
$55K/yr - $70K/yr
3+ years expCarePartners is one of Ontario’s largest accredited home health care providers, providing nursing, personal support, therapy and rehabilitation support services for patients of all ages. The Payroll Data Analyst is responsible for supporting the accuracy, integrity, and analysis of payroll data through reporting, reconciliation, audit support, and process improvement.
Health CareNursing and Residential CareRehabilitation
Responsibilities
Analyze 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
Qualification
Required
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
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
Proven experience developing recurring and ad hoc reports, reconciliations, variance analysis and audit ready documentation
Ability to maintain confidentiality and handle sensitive information with discretion
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
Demonstrated ability to collaborate with cross-functional teams to resolve data discrepancies, improve reporting accuracy, and enhance process controls
Preferred
Payroll Compliance Practitioner (PCP) is an asset
Advanced knowledge of data validation and automation techniques such as PowerBI, PowerQuery or equivalent reporting and analytics platforms
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
Experience in a unionized or multi-entity payroll environment considered an asset
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
Benefits
Competitive Salary
Comprehensive benefits package including Life Insurance
Matching RRSP contribution
Paid time off
Leadership development programs
Access to exclusive employee deals and discounts
Company
CarePartners
For 40 years, CarePartners has been committed to delivering compassionate home and community health care services.
1001-5000 employees
Funding
Current Stage
Late StageLeadership Team
Ryan Strimple
Transportation Manager - CarePartners PACE
Recent News
Company data provided by crunchbase