HR Analytics Lead: Dashboards & Insights

Canadian Pacific Railway; Kansas City (MO); Hybrid; USD 80,000 - 110,000; Full time

Benefits offered by this job

Flexible benefits package

Pension/retirement plans

Employee Share Purchase Plan

Performance Incentive Plan

Annual Fitness Subsidy

Job summary

Canadian Pacific Railway is seeking an HR Analytics Specialist to deliver workforce reporting and dashboards from Calgary or Kansas City. You will partner with HR and IS teams to translate data into actionable recommendations and ensure accurate, business-aligned insights using Excel, Power BI, SAP Analytics Cloud, SAP, and SuccessFactors.

Responsibilities include preparing headcount and turnover analyses, building dashboards, and guiding stakeholders on analytical approaches while maintaining

Qualifications

• Bachelor’s degree in Statistics, CS, Business Analytics, HR, Economics, Finance, or related field.
• Minimum 4 years of experience in people analytics or HR reporting.
• Advanced proficiency in Microsoft Excel and at least one BI platform (Power BI, Tableau, or SAP Analytics Cloud).
• Working knowledge of SQL, data extraction, transformation, reconciliation, and analysis across multiple data sources.
• Experience with SAP HCM, SuccessFactors, or similar HR information system preferred.
• Strong analytical, problem-solving, and data storytelling skills.

Responsibilities

• Prepare recurring and ad hoc workforce reporting (headcount, vacancies, movement, turnover, composition).
• Develop, maintain, and improve dashboards, scorecards, reports, and analytical products.
• Clarify business questions, define requirements, and recommend analytical approaches.
• Analyze data to identify trends, variances, risks, and underlying drivers; communicate implications and actions.
• Connect workforce findings to cost, capacity, retention, productivity, and organizational effectiveness.
• Validate and reconcile data from multiple sources and address data-quality issues.

Skills

Excel

Power BI

SQL

Data analysis

Data storytelling

Problem solving

Stakeholder collaboration

Education

Bachelor's degree in Statistics, Computer Science, Business Analytics, HR, Economics, Finance, or related field

Tools

SAP Analytics Cloud

Power Query

DAX

Job description

Canadian Pacific Railway is seeking an HR Analytics Specialist to deliver workforce reporting and dashboards from Calgary or Kansas City. You will partner with HR and IS teams to translate data into actionable recommendations and ensure accurate, business-aligned insights using Excel, Power BI, SAP Analytics Cloud, SAP, and SuccessFactors.

Responsibilities include preparing headcount and turnover analyses, building dashboards, and guiding stakeholders on analytical approaches while maintaining