SPECIALIST, DEFENCE SUPPLY CHAIN DATA & ANALYTICS

Business Development Bank of Canada; Montreal (administrative region); On-site; CAD 140,000 - 200,000; Full time

Benefits offered by this job

Savings & Investment Plan

Defined Benefit Pension

Wellness account $750

Paid vacation and personal days

Hybrid work model

Learning & development

Job summary

Business Development Bank of Canada seeks a senior BI and Defence Intelligence lead to build and manage analytics assets supporting sector strategy and decision-making. You will transform complex data into actionable insights guiding investment and business development, while advancing governance and data quality across platforms.

The role requires expert analytics, extensive BI experience, and bilingual communication in English and French.

Qualifications

• Bachelor’s degree in Finance, Mathematics, Economics, Business Intelligence Analytics, Engineering or related discipline.
• Minimum 10 years of experience in BI, Operational Analysis, Advanced Analytics or related analytical fields.
• Experience leading complex analytical initiatives from problem definition through methodology design, validation and recommendation delivery.
• Strong proficiency in Excel (incl. VBA), SQL, Power BI, PowerPoint; Data modelling; DAX; Data quality management.

Responsibilities

• Own and enhance Defence Supply Chain intelligence assets, including platform databases and dashboards.
• Design, develop, and maintain data models, reporting frameworks, semantic models, and Power BI dashboards.
• Apply advanced analytics and AI-enabled tools to identify industry trends and growth opportunities.
• Collaborate with multiple functions to align methodologies and maximize analytical value.
• Present complex findings to senior leaders with concise, executive-ready materials.

Skills

Excel VBA

SQL

Power BI

DAX

Data modelling

Dashboard design

Stakeholder comms

Bilingual EN/FR

Education

Bachelor’s degree in Finance/Math/Economics/Engineering/Analytics

Tools

Excel VBA

SQL

Power BI

PowerPoint

DAX

Data modelling

Job description

We are banking at another level. Choosing BDC as your employer means working in a healthy, inclusive, and skilled workplace that puts forward the best conditions to bring together unique teams where employees are empowered to act. It also means being at the centre of ambitious economic and financial projects to see further and to do things differently, to fuel the success of Canadian entrepreneurs. Choosing BDC as your employer also means: Flexible and competitive benefits, including an Employee Savings and Investment Plan where BDC matches part of your voluntary contributions, a Defined Benefit Pension Plan, a $750 wellness and health care spending account, to name a few In addition to paid vacation each year, five personal days, sick days as necessary, and our offices are closed from December 25 to January 1 A hybrid work model that truly balances work and personal life Opportunities for learning, training and development, and much more... Explore the BDC Way in our Culture Book

BENEFITS

• an Employee Savings and Investment Plan where BDC matches part of your voluntary contributions
• a Defined Benefit Pension Plan
• a $750 wellness and health care spending account
• In addition to paid vacation each year
• five personal days
• sick days as necessary
• our offices are closed from December 25 to January 1
• A hybrid work model that truly balances work and personal life
• Opportunities for learning, training and development, and much more...
• Explore the BDC Way in our Culture Book

POSITION OVERVIEW

BDC is the only bank dedicated exclusively to Canadian entrepreneurs. In this role, you will strengthen BDC’s understanding of Canada’s defence industrial ecosystem by building, managing, and continuously improving defence supply chain intelligence assets. Your work will transform complex data into actionable insights that support sector strategy, business development, client engagement, operational planning, and investment-related decision-making. Your contributions will directly support informed decisions that help Canadian businesses grow.

CHALLENGES TO BE MET

Own and continuously enhance BDC’s Defence Supply Chain intelligence assets, including Defence platform databases Defence SME databases Design, develop, and maintain data models, reporting frameworks, semantic models, and Power BI dashboards to support business planning and decision-making. Apply advanced analytics and AI-enabled tools to identify Industry trends Growth opportunities Supply chain gaps Emerging risks Establish and maintain data governance, data quality, and analytical integrity standards. Integrate external data sources and market intelligence to improve business insights and decision support. Translate business questions into analytical frameworks and recommendations aligned with sector strategy and operational priorities. Analyze defence sector intelligence to assess ecosystem dynamics, emerging technologies, market developments, and supply chain capabilities within Canada’s defence industrial base. Develop recurring intelligence products, including Executive dashboards Scorecards Executive briefings Analytical summaries Collaborate with partners across BDC, including Economic Research, Advisory Services, Risk, and other business functions, to align methodologies and maximize the value of intelligence assets. Advise stakeholders on the effective use of analytical tools and data-driven decision-making. Support the development and monitoring of performance measures, strategic KPIs, and corporate planning activities. Present complex analytical findings to senior leaders through concise, executive-ready materials and presentations. Own and evolve the Defence Supply Chain data and analytics strategy as business and sector needs change. Contribute to an inclusive environment where diverse perspectives strengthen decision-making and business outcomes.

REQUIRED QUALIFICATIONS

Education Bachelor’s degree in one of the following fields: Finance Mathematics Economics Business Intelligence Analytics Engineering Related discipline

Experience Minimum 10 years of experience in: Business Intelligence Operational Analysis Advanced Analytics Related analytical fields Experience leading complex analytical and planning initiatives from problem definition through methodology design, validation, and recommendation delivery. Experience developing, reviewing, validating, and challenging: Analytical methodologies Analytical models Forecasts Business analyses Experience preparing and delivering presentations to senior leadership audiences.

Technical skills Advanced proficiency in: Microsoft Excel (including VBA) SQL Microsoft Power BI Microsoft PowerPoint Advanced knowledge of: Data modelling Dashboard development DAX (Data Analysis Expressions) Semantic model design Data quality management Analytical integrity practices Ability to assess the validity of analytical conclusions and convert findings into business recommendations. Strong financial acumen and understanding of business and performance metrics.

Communication and stakeholder management Ability to communicate complex analytical findings clearly and concisely to business audiences. Ability to build effective relationships with stakeholders across multiple functions. Ability to influence decision-making through evidence-based recommendations. Ability to work independently, manage multiple priorities, and perform effectively in a fast-paced environment. Fluency in English and French.

PREFERRED QUALIFICATIONS

Experience applying AI-enabled analytical tools to business intelligence and decision support. Experience with defence sector, defence supply chain, industrial ecosystem, or related market intelligence analysis. Experience developing executive-level intelligence products such as scorecards, strategic dashboards, and sector briefings. Experience supporting strategic planning, corporate planning, performance measurement, or KPI development.

Proudly one of Canada’s Top 100 Employers and one of Canada’s Best Diversity Employers, we are committed to fostering a diverse, equitable, inclusive and accessible environment where all employees can thrive and feel empowered to bring their whole selves to work. If you require an accommodation to complete your application, please do not hesitate to contact us at [e-mail]. While we appreciate all applications, we advise that only the candidates selected to participate in the recruitment process will be contacted. BDC is a bank unlike any other. We are the only bank dedicated exclusively to the development of Canadian businesses. The only institution whose purpose is to promote the growth of the Canadian economy by focusing on the success of small and medium-sized businesses, with a human touch and a genuine presence. At BDC, we’re changing people’s and businesses’ lives for the better. That’s what makes us unique as a bank. That’s why we are banking at another level.