Specialist, Financial Modeling and Analytics, Windsor

Company Profile Windsor-Detroit Bridge Authority (WDBA) offers a unique opportunity to make a lasting contribution to the largest bi-national infrastructure project in North America today– the Gordie Howe International Bridge. Join our Canadian Crown corporation in fulfilling our mandate to build and operate this new international bridge at the busiest commercial land border crossing between Canada and the US.

The Gordie Howe International Bridge project is a once‑in‑a‑generation undertaking. Worth $5.7 billion (CDN), the project includes the delivery of four major components: the longest cable‑stayed bridge in North America, the largest Canadian and U.S. Ports of Entry (POE) along the Canada‑US border, and a new interchange creating a direct connection into the Michigan Interstate system.

Profil de l’entreprise L’Autorité du pont Windsor‑Détroit (APWD) offre une occasion unique d’apporter une contribution durable au plus grand projet d’infrastructure binational en Amérique du Nord aujourd’hui, le Pont international Gordie‑Howe. Devenez membre de l’équipe de la société d’État canadienne et contribuez à la construction et à l’exploitation de ce nouveau pont international à la frontière terrestre commerciale la plus achalandée entre le Canada et les États‑Unis.

Le projet du Pont international Gordie‑Howe est une entreprise historique unique. D’une valeur de 6,4 milliards de dollars canadiens, le projet comprend la livraison de quatre éléments majeurs : le plus long pont à haubans d’Amérique du Nord, les plus grands points d’entrée le long de la frontière canado‑américaine et un nouvel échangeur créant une connexion directe avec le réseau autoroutier inter‑États au Michigan.

About this Opportunity As part of the Financial Planning and Analysis Team, the Specialist, Financial Modelling and Analytics (FMS) will be responsible for developing and maintaining robust financial models to support the Executive Leadership Team (ELT) with strategic decision‑making related to revenue generation, cost optimization, financial performance, and business operations. The role requires advanced Excel modelling capabilities, strong data analytics skills, and an in‑depth understanding of construction and transportation finance, as well as the ability to leverage relationships with various Subject Matter Experts (SMEs) to properly analyze accounting documentation and financial reports and translate them into actionable financial models, forecasts, and management insights.

The FMS will collaborate with various stakeholders to gather data relating to budgeting, forecasting, revenue analysis, performance reporting, and expense management. The role will lead monthly and quarterly revenue reforecasting cycles and will be expected to build and maintain dashboards and reporting tools that improve visibility into key financial and operational metrics, with required expertise in data analytics and visualisation using Power BI. The role also includes the analysis of protected data, involving strict adherence to all compliance protocols, and shall uphold confidentiality requirements for all records and information.

Specialist, Financial Modelling and Analytics Rated at a Salary Level 5 ($78,862 to $118,294) in WDBA’s Compensation Schedule and is a 12‑month to 18‑month contract position.

Position Requirements

Diploma, undergraduate or graduate degree in Accounting, Finance or Business Administration from a recognized college or university required.

Certified in a professional accounting or finance designation such as CPA, CFA, or CIA, considered an asset.

Financial Modelling Certification such as FMVA preferred.

Minimum of 3‑5 years of related working experience, specifically related to financial analysis, forecasting, data and business analysis, and financial reporting required.

Public sector experience is an asset.

Strong financial planning and analysis experience, including advanced Excel modelling, revenue forecasting, monthly and quarterly reforecasting, and development of dashboards and management reporting tools, required.

Experience working on large infrastructure or high‑value capital projects is an asset.

Demonstrated experience establishing data governance principles.

Extensive experience working with databases as well as creating logic and conceptual modelling.

Some hands‑on experience with entity relationships and/or dimensional data modelling considered an asset.

Demonstrated ability to effectively and professionally communicate orally and in writing.

Strong time management, organisational skills and attention to detail to manage work and competing deadlines.

Strong numeracy and analytical skills.

Advanced proficiency in Excel, spreadsheet modelling, and financial modelling tools, including the ability to build dynamic models, scenario analysis, and forecast templates.

Demonstrated experience developing dashboards, visual reports, and data analytics solutions using Power BI, required.

Demonstrated understanding of construction project lifecycle and financial implications.

Excellent problem‑solving skills and strong attention to detail.

Ability to build and maintain positive relationships and collaborate with diverse teams in a matrix work environment.

Advanced skills with Microsoft Office Suite, with expert‑level proficiency in Excel for financial modelling, scenario analysis, and forecasting.

Expertise with financial reporting and modelling systems/tools required, including Power BI, dashboard development, and data analytics/reporting solutions.

Ability to obtain a Government of Canada Personnel Screening/Security Clearance.

Ability to travel within Ontario and Michigan.

Hours of work may include evenings and weekends.

Working at WDBA

Work with dedicated and collaborative colleagues on a once‑in‑a‑generation project.

Receive full‑time employment with competitive compensation packages.

Have the opportunity for ample growth and development, including paid training options.

Be rewarded for being a high performer through our employee performance review program.

Enjoy a comprehensive health and dental package starting on your first day, including short‑term and long‑term disability benefits.

Be part of a defined contribution pension plan offered with up to 9 % employee/employer match.

Discuss with your manager hybrid and flexible work options available, including a mixed remote and in‑office work environment and flex‑scheduling.

Take advantage of our extensive paid time‑off benefits (vacation, personal days, volunteer day, and paid statutory holidays).

Learn how we support“disengagement” as part of our corporate culture to achieve work‑life balance.

Engage directly with our passionate and experienced leadership team.

WDBA values talent and diversity as cornerstones of our success and is committed to creating a diverse and inclusive workforce that is reflective of our community and country. To support this commitment, we encourage applications from people of all races, ethnic origins, religions, abilities, sexual orientations, gender identities or expressions.

À propos de cette offre d’emploi Au sein de l’équipe de planification et d’analyse financières, le spécialiste en modélisation financière sera responsable de l’élaboration et de la mise à jour de modèles financiers fiables destinés à aider l’équipe de direction à prendre desdécisions stratégiques en matière de génération de revenus, d’optimisation des coûts, de résultat financier et d’opérations commerciales. Ce poste nécessite des connaissances avancées en modélisation Excel, de solides compétences en analyse de données et une compréhension approfondie du financement des secteurs de la construction et des transports, ainsi que la capacité à tirer parti des relations avec divers experts en la matière pour analyser correctement la documentation comptable et les rapports financiers, et les traduire en modèles financiers exploitables, en prévisions et en informations de gestion.

Le spécialiste en modélisation financière collaborera avec divers intervenants afin de recueillir des données relatives à la budgétisation, aux prévisions, à l’analyse des revenus, aux rapports de résultat et à la gestion des dépenses. Le titulaire du poste dirigera les cycles mensuels et trimestriels de révision des prévisions de recettes et devra créer et maintenir des tableaux de bord et des outils de rapport qui améliorent la visibilité sur les indicateurs financiers et opérationnels clés, en s’appuyant sur l’expertise requise en analyse et visualisation de données à l’aide de Power BI. Cette fonction comprend également l’analyse de données protégées, impliquant le strict respect de tous les protocoles de conformité, et le titulaire devra respecter les exigences de confidentialité pour tous les dossiers et renseignements.

Spécialiste en modélisation financière et analyse Ce poste a été classé au niveau de rémunération 5 (de 78 862 $ à 118 294 $) dans le barème de rémunération de l’APWD et sera offert pour une durée déterminée de 12 ou 18 mois.

Exigences du poste

Un Baccalauréat, maîtrise ou doctorat en comptabilité, finances ou administration des affaires d’une université reconnue.

Une certification professionnelle en comptabilité ou en finance, par exemple CPA, CFA ou CIA, est un atout.

Une certification en modélisation financière, par exemple FMVA, est un atout.

Un minimum de troisà cinq ans d’expérience professionnelle dans ce domaine est requis, …