At CN,everyday brings new and exciting challenges. You can expect an interestingenvironment 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 3-year 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 line-haul 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 year-end processes by producing and analyzing various value-driven 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
o Experience in project management and stakeholder engagement
o Experience in month- and quarter-end financial reporting and accounting closing cycles
o 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, formulas, pivot tables and power pivot reports)
• Knowledge Power BI, Tableau and SAP, IBP*
*Any knowledge for any of the above would be considered as an asset
CN is a world-class transportation leader and trade-enabler. Essential to the economy, to the customers, and to the communities it serves, CN safely transports more than 300 million tons of natural resources, manufactured products, and finished goods throughout North America every year. As the only railroad connecting Canada’s Eastern and Western coasts with the Southern tip of the U.S. through a 19,500 mile rail network, CN and its affiliates have been contributing to community prosperity and sustainable trade since 1919. CN is committed to programs supporting social responsibility and environmental stewardship. At CN, we work as ONE TEAM, focused on safety, sustainability and our customers, providing operational and supply chain excellence to deliver results.
