Job Description

We offer more than a job, we offer a career!

• We support our employees to shape their career by encouraging continuing education and investing in training and development.
• We put our employees at the center of what we do to allow them to grow personally and professionally, with projects and challenges that are motivating and rewarding.
• We inspire people to do what they are passionate about by believing in integrity, respect and recognition of diversity and community support.
• We are a dynamic team where entrepreneurship, innovation and collaboration are at the core of our values.
• We offer competitive salaries and a multitude of benefits starting day one including generous medical and dental coverage, telemedicine, employee and family assistance program, and retirement and savings programs.
• We recognize the importance of work-life balance with our hybrid work program, wellness allowance, and year-round social activities and events.

We are looking for a Business Intelligence Engineer to join our Business Intelligence team in our Montreal office!

As a Business Intelligence Engineer, you will work with a dedicated team whose goal is to leverage data and provide autonomy, enabling them to make sound data-driven decisions.

If you are career-minded and looking for a dynamic work environment with a growth mindset, you will love working among our team!

Your day as a Business Intelligence Engineer

• Design, build, and maintain Power BI reports, dashboards, and semantic models following enterprise-grade best practices.
• Develop and manage Row-Level Security (RLS) implementations across the Power BI environment.
• Build and maintain data models, including dimensional and star-schema structures in SQL Server and Azure Synapse.
• Write clean, optimized SQL to support reporting pipelines, data transformation, and ad hoc analysis.
• Use Python or R to automate data workflows, perform exploratory data analysis, and support ad hoc analytical requests.
• Participate in delta/incremental data pipeline development and maintenance alongside Data Engineering.
• Translate complex business requirements into scalable reporting solutions across multiple business domains.
• Proactively identify gaps in reporting coverage and surface data quality or structural issues upstream.
• Contribute to exploratory analytics and data science initiatives within the existing data infrastructure.
• Operate within an Agile delivery framework, managing backlog items and sprint deliverables.

Our ideal candidate

• Bachelor’s degree in Computer Science, Statistics, Mathematics, Information Systems, or a related quantitative field
• 1–2 years of hands-on BI or data experience (internships and university projects with real datasets count)
• Strong SQL is non-negotiable — window functions, CTEs, query optimization, and the ability to independently investigate a dataset you've never seen before
• Python or R proficiency is required — you should be comfortable using pandas/dplyr, writing reusable scripts, and applying basic statistical reasoning to data problems
• Demonstrated ability to break down ambiguous business problems into structured analytical questions — you know what to ask before you start building
• Proven attention to data quality — you cross-validate outputs, question unexpected results, and don't ship a number you can't explain
• Working knowledge of Power BI including DAX, data modelling, and the Power BI service (RLS, workspaces, deployment pipelines)
• Familiarity with dimensional data modelling, data warehouse concepts, and layered/medallion architecture patterns
• Exposure to Azure data services (Synapse Analytics, Data Factory, Data Lake Storage) is an asset
• Able to communicate data findings clearly and concisely to non-technical stakeholders — in both French and English
• Intellectually curious, self-directed, and genuinely motivated by turning messy data into clear answers

Who we are

Founded in 1987 by Barry F. Lorenzetti, BFL CANADA is one of the largest employee-owned and operated Risk Management, Insurance Brokerage, and Employee Benefits consulting services firms in North America. The firm has a team of over 1,500 professionals located in 27 offices across the country. Thanks to its Local International Office Network of independent brokers (LION), BFL CANADA provides clients with privileged access to insurance partners in over 140 countries, helping to support their operations both in Canada and globally.

Our Montreal office is located at the heart of downtown Montreal, the largest city in Quebec. Our employees can benefit from the numerous exciting activities organized in the neighborhood.

Let’s stay in touch: Follow us on LinkedIn to get privileged access to our activities and see our other job opportunities.

Visit our website to learn more about us: bflcanada.ca

BFL CANADA is an equal-opportunity employer. We welcome and encourage applications from people with disabilities. Accommodations are available on request for candidates taking part in all aspects of the selection process.

Offers of employment at BFL CANADA are conditional upon satisfactory results of background verifications.

#LI-Hybrid