Analyst Resource and Capacity Planning

JobsCloseBy Editorial Insights

CPKC is seeking an Analyst, Resource and Capacity Planning to deliver integrated, forward-looking capacity insights across the network. The role, based in Calgary or Kansas City, reports into Finance & Accounting and involves building and refining planning models, conducting scenario analyses, and delivering monthly to multi-year resource forecasts covering trains, crews, locomotives, and track capacity, plus KPIs and variance reporting. Requirements include a Bachelor’s in Commerce, Economics, or Math, 1–3 years of relevant experience, strong Excel and data manipulation skills, familiarity with databases, and ideally SQL. Apply with a resume that demonstrates forecasting concepts, data quality improvements, cross-functional collaboration, and clear storytelling. Emphasize communication, problem solving, and the ability to handle large datasets. CPKC promotes inclusion and development opportunities.

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:

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: 106063
• Department: Finance & Accounting
• Job Type: Full-Time
• Position Type: Non-Union
• Location: Calgary, Alberta
• Country: Canada
• % of Travel: 0-10%
• # of Positions: 1
• Job Grade: 5
• Job Available to: Internal & External

#LI-ONSITE

#LI-JA1