PMO Manager — Capital Programs & Reporting

Canadian Pacific Kansas City; Kansas City (MO); On-site; USD 120,000 - 180,000; Full time

Benefits offered by this job

Flexible benefits package

Pension plan and/or retirement plans

Employee share purchase plan

Annual fitness subsidy

Part-time studies program

Job summary

Canadian Pacific Kansas City (CPKC) is seeking a PMO Manager to support engineering leadership with timely, accurate capital portfolio reporting for a $1.2B program across North America. The role partners with field personnel, project owners, and finance to provide monthly insights, production reviews, and forecast accuracy.

Responsibilities include developing forecasts, driving actionable mitigation strategies, and enhancing project controls and KPI visibility using SAP, Power BI, and Excel.

Qualifications

• Bachelor's degree in Engineering, Finance, Accounting, or related field.
• 5+ years of experience in reporting, program controls, or related analysis.
• Proficiency in Excel (financial modeling, VBA, Power Query) and Power BI.
• Experience with SAP is an asset and data visualization tools are a plus.

Responsibilities

• Develop monthly capital forecasts and identify risks or concerns.
• Collaborate with engineering leadership to address performance and mitigation strategies.
• Oversee budget constraints and PCN processes with engineering and finance.
• Lead monthly/annual reviews with engineers to analyze results and forecasts.
• Improve reporting transparency and controls across multiple systems.
• Contribute to ad hoc analyses including spend breakdowns and drilldowns.

Skills

Analytical thinking

Cross-functional communication

Problem solving

Attention to detail

AI prompting capability

Education

Bachelor's degree in Engineering/Finance/Accounting

Tools

Excel

Power BI

VBA

SAP

Job description

Canadian Pacific Kansas City (CPKC) is seeking a PMO Manager to support engineering leadership with timely, accurate capital portfolio reporting for a $1.2B program across North America. The role partners with field personnel, project owners, and finance to provide monthly insights, production reviews, and forecast accuracy.

Responsibilities include developing forecasts, driving actionable mitigation strategies, and enhancing project controls and KPI visibility using SAP, Power BI, and Excel.