Apply now »

Analyst/Specialist Revenue Reporting

  • Req ID: 83026
  • 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: 4/5
  • Job Available to: Internal & External
  • Deadline to apply: 03/05/2021



Canadian Pacific is a transcontinental railway in Canada and the United States with direct links to major ports on the west and east coasts. CP provides North American customers a competitive rail service with access to key markets in every corner of the globe. CP is growing with its customers, offering a suite of freight transportation services, logistics solutions and supply chain expertise. Visit to see the rail advantages of CP. 



The purpose of the Analyst/Specialist Revenue Reporting role is to develop corporate reporting as it relates to year-over-year demand, revenue, yield and key performance metrics. The key is to prepare and consolidate accurate and timely analysis to stakeholders such as Finance, Sales and Marketing and the external community. The role will work to develop new reports using SAP BPC or BI, to aid in the analysis of variance causes and their impact on internal and external reporting.



  • Develop and execute daily, monthly, quarterly, yearly reports that illustrate how CP is performing to plan against key metrics;
  • Assist in the validation and publication of internal reporting as it relates to revenues, demand and key metrics;
  • Report weekly metrics on CP’s external website;
  • Complete relevant sections of the quarterly Management Discussion and Analysis, and Annual Report;
  • 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 CP;
  • Assist in identifying and implementing process improvements and data maintenance to achieve business objectives that could be business and/or technical in nature;
  • 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 is preferred;
  • 1 to 2 years post qualification 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;
  • Preference given to candidates with reporting experience;
  • BPC and BI 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 
  • Annual Fitness Subsidy




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 CP. You may be required to obtain a certification or to maintain your current certification/qualification as a conductor or locomotive engineer.


CP is an equal opportunity employer committed to the principles of employment equity and inclusion. We welcome applications from all qualified individuals. All applicant information will be managed in accordance with the federal Personal Information Protection and Electronic Documents Act ("PIPEDA").

Apply now »