Analyst/Specialist Revenue Planning and Reporting

• Req ID: 75654
• Department: Finance & Accounting
• Job Type: Full-Time
• Position Type: Non-Union
• Location: Calgary, Alberta
• Country: Canada
• % of Travel: 0-10%
• # of Positions: 1
• Job Available to: Internal & External
• Deadline to apply: 09/13/2019

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 cpr.ca to see the rail advantages of CP. 

PURPOSE OF THE POSITION:

Work with the Marketing team to develop corporate reporting as it relates to revenue, demand and key performance metrics across the planning horizon. Work with our internal customers to develop CP’s short term and long term revenue & demand forecast by utilizing advanced statistical methods and business knowledge.  Prepare, consolidate, and report out on demand as it relates to CP’s daily, monthly, quarterly, and yearly processes, and present relevant insight to meet stakeholder needs and build the best forecast available. Develop new reports using SAP BPC or BI, work to understand variance causes and their impact on internal and external reporting. Provide consolidation and communication of key forecast metrics for continuous improvement amongst the larger Revenue Planning team.

POSITION ACCOUNTABILITIES:

• Develop and execute daily, monthly, quarterly, yearly reports that illustrate how CP is performing to plan against key metrics;
• Manage relationships between finance and commercial for a portfolio of commodities aligned to a specific VP;
• Cross functional collaboration 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 CP;
• Assist in identifying and implementing process improvements and data maintenance to achieve business objectives that could be business and/or technical in nature;
• Using 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.

POSITION REQUIREMENTS:

• 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;
• Preference given to candidates with reporting experience;
• 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.

WHAT CP HAS TO OFFER:

• Flexible and competitive benefits package
• Competitive company pension plan
• Employee Share Purchase Plan
• Performance Incentive Program 
• Annual Fitness Subsidy

ADDITIONAL INFORMATION:

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").