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 Senior Business Intelligence Engineer to join our Business Intelligence team in our Montreal, Toronto or Vancouver office!

As a Senior Business Intelligence Engineer, you will design and deliver scalable BI solutions that enable data-driven decision-making across the organization. This is a hands-on role with a strong focus on Power BI, combined with a broader, solution-oriented mindset to support evolving analytics and AI-driven initiatives.

You will work closely with business stakeholders, data engineering teams, and BI peers to transform complex data into clear, actionable insights.

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

• Build & maintain Power BI reports & dashboards
• Understand & Develop RLS modules while maintaining the existing ones
• Build Business cubes to curate datasets
• Undertake data analysis initiatives to support the business
• Understand structure of enterprise data to translate into reporting design
• Work with Physical and Logical Data Marts in Azure Synapse and SQL Server
• Follow best practices for Power BI report design & BI deliverables in general
• Work and collaborate with Data Engineering resources
• Explore potential data science initiatives within the existing framework
• Collaborate with various Business stakeholders
• Identify potential gaps in reporting & BI needs across business domains
• Work in Agile framework/methodology

Our ideal candidate

Qualifications & Experience

• Bachelor’s degree in computer science, Information Technology or related field (Master’s Degree would be an asset).
• 4 to 7 years of experience working in Business Intelligence or Data Analytics.
• Proven experience delivering end-to-end BI solutions in a corporate environment.
• Insurance industry knowledge or experience working with similar data domains

Technical Skills

• Strong expertise in Power BI (data modeling, DAX, performance optimization, visualization best practices).
• Strong SQL skills and experience with relational databases.
• Solid understanding of data modeling, data warehousing, and BI concepts.
• Experience working with cloud data environments (Azure preferred: Synapse, Data Factory, Data Lake).
• Experience with ETL processes, data transformation, and working with APIs.
• Experience with Python or R for data manipulation or automation is an asset.
• Familiarity with Power BI deployment pipelines and CI/CD practices is an asset.
• Bilingual with strong verbal and written communication skills in both French and English, as the candidate will be required to interact in English with stakeholders (colleagues and clients) outside Quebec.

Core Competencies

• Strong analytical and problem-solving skills with attention to detail.
• Ability to quickly understand complex data structures and business processes with limited documentation.
• Quick learner with the ability to make connections across disparate data sources and systems.
• Strong ability to translate data into clear, actionable insights for business stakeholders
• Effective communication and stakeholder engagement skills.
• Collaborative mindset with a focus on mentoring and knowledge sharing.
• Proactive, adaptable, and able to operate in a fast-paced environment.

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.

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: www.bflcanada.ca

We welcome and encourage applications from people with diverse abilities. BFL Canada is committed to fostering an environment that is diverse, equitable, inclusive, and accessible to all. The diversity of our talents enables innovation and creativity through diverse backgrounds, different thinking, and unique knowledge. Accommodation is 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