Revenue Performance Analyst - Montréal, Canada - Canadian National Railway

Canadian National Railway

Verified Company

Montréal, Canada

3 weeks ago

Posted by:

Sophia Lee

beBee Recruiter

Description

At CN, everyday brings new and exciting challenges.

You can expect an interesting environment where you're part of making sure our business is running optimally and safely―helping keep the economy on track.

We provide the kind of paid training and opportunities that long-term careers are built on and we recognize hard workers who strive to make a difference.

You will be able to thrive in our close-knit, safety-focused culture working together as ONE TEAM. The careers we offer are meaningful because the work we do matters. Join us

Job Summary

The Revenue Performance Analyst is responsible for preparing and overseeing a variety of financial and revenue reports for members of the Financial Planning and Sales and Marketing teams, as well as CN's Executives.

The incumbent interacts with Business Units (BUs) to gather detailed information and deliver insights for executive reporting purposes.

Moreover, the incumbent understands the performance of the business from a carload, revenue, same-store price (SSP), and Revenue Ton Miles (RTM) perspective as compared to the budget, forecast and previous year results.

Main Responsibilities

Revenue and Financial Analysis

Liaise with Marketing and other internal stakeholders by ensuring completeness and accuracy of the demand forecast and budgeting models and scenarios
Review the forecasting models in Systems, Applications, and Products (SAP) and Integrated Business Planning (IBP) on a regular basis to ensure the correct assumptions are being used to accurately forecast carloads, rates, RTMs, SSP, and revenues
Collect, proactively, the proposed Year-End Outlook (YEO) changes of the respective commodity groups with the financial and RTM impact, including the narrative and the story behind the changes, which are used in corporate strategic decision making and resource planning initiatives
Maintain the 3year Corporate Revenue and Demand Plan in order to provide the Executive Team with better understanding of the company's future growth and financial performance
Develop the linehaul budgets through the creation of various reports and inputs into SAP and IBP to ensure the output is reflective of what, when and where the BU is prepared to deliver for carloads, RTMs, SSP, and revenues
Actively participate in the company's month,quarter, and yearend processes by producing and analyzing various valuedriven Key Performance Indicators (KPIs)
Provide both quantitative and qualitative analyses and explanations at month and quarter end, which are used in internal and external Financial Disclosures

Same Store Price Analysis

Develop and maintain the corporate SSP and PVM (Price/Volume/Mix) model in SAP Business Objects (BO)
Manage the BU price exception requests via SharePoint, and lead the monthly Revenue Planning price exception meeting
Review the price exceptions coding in the system to ensure accuracy
Prepare and disseminate the monthly PVM and SSP results to the Marketing BUs and other Financial Planning stakeholders
Liaise with the BUs Directors of Marketing and Market Managers in the process of resolving any SSP discrepancies in and adjustments to the PVM
Participate and lead in the yearly Budget SSP target setting and maintain the SSP forecast

AAR Reporting and Process Optimization

Create insightful ad hoc financial planning reports supporting CN's goals
Review, streamline and automate Revenue Planning deliverables and processes to make them relevant and meaningful to the audience
Participate, support, and lead other ad hoc report requests and analyses

Working Conditions
The role has standard working conditions in an office environment with a regular workweek from Monday to Friday.

Due to the nature of the role, the incumbent must be able to meet tight deadlines, handle pressure and stress.

Requirements:

Experience

Minimum 3 years of experience in a Marketing, Finance, Accounting, or Logistics environment
Experience in project management and stakeholder engagement
Experience in month

- and quarter-end financial reporting and accounting closing cycles

Experience in forecasting and creating KPIs

Education/Certification/Designation

Bachelor's Degree in Commerce, or relevant Finance or Accounting field
Master's Degree in Business Administration
Chartered Professional Accountant (CPA)
Any designation for these above would be considered as an asset

Competencies

Knows the business and stays current on industry needs
Applies critical thinking
Demonstrates agility and drives change
Collaborates with others and shares information
Communicates with impact
Solves problems to create value

Technical Skills/Knowledge

Sound knowledge of CN including internal processes, external indicators and markets
Superior working knowledge of SAP BO (Marketing Waybill, Revenue Forecast, and Costing File)
Superior working knowledge of Excel (e.g., create complex models