Analyst, Demand & Resource Planning

• Req ID: 75382
• 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: 05/22/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. For more on our purpose, culture, and strategy, visit cpr.ca/en/about-cp.

PURPOSE OF THE POSITION:

The purpose of the Analyst – Demand and Resource Planning role is to develop, maintain and continually improve demand and supply modeling to provide insight and recommendations for planning and decision making across multiple stakeholder groups. The key is to work closely with the Sales and Marketing teams to understand current and future demand projections so that assessments of operational capabilities can be drawn and decisions can be made to drive value at the lowest total cost.  The role ensures accurate and timely delivery of outputs to stakeholders such as Market Strategy and Asset Management, and Service Design for decision making.

POSITION ACCOUNTABILITIES:

• Develops and delivers workload forecasts including train miles, GTMs, train lengths and train weights;
• Uses time series statistical forecasting techniques to develop a base plan;
• Ensures forecasts are aligned with targets and executes reports that illustrate how CP is performing to plan against key metrics;
• Produces train productivity variance reports and develops analysis of the drivers of the variance;
• Reviews and interprets results to drive action with appropriate stakeholders;
• Leads the identification and development of continuous improvement to existing models in order to drive efficiency and timeliness of outputs;
• Monitors data integrity to ensure consistent reporting;
• Presents/delivers demand & resource priorities to senior operations management, commercial management, and finance stakeholders up to and beyond 24 months out;
• Collaborates 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;
• Develops tools, methods and analyses that reflect or provide insight into the drivers of total network cost and enable the provision of prospective cost to serve for new or changing segments of the business.

POSITION REQUIREMENTS:

• Undergraduate degree in Business, Math or Science is preferred;
• 1 to 2 years post qualification experience an asset;
• Strategic/decision analysis including decision quality (problem framing, development of alternatives, evaluation of trade-offs and recommendation development);
• Strong computer skills, including advanced knowledge of Microsoft Excel and PowerPoint; must be comfortable using complex formulas and pivot tables in Excel;
• Advanced modeling ability, capable of working with and manipulating big data;
• Financial acumen to support cost to serve and estimation of benefits to support strategic initiatives;
• Strong written and oral communication skills and ability to articulate key insights;
• Proven ability to manage relationships across the enterprise and to develop new relationships as required;
• Strong capability to simplify communication around complicated business problems;
• Advanced analytics;
• Ability to multi-task in a fast paced environment;
• 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").