Apply now »

Analyst/Specialist, Revenue Planning

Canadian Pacific (CP) and Kansas City Southern (KCS) are now CPKC. As the only truly North American railway, we are making big moves! Drawing on our strong foundations and heritage, CPKC moves essential goods across our 20,000-mile network to support economic growth throughout Canada, the U.S. and Mexico. Be a part of history as we connect a continent and create exciting career opportunities across our new transnational network. Visit to learn about the CPKC advantage, our purpose and culture.



As the Analyst/Specialist Revenue Planning you will partner with the Marketing team to develop corporate reporting as it relates to revenue, demand, and key performance metrics across the planning horizon. This role will work closely with our internal customers to develop CPKC’s short and long term revenue and demand forecast by utilizing advanced statistical methods and business knowledge.  Youl will prepare, consolidate, and report out on demand as it relates to CPKC’s daily, monthly, quarterly, and yearly processes, and present relevant insight to meet stakeholder needs and build the best forecast available. The key is to develop new reports using SAP BPC or BI, work to understand variance causes and their impact on internal and external reporting, and communicate consolidated key forecast metrics for continuous improvement amongst the larger Revenue Planning team.



  • Manage relationships between finance and commercial for a portfolio of commodities aligned to a specific VP including finance input on strategic initiatives
  • Partner with commercial to build achievable budgets and forecasts
  • Develop and execute daily, monthly, quarterly, yearly reports that illustrate how CPKC is performing to plan against key metrics
  • Collaborate cross functionally within finance and across other stakeholder groups to enable profitable, sustainable growth
  • Assist in the validation and publication of internal reporting as it relates to revenues, demand, and key metrics
  • Engage with the commercial team to identify market trends and demand changes to enable decision analysis
  • Monitor data integrity to ensure consistent reporting
  • Assist in the consolidation of revenue and key metric data for reporting purposes
  • Develop automated self-serve reports for use across CPKC
  • Assist in identifying and implementing process improvements and data maintenance to achieve business objectives that could be business and/or technical in nature
  • Use time series statistical forecasting techniques to develop a base plan
  • Collaborate with subject matter experts to enhance plan with specific customer details
  • Significant interaction with the business units to understand and articulate key drivers of change



  • Undergraduate degree in Commerce, Economics, or Business Administration
  • 1 to 2 years post-graduation experience an asset
  • Understanding of Marketing & Sales issues, company forecasting, and metrics
  • Demonstrated capability to interpret a wide array of information and determine key messages
  • BPC, BI and SAP experience an asset
  • Strong computer skills, including advanced knowledge of Microsoft Excel and PowerPoint
  • Must be comfortable using complex formulas and pivot tables in Excel
  • Advanced analytics
  • Financial acumen
  • Ability to multi-task in a fast paced environment
  • Ability to clearly communicate both written and oral
  • Strong organizational, time management and relationship management skills
  • Able to work independently, and dig into technical anomalies to drive clarity and resolve problems
  • Ability to bridge the gap between analytics and business understanding



  • Flexible and competitive benefits package
  • Competitive company pension plan
  • Employee Share Purchase Plan
  • Performance Incentive Program
  • Part-time Studies Program
  • Flexible Work Environment 



As an employer with national presence, the possibility does exist that the location of your position may be changed based on organizational requirements.


Background Investigation:

The successful candidate will need to successfully complete the following clearances:             

  • Criminal history check;
  • Reference check.


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.


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




Apply now »