Sr. Financial Analyst, Commercial FP&A

Day & Ross•Brampton, ON

6d•Onsite

About The Position

Day & Ross is one of Canada’s largest transportation networks, and their 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 the 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.

Requirements

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

Nice To Haves

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

Responsibilities

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