Analyst Resource and Capacity Planning

Join CPKC, North America’s first transnational railroad connecting U.S., Canada, and Mexico, where your career drives progress and safety is paramount. We connect communities, fuel economic growth, and provide meaningful work in a culture that values diversity, accountability, and pride. With opportunities for training, development, and advancement, you’re not just building a career—you’re part of something bigger. Together, we move goods, connect people, and create lasting change. Your future starts here.   PURPOSE OF THE POSITION: The Analyst, Resource and Capacity Planning role enables decision‑making by aligning demand and resource strategies to deliver an integrated, forward‑looking view of network capacity and capability. The role leads the development and evolution of planning models, scenario analyses, and strategic insights to assess alternative models and articulate the value of change.   This position can be based in Calgary or Kansas City.   POSITION ACCOUNTABILITIES: Prepare monthly, annual, and multi‑year resource planning forecasts, including train and crew starts, locomotive productivity and requirements, track capacity needs, and key performance indicators Analyze operational data to ensure accuracy, consistency, and alignment with business performance assumptions Work with business partners to identify trends, support decision‑making, and improve forecast accuracy over time Maintain and enhance planning models, applying strong analytical skills to resolve data or modeling issues and recommend process improvements Conduct ad hoc and scenario analysis to assess incremental growth and capacity impacts, coordinating with cross‑functional teams to confirm supply plans are achievable Produce variance reporting and scorecards comparing corporate targets to the rolling forecast and actual results Collect, validate, and improve data quality, summarizing findings and providing clear insights and recommendations to stakeholders   POSITION REQUIREMENTS: Bachelor’s degree in Commerce, Economics, Mathematics or a related field 1 - 3 years of relevant work experience; experience in rail, transportation, or supply chain is an asset, but not required. Working knowledge of forecasting concepts, including key performance indicators, demand, and supply fundamentals Strong computer skills, including advanced Excel; experience with databases and standard word‑processing tools. Familiarity with SQL is considered an asset. Excellent written and verbal communication skills Strong problem‑solving and analytical skills Proven ability to use Excel to manipulate and analyze large data sets   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   PRE-EMPLOYMENT REQUIREMENTS:  Drug Testing This position is subject to a negative company drug test.   Background Investigation Criminal history check Education verification Professional references Social Security Number verification   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: 106062 Department: Finance & Accounting Job Type: Full-Time Position Type: Non-Union Location: Kansas City, Missouri Country: United States % of Travel: 0-10% # of Positions: 1 Job Grade: 5 Job Available to: Internal & External   #LI-ONSITE #LI-JA1