Remote HCM & Dayforce Reporting Analyst (SQL + Power BI)

Dexterra Group; Mississauga; Remote; CAD 80,000 - 100,000; Full time

Benefits offered by this job

Fully Remote work model

Competitive compensation

401k, medical, dental, vision, paid 시간

Award winning safety culture

Growth opportunities

Job summary

Dexterra Group is seeking an experienced HCM & Reporting Analyst for an 8-month contract to support Dayforce implementation. You will focus on reporting, data transformation, validation, and reconciliation, handling complex HR/payroll data and building custom Dayforce reports and dashboards.

You will translate reporting needs into dependable technical solutions and collaborate with cross-functional teams. You will develop SQL queries, create Power BI dashboards, and ensure data migration

Qualifications

• Dayforce reporting experience, including custom report development.
• Advanced SQL skills and experience working with large datasets.
• Experience with HR, payroll, workforce management, or HCM data.
• Power BI and advanced Excel expertise.
• Experience supporting HR technology, payroll, or HCM implementations.
• Strong analytical, problem-solving, and stakeholder communication skills.

Responsibilities

• Build and maintain Dayforce reports, dashboards, and workforce analytics solutions.
• Develop SQL queries to analyze, validate, and troubleshoot HR and payroll data.
• Support employee data migration, reconciliation, and reporting readiness for Dayforce.
• Partner with HR, Payroll, Finance, and IT to deliver meaningful workforce insights.
• Support testing, go-live activities, and post-implementation stabilization.
• Develop Power BI dashboards and reporting standards to support business decision-making.

Skills

Dayforce reporting experience

Advanced SQL skills

HR/HCM data

Stakeholder communication

Analytical problem-solving

Tools

Power BI

Excel

Job description

Dexterra Group is seeking an experienced HCM & Reporting Analyst for an 8-month contract to support Dayforce implementation. You will focus on reporting, data transformation, validation, and reconciliation, handling complex HR/payroll data and building custom Dayforce reports and dashboards.

You will translate reporting needs into dependable technical solutions and collaborate with cross-functional teams. You will develop SQL queries, create Power BI dashboards, and ensure data migration