Sr. Financial Analyst, Commercial FP&A

Day & Ross

$75K — $95K *
Finance & Insurance
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • 3-6 years in FP&A, commercial finance, or business analytics
  • Advanced proficiency in Microsoft Excel (financial modelling, pivot tables, Power Query)
  • Experience with Power BI or a comparable business intelligence platform
  • Familiarity with Salesforce or another CRM for revenue analytics
  • Strong understanding of P&L mechanics and revenue forecasting
  • Ability to communicate financial analytics to non-finance stakeholders
  • Post-secondary education in Finance, Accounting, Business, or related field
  • Experience in transportation or logistics industry
  • Exposure to TMS platforms or freight-specific operational data
  • Understanding of sales incentive plan structures and commission accounting
  • CPA designation (in progress or completed)

Responsibilities

  • Build and maintain monthly sales forecast models with input from regional sales teams
  • Develop rolling forecasts considering pipeline health and market conditions
  • Perform variance analysis and communicate drivers to leadership
  • Support the annual budgeting cycle translating revenue targets into quotas
  • Partner with Sales leadership to align sales capacity with financial plans
  • Produce financial reports tracking revenue performance at the sales rep level
  • Develop and maintain the Annualised New Business Run Rate metric
  • Identify billing discrepancies and rate mismatches that erode revenue
  • Monitor accessorial capture rates and collaborate with Operations
  • Build and automate dashboards in Power BI for stakeholders
  • Model financial impact of sales incentive and commission structures
  • Prepare monthly incentive accruals with HR/Payroll
  • Assemble customer-level and lane-level profitability analyses
  • Collaborate with Pricing to identify margin improvement opportunities
  • Support profitability reviews for key accounts and RFPs
  • Act as a financial resource for ad hoc analyses and presentations
  • Maintain data integrity across Salesforce CRM and financial systems
  • Enhance data pipelines with IT/BI teams

Benefits

  • Opportunity to work in one of Canada’s largest transportation networks
  • Collaborative environment with strong partnership across teams
  • Access to professional development and advancement opportunities
  • Potential for significant impact on revenue strategy and financial performance
  • Supportive culture emphasizing analytical problem solving
Full Job Description
JOB DESCRIPTION

Sr. Commercial Finance Analyst – FP&A
Full-time
Brampton, ON

Day & Ross is one of Canada’s largest transportation networks, and our Commercial Finance team sits at the intersection of revenue strategy and financial rigour. As a Commercial Finance Analyst, you will serve as the financial partner to our sales organisation — translating pipeline activity, customer wins and losses, and rep-level performance into actionable insight for senior leadership.

Reporting to the VP/Director of Finance, this role is well-suited to an analytically sharp finance professional with a genuine interest in commercial dynamics and the freight industry.

How You’ll Help

  • Build and maintain monthly sales forecast models, incorporating bottom-up input from regional sales teams and reconciling to top-down targets

  • Develop rolling forecasts that reflect changing pipeline health, seasonality, and market conditions

  • Perform variance analysis between actuals, forecast, and budget, clearly communicating drivers to Finance and Commercial leadership

  • Support the annual commercial budgeting cycle, translating revenue targets into rep-, territory-, and customer-level quotas

  • Partner with Sales leadership to stress-test assumptions and ensure alignment between sales capacity and financial plans

  • Maintain documentation of target-setting methodology and key assumptions

  • Produce recurring financial reports tracking revenue performance at the sales rep level, including wins, losses, and net revenue movements

  • Develop and maintain the Annualised New Business Run Rate (ANBRR) metric — tracking new logo acquisition, account expansions, and churn — as a leading indicator of revenue health

  • Support revenue integrity reviews, identifying billing discrepancies, rate mismatches, and undercharged shipments that erode recognised revenue

  • Monitor accessorial capture rates across the network, partnering with Operations and Pricing to ensure accessorial charges are consistently applied, billed, and recovered

  • Build and automate dashboards in Power BI to support self-serve reporting across Commercial and Finance stakeholders

  • Model the financial impact of sales incentive and commission structures, supporting plan design, scenario testing, and periodic true-ups

  • Prepare monthly incentive accruals in collaboration with HR/Payroll, ensuring accuracy and consistency with plan mechanics

  • Analyse incentive plan effectiveness relative to revenue outcomes and flag anomalies or unintended consequences

  • Conduct customer-level and lane-level profitability analyses, integrating revenue, cost-to-serve, and pricing data

  • Partner with Pricing and Operations to identify accounts where margin improvement or repricing action is warranted

  • Support pre-sale and post-sale profitability reviews for key accounts and RFP opportunities

  • Act as a financial resource for the sales organisation, supporting ad hoc analyses, business cases, and commercial presentations

  • Partner closely with the Pricing team on rate card reviews, margin floor analysis, and the financial evaluation of pricing exceptions and discount requests

  • Maintain data integrity across Salesforce CRM and financial systems, flagging discrepancies and driving process improvements

  • Collaborate with IT/BI teams to enhance data pipelines and reporting infrastructure

Your Skills & Experience: 

  • 3–6 years of experience in FP&A, commercial finance, or business analytics

  • Advanced proficiency in Microsoft Excel (financial modelling, pivot tables, Power Query)

  • Experience with Power BI or a comparable business intelligence platform

  • Familiarity with Salesforce or another CRM as a data source for revenue analytics

  • Strong grasp of P&L mechanics and revenue forecasting concepts

  • Demonstrated ability to communicate financial analysis clearly to non-finance stakeholders

  • Post-secondary education in Finance, Accounting, Business, or a related field

  • Experience in transportation, logistics, or another asset-intensive industry

  • Exposure to TMS platforms or freight-specific operational data

  • Working knowledge of sales incentive plan structures and commission accounting

  • CPA designation in progress or completed

To apply, visit our Careers page at dayross.com.

If you’re chosen for the role, you’ll be asked to provide reference and criminal background checks before employment. You’ll only be contacted if you’re selected for an interview. 

Similar Jobs

More Jobs at Day & Ross

More Finance & Insurance Jobs

Find similar Sr. Financial Analyst, Commercial FP&A jobs: