Specialist HR Analytics
Job Fit Check
Base Career helps you apply smarter for this job.
Key skills for this role
Key Skills for This Role
Full Job Posting
PURPOSE OF THE POSITION
The Specialist HR Analytics role, based in Calgary or Kansas City, is responsible for delivering workforce reporting, dashboards, and data-driven insights to support HR and business decision-making. The position partners with stakeholders across HR and Information Services to manage recurring and ad hoc analytics, translate workforce data into actionable recommendations, and leverage tools such as Excel, Power BI, SAP Analytics Cloud, SAP, and SuccessFactors to ensure accurate, meaningful, and business-aligned reporting.
POSITION ACCOUNTABILITIES
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
POSITION REQUIREMENTS
- 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
- Experience with SAP HCM, SuccessFactors, or a comparable HR information system is preferred
- Strong analytical, problem-solving, and root-cause analysis skills
- Demonstrated ability to translate business needs into reports, dashboards, measures, and analytical solutions
- Strong data-storytelling skills, including the ability to explain findings, implications, and recommended actions
- Strong attention to detail and commitment to data accuracy, consistency, documentation, and governance
- Ability to work independently, manage competing priorities, and collaborate effectively with technical and non-technical stakeholders
- Sound judgment in handling confidential and sensitive employee information
- Experience developing executive or senior-leadership dashboards and analytical narratives
- Experience with Power Query, DAX, data models, reporting automation, workforce planning, forecasting, retention, or workforce-cost analysis
- Experience working in a large, complex, unionized, regulated, or multinational organization
WHAT CPKC HAS TO OFFER
Flexible and competitive benefits package
Competitive company pension and/or retirement plans
Employee Share Purchase Plan
Performance Incentive Plan
Annual Fitness Subsidy
Part-time Studies Program
Background Investigation
Criminal history check
Education verification
Professional references
BECOMING A RAILROADER
As an employee with a North American presence, the possibility does exist that the location of your position may be changed based on organizational requirements.
Management Conductor Program
Becoming a qualified conductor or locomotive engineer is the single best way for a management employee to learn the business at CPKC. You may be required to obtain a certification or to maintain your current certification/qualification as a conductor or locomotive engineer.
CULTURE OF INCLUSION
For our U.S. applicants, CPKC is an equal opportunity/affirmative action employer, inclusive of protected veterans and individuals with disabilities. For Canadian applicants CPKC is an employment equity employer committed to the principles of employment equity and inclusion. We encourage all qualified candidates to apply including: women, Black, Indigenous, People of Color (BIPOC), members of the LGBTQ+ community and people with disabilities. Accommodations for the job application process can be provided, as appropriate, upon request. All applicant information will be managed in accordance with the federal Personal Information Protection and Electronic Documents Act (PIPEDA).
Req ID: 106297
Department: Human Resources
Job Type: Full-Time
Position Type: Non-Union
Location: Calgary, Alberta
Country: Canada
% of Travel: 0-10%
# of Positions: 1
Job Grade: 4
Job Available to: Internal & External
#LI-ONSITE
#LI-JA1
Start apply with LinkedIn
Apply Now
Please wait...
About CPKC
Transnational rail network linking Canada, the United States, and Mexico.
Visit company websiteJobs and hiring trendsApply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at CPKC
Diesel Service Attendant
, CAN
Assistant Director Signals and Communications
, CAN
Train Conductor
Medicine Hat, CAN
Specialist Track Design
Calgary, CAN
Train Conductor
Moose Jaw, CAN
Diesel Mechanic
Golden, CAN
Specialist Functional Analyst SAP HCM
Calgary, CAN
Coordinator Customer Solutions
Winnipeg, CAN