Apply now »

Advisor Human Resource Analytics


Canadian Pacific (CP) and Kansas City Southern (KCS) are now CPKC. As the only truly North American railway, we are making big moves! Drawing on our strong foundations and heritage, CPKC moves essential goods across our 20,000-mile network to support economic growth throughout Canada, the U.S. and Mexico. Be a part of history as we connect a continent and create exciting career opportunities across our new transnational network. Visit to learn about the CPKC advantage, our purpose and culture.



This position manages human resources data analytics, reporting and KPI dashboard activities across the CPKC network in the U.S., Canada and Mexico. The role is responsible for gathering reporting requirements and understanding the business needs that go into HR analysis reporting. It requires close collaboration and partnership with HR technology teams, business stakeholders and HR leadership to translate requirements into concise, effective reports and analytics. The position holder needs to have a high attention to detail in order to proactively identify and correct reporting issues prior to publishing outputs.

The position holder should also be able to review output and perform effective data analysis, in order to develop an effective storyline that describes the data findings. Job duties will include creating and publishing data and analytics in common formats such as Microsoft Office, PowerBI Qlink or other related tools if avaialble.

This position also performs regular audits of HR data to ensure accuracy and completeness. 



  • Creates daily, monthly, quarterly and annual HR reporting, auditing, and analysis including headcount reporting and forecasting, open and filled position reporting, job change analysis, turnover and new hire reporting, organization chart governance, and other reporting as appropriate
  • Audits the accuracy of the HRIS system for data related to organization structure, job architecture and HR master data for both Management and Union employees within assigned countries
  • Publishes reporting materials for a variety of projects or programs such as new hires, position changes, employee diversity, turnover or other requests
  • Creates and publishes high-quality dashboards for the leadership team
  • Documents procedures to ensure compliance with CPKC policy and applicable government regulations, and proposes process changes to improve efficiency
  • Participates in HR projects involving compensation, HRIS, recruiting and/or benefits
  • Exemplifies CPKC Vision, Values, and Culture interactions with coworkers, business partners, customers and stakeholders



  • Bachelor's degree from an accredited university or college, preferably in a job related major field of study
  • Minimum five (5) years of relevant professional experience in HR reporting and analytics, or equivalent combination of education and experience
  • Expert-level knowledge of Microsoft Office tools including Excel, Word and PowerPoint



  • Experience using one or more dashboarding applications such as Microsoft PowerBI, Tableau or Google Analytics
  • Experience using and updating data in SAP or SuccessFactors
  • SQL and/or Microsoft Access experience



  • Flexible and competitive benefits package
  • Employer Funded Retirement Plan
  • Employee Share Purchase Plan
  • Performance Incentive Program
  • Annual Fitness Subsidy
  • Part-time Studies Program



As an employer with North American presence, the possibility does exist that the location of your position may be changed based on organizational requirements.


Drug Test Elements:

CPKC is committed to the safety and health of its employees and the general public.  All new hires are required to undergo a drug screen.  We appreciate your cooperation in keeping CPKC safe and drug free. 


Background Investigation:

The successful candidate will need to successfully complete the following clearances:       


  • Criminal history check
  • Reference check
  • Education verification
  • Last 3 years of driving history
  • Last 7 years of employment history; includes military service
  • Social Security number verification


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.


CPKC is an equal opportunity/affirmative action employer, inclusive of protected veterans and individuals with disabilities. 


  • Req ID: 101427
  • Department: Human Resources
  • Job Type: Full-Time
  • Position Type: Non-Union
  • Location: Kansas City, Missouri
  • Country: United States
  • % of Travel: 0-10%
  • # of Positions: 1
  • Job Grade: 3
  • Job Available to: Internal & External






Nearest Major Market: Kansas City

Apply now »