HR Analytics Pro: Data-Driven Insights & Dashboards

Canadian Pacific Railway

Calgary

Hybrid

CAD 90,000 - 120,000

Full time

13 days ago

Application generator

A complete application in a minute — tailored resume and cover letter, ready to send.

Get past ATS filters

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, dashboards, and data-driven insights from Calgary or Kansas City. You will partner with HR and IS to manage analytics, translate data into actionable recommendations, and ensure accurate reporting using tools like Excel, Power BI, SAP Analytics Cloud, SAP, and SuccessFactors.

The role emphasizes data quality, governance, and the ability to translate business questions into analytical solutions while

Qualifications

Bachelor's degree in Statistics, Computer Science, Business Analytics, Human Resources, Economics, Finance, or a related field.
Minimum 4 years of progressively responsible experience in people analytics, HR reporting, business intelligence, data analysis, or a related field.
Advanced proficiency in Microsoft Excel and proficiency with at least one business‑intelligence platform such as Power BI, Tableau, or SAP Analytics Cloud.
Working to intermediate knowledge of SQL, data extraction, transformation, reconciliation, and analysis across multiple data sources.

Responsibilities

Prepare and deliver recurring and ad hoc workforce reporting, including headcount, vacancies, employee movement, turnover, workforce composition, and organizational structure.
Develop, maintain, and improve dashboards, scorecards, reports, and other analytical products.
Work with stakeholders to clarify business questions, define requirements, and recommend appropriate analytical approaches.
Analyze data to identify trends, variances, risks, and underlying drivers, and communicate what changed, why it matters, and where action may be required.
Connect workforce findings to broader business considerations such as cost, capacity, retention, productivity, and organizational effectiveness.
Validate and reconcile data from multiple sources, investigate anomalies, and work with stakeholders to resolve data-quality issues.
Maintain metric definitions, calculation logic, reporting documentation, quality-control procedures, and consistent reporting standards.
Ensure reporting complies with privacy, governance, policy, and regulatory requirements.
Identify opportunities to streamline, automate, consolidate, and improve recurring reporting processes.
Manage competing priorities, recurring deadlines, ad hoc requests, and stakeholder expectations.
Support workforce planning, forecasting, scenario analysis, and strategic HR initiatives.