PMO Manager, Capital Projects & Reporting

Canadian Pacific Railway Limited; Kansas City (MO); On-site; USD 110,000 - 150,000; Full time

Benefits offered by this job

Flexible benefits package

Pension/retirement plans

Employee stock purchase plan

Annual fitness subsidy

Background checks and verification

Job summary

Canadian Pacific Railway Limited is seeking a PMO Manager to support engineering leadership with transparent reporting on a $1.2B capital program across North America. You will deliver monthly insights, forecasts, and control improvements, coordinating with field personnel, project owners, and finance.

The role requires 5+ years in reporting and program controls, proficiency in Excel and Power BI, and a drive to enhance reporting transparency.

Qualifications

• Bachelor’s degree in Engineering, Finance, Accounting, or related field.
• 5+ years of relevant experience in reporting, program controls, Engineering quality assurance or general analysis.
• Valid driver’s license.
• Proficiency in Excel (financial modeling, VBA, Power Query) and Power BI, with demonstrated AI prompting capability to enhance analysis and efficiency.
• Strong analytical and problem-solving skills.
• Ability to construct reporting templates and refine existing reports.
• Experience with SAP and data visualization tools is an asset.
• Railroad or transportation industry experience is an asset.

Responsibilities

• Develop monthly capital forecasts by gathering insights, analyzing outlooks, and identifying risks or areas of concern.
• Partner with engineering leadership to address performance challenges and drive actionable mitigation strategies.
• Identify budget constraints and scope changes, overseeing the Project Change Notice (PCN) process in alignment with engineering and finance.
• Contribute and lead monthly and annual review meetings with Assistant Chief Engineers to analyze results, drivers, and forecast refinements.
• Identify and advance opportunities to improve engineering performance, controls, and reporting transparency.
• Consolidate and refresh daily, weekly, and monthly reporting across multiple systems including ECC, S/4HANA, Excel, Power BI, and internal platforms.
• Support ad-hoc analyses, including project spend breakdowns, cost driver assessments, and detailed drill-downs across complex capital portfolios.

Skills

Excel

Power BI

VBA

Power Query

SAP

ECC

S/4HANA

Data visualization

Analytical thinking

AI prompting capability

Education

Bachelor’s degree in Engineering, Finance, Accounting, or related field

Tools

SAP

S/4HANA

ECC

Job description

Canadian Pacific Railway Limited is seeking a PMO Manager to support engineering leadership with transparent reporting on a $1.2B capital program across North America. You will deliver monthly insights, forecasts, and control improvements, coordinating with field personnel, project owners, and finance.

The role requires 5+ years in reporting and program controls, proficiency in Excel and Power BI, and a drive to enhance reporting transparency.