Lead, FP&A Systems and Process at Trimac Transportation & Family of Companies

Calgary, Alberta, Canada -

Full Time

Start Date

Immediate

Expiry Date

29 Jun, 26

Salary

0.0

Posted On

31 Mar, 26

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

FP&A Platform Implementation, Financial Modeling, Rolling Forecast, Annual Budgeting, System Ownership, Data Integration, ETL Processes, Multi-dimensional Data Cubes, UAT/SIT Testing, Change Management, ERP Integration, Financial Controls, Variance Analysis, Prophix, Dynamics 365, Workflow Design

Industry

Truck Transportation

Description

Overview Trimac isn't just a transportation company; it's an industry disruptor with a remarkable 80-year legacy of safely delivering products that improve people’s lives across North America. Our workplace culture is centered on being safe, respectful, innovative and inclusive. We are committed to maintaining a rewarding work environment that allows employees to experience new opportunities and build their chosen careers. Across the company, we encourage open communication, champion integrity, celebrate individuality and cultivate diverse talents and perspectives. If you’re ready for a challenge that will help drive forward an industry leading team, we invite you to begin your journey with us. Job Details Reporting to the Director of Capital & Financial Planning, the Lead, FP&A systems and process role will work closely with the leaders responsible for Technology, Operations and Finance. This position is a senior individual contributor role responsible for architecting and executing the transition of our Annual Budget and 24-Month Rolling Forecast from fragmented, manual spreadsheets to a dedicated, enterprise-grade FP&A platform. Post-implementation, the role will serve as the System Owner and Process Lead, managing the end-to-end forecasting cycle, optimizing multi-dimensional models, and ensuring the platform evolves to meet the strategic needs of the business. This is a builder role designed for a candidate who is equally comfortable writing financial logic and managing data integration pipelines. Responsibilities Partner with different stakeholders in the company (operations, sales, etc) to design and implement rolling 24 month forecast which transition into the annual budget process Translate business needs into fit-gap analysis and solution designs leveraging standard product capabilities; recommend configuration vs. extension vs. integration approaches. Build and maintain multi-dimensional data cubes. Defining and maintaining data across —Time, Version (Plan vs. Actual vs. Forecast), Entity, Department, and Project—to allow for streamlined, granular forecasting and reporting Partner with security/compliance stakeholders to ensure appropriate segregation of duties, auditability, and financial controls within business processes Support change management: training needs analysis, training materials, user enablement, communications, and adoption measurement. Lead the architectural transition from disparate, Excel-based "shadow" models to a centralized FP&A platform (Prophix or equivalent system). This includes mapping legacy data, cleansing historical records, and designing the new user interface for budget/forecast stakeholders Ensure the system architecture can handle "n+1" growth to accommodate changes in reporting entity hierarchy associated with new acquisitions, business unit split/decommissioning, etc. Design and oversee the ETL (Extract, Transform, Load) processes, ensure that monthly actuals from the ERP flow into the planning system, as well as the reconciliation process to ensure accuracy of data between systems Own testing strategy and execution (SIT/UAT), including test plans, scripts, defect triage, and release readiness; support regression testing for monthly/quarterly releases Provide production support, root-cause analysis, and continuous improvement; prioritize enhancements with business owners and manage backlog Qualifications Bachelor’s or Master’s degree in Finance, Data Science, Computer Science, Engineering, or a related field 7+ years of progressive experience in product ownership /techno-functional roles supporting financial enterprise applications CPA designation preferred Deep understanding Income Statement, Balance Sheet, and Cash Flow. Must be able to design connections between the accounting/reporting system (Dynamics) to the FP&A system (prophix) Strong grasp of accounting principles, to ensure budget/forecast processes align with actual accounting reports Ability to perform variance analysis (Price/Volume/Mix) and present results in a concise manner (waterfall tables, etc) Proven experience running full-year budget cycles and monthly/quarterly rolling forecast cadences in a mid-to-large corporate environment. Proven track record of migrating "Excel-heavy" or ad-hoc forecasting processes into a centralized FP&A platform (preferably Prophix) Expertise in building and managing multi-dimensional data cubes. This includes defining Dimensions (Time, Version, Entity, Department), Attributes, and Levels to ensure data is sliceable for executive reporting. Experience managing the data pipeline between an ERP (Dynamics 365) and the FP&A tool (Prophix). Must understand how to map Chart of Accounts (COA) and handle metadata synchronization. Ability to design system-based workflows for budget submissions, including automated email triggers, status dashboards, and hierarchical approval gates. Proficiency in the "logic language" of FP&A tools to build complex formulas that calculate allocations and currency translations automatically. Experience maintaining “one view of the truth” through forecast/budget process, ensuring that changes to the forecast are tracked, timestamped, and easily auditable Experience with the following FP&A systems strongly preferred – Dynamics 365, Workiva, Prophix Knowledge of machine learning models or predictive analytics in the context of logistics optimization. Benefits We invest in our employee’s growth through training and development programs. We offer a comprehensive benefits package such as: Medical, Dental, Vision, Life Insurance, and many more health and wellness benefits Paid vacation, sick time, and company holidays Paid time off for volunteer activities to help give back to our communities Pension Plan Tuition Reimbursement Program to achieve your educational goals Continuous learning and career development Safety Commitments We make safety a part of every decision We make safety personal We have the courage to intervene

Responsibilities

This senior individual contributor role is responsible for architecting and executing the transition of annual budgeting and 24-month rolling forecasts from spreadsheets to a dedicated enterprise FP&A platform. Post-implementation, the role will act as the System Owner, managing the end-to-end forecasting cycle, optimizing models, and ensuring platform evolution to meet strategic business needs.