Analyst Resource and Capacity Planning

JobsCloseBy Editorial Insights

CPKC is seeking an Analyst, Resource and Capacity Planning to join their Finance & Accounting team, full-time on-site in Calgary or Kansas City. The role drives demand and resource alignment by building planning models, running scenario analyses, and delivering forward-looking capacity insights for trains, crews, locomotives, and track constraints. It requires 1-3 years of experience, a bachelor’s degree in Commerce, Economics, or Math, advanced Excel and data skills, and strong communication. Success comes from turning data into actionable recommendations, partnering with cross-functional teams, and improving forecast accuracy. Applicants should tailor resumes to forecasting, data quality, and dashboarding; be ready for drug testing and background checks, and note travel 0-10% and potential location change.

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