Apply now

Posted 5 months ago

Senior Business Intelligence Engineer

@ BFL CANADA

Montréal, Quebec

Full-time4+ years experience
Apply now
SIGNALS

Overview

BFL CANADA is hiring a Senior Business Intelligence Engineer for its Montreal office to design and deliver scalable BI solutions, with a strong focus on Power BI. The role is full-time, hybrid, and requires French and English bilingualism. Pay is described as competitive with benefits starting day one.

Responsibilities:

  • Build and maintain Power BI reports and dashboards
  • Develop and maintain RLS modules
  • Build business cubes and analyze data for the business
  • Work with data marts in Azure Synapse and SQL Server

Requirements summary:

  • Bachelor's degree in computer science, IT or related field
  • 4 to 7 years of BI or data analytics experience
  • Strong Power BI, DAX and SQL skills
  • Bilingual in French and English

Tools & skills

Benefits mentioned

Health insuranceDentalEmployee assistanceWellness
Source and dates

Employer career site / ATS feed · ultipro

Employer posting date
2026-06-09
First seen by our source
2026-10-08
Source record updated
2026-10-16

These dates describe the source record, not a live verification that the employer is still hiring. Check the original posting.

Job details

SenioritySenior
DepartmentData & analytics
Experience4+ years
Hours per week40 (estimated)
Travelair: none · ground: none
Work settingOffice
PositionMostly sitting
Physical demandsphysical low · computer high
LanguagesEnglish, French
Background checkscriminal record
EducationBachelor’s degree (required), Master’s degree (preferred)
Fields of studyComputer science, Information technology
Perks mentionedRetirement plan, Wellness, Paid training, Home office allowance

Summary and details written by AI from the posting; the employer’s posting is the authority.

BFL CANADA

Saved company profile

Historical company information from a saved The Jobs API profile (LinkedIn/Crunchbase fields). It is not live-verified; figures may have changed. Missing values remain unknown.

Full company description

BFL CANADA is one of the largest employee-owned and operated commercial insurance brokerage and consulting services firms in Canada. Founded in 1987 by Barry F. Lorenzetti, BFL CANADA has over 1,500 employees in Canada. Our professionals are located in 27 cities across the country and include specialists in sectors such as Directors and Officers Liability, Financial Institutions, Professional Liability, Construction, Surety Bonds, Cargo and International Logistics, Architects and Engineers, Health and Pharmaceutical, Real Estate and Transportation. BFL CANADA strongly believes in the benefits of working in partnership with clients. Our company has experienced tremendous growth, due to our reliability in executing our mandates and our persistence in "delivering the goods"​. Our passion for the business and our desire to meet and exceed the expectations of clients are key to delivering our services - our clients’ loyalty attests to this. Originally built on niches, for over 38 years BFL CANADA has carved a place for itself in all economic sectors, thus competing with major U.S. brokerage firms. Our client base is made up of a wide range of Canadian and international organizations, as well as major associations and groups. With the specific needs of each client in mind, we help them define their particular risk management strategy, advise them, and explore the best possible solutions for their particular situation. Financial Services Firm / Cabinet de services financiers BFL CANADA is a registered trade-mark of First Lion Holdings Inc. used under license by its subsidiaries, which include BFL CANADA Risk and Insurance Services Inc. and BFL CANADA Benefits.

LinkedIn followers
24,900
People associated on LinkedIn
1,547
Reported office locations
  • 2001, McGill College, Suite 2200, Montreal, Quebec H3A 1G1, CA
  • 1177 West Hastings Street, Suite 200, Vancouver, British-Columbia V6E 2K3, CA
  • 200 - 1167 Kensington Crescent NW, Calgary, Alberta T2N 1X7, CA
  • 181 University Avenue, Suite 1700, Toronto, Ontario M5H 3M7, CA
  • 3448 Stanley, Montreal, Quebec H3A 1R8, CA
  • 200-1167 Kensington Crescent Northwest, Calgary, Alberta T2N 1X7 , CA
  • 313-9426 51 Avenue, Edmonton, Alberta T6E 5A6, CA
  • 45 Westwind Drive, Hammonds Plains, Nova Scotia B3Z 1K6 , CA
  • 108-347 Leon Avenue, Kelowna, British Columbia V1Y 8C7, CA
  • 343 Preston St, Suite 410, Ottawa, Ontario K1S 1N4, CA
  • 2590, boulevard Laurier, Bureau TBC 600, Quebec, Quebec G1V 4M6, CA
  • 100-230 Lake Street, Red Deer County, Alberta T4E 1B9, CA
  • 181 University Avenue, Suite 2010, Toronto, Ontario M5H 3M7, CA
  • 1177 West Hastings Street, Suite 200, Vancouver, British Columbia V6E 2K3, CA
  • 187 King Street, Suite 205, Waterloo, Ontario N2J 1R1, CA
  • 110-444 St. Mary Avenue, Winnipeg, Manitoba R3C 3T1 , CA
  • 2550 Boulevard Daniel-Johnson, Laval, Quebec H7T 2L1, CA
  • 306-1595 Bedford Hwy, Bedford, Nova Scotia B4A 3Y4 , CA
  • 385 Victoria St, Prince George, British Columbia V2L 2J6, CA
  • 465 Richmond St, Suite 300, London, Ontario N6A 5P4, CA
  • 409 3rd Avenue South, 307, Saskatoon, Sasktachewan S7K 5R5, CA
  • 104-650 TransCanada Highway, Salmon Arm, British Columbia V1E 2S6, CA
  • 100 King Street West, Suite 2400, Hamilton, Ontario L8P 1A2, CA
  • 46 Anson Avenue, Unit 9, Amherst, Nova Scotia B4H 4R2, CA
  • 231 Place North, 99009 102 Street, Suite 302, Grande Prairie , Alberta TBV 2V4, CA
Business categories
  • Employee Benefits
  • Risk Management
  • Professional Services
  • Insurance
Other recorded names
  • BFL CANADA
Specialties
  • Risk management consulting
  • Assessment of insurance needs
  • Development of invitations to tender
  • Review of contracts/leases
  • Employee benefits consulting
  • Claims management services
  • Risk control consulting / loss prevention
  • Évaluation des besoins d'assurance
  • Développement d'appels d'offres
  • Conseil en avantages sociaux
  • Services de gestion des réclamations
  • Révision de contrats/baux
  • Conseil en contrôle des risques et préventions des pertes
  • and Conseil en gestion de risques
Profile identifies a recruitment agency
No
Reported total investment
0

Currency and observation date were not supplied; this is not a current valuation or a funding round.

BFL CANADA is one of the largest employee-owned and operated commercial insurance brokerage and consulting services firms in Canada. Founded in 1987 by Barry F. Lorenzetti, BFL CANADA has over 1,500 employees in Canada. Our professionals are located in 27 cities across the country and include specialists in sectors such as Directors and Officers Liability, Financial Institutions, Professional Liability…

FieldValue
IndustryInsurance
Company size1,001-5,000 employees
HeadquartersMontreal, Quebec
Organization typePrivately Held
Year founded1987
SpecialtiesRisk management consultingAssessment of insurance needsDevelopment of invitations to tenderReview of contracts/leasesEmployee benefits consultingClaims management servicesRisk control consulting / loss preventionÉvaluation des besoins d'assuranceDéveloppement d'appels d'offresConseil en avantages sociaux
Open jobs on Jobsy27
LinkedInView page
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 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

Similar jobs

  • Business Intelligence Engineer, IT PnD Data & Analytics (DnA)

    Vancouver, BC
    Full Time

    Amazon Development Centre Canada ULC

    3+ YOECandidates need 3+ years analyzing data with Redshift, Oracle or NoSQL, and 2+ years with Tableau, QuickSight or similar tools. Strong SQL and Python skills for data processing are required.

    Tableau, QuickSight, Redshift, Oracle, Excel, Python

    Business Intelligence Engineer II, Talent Acquisition Analytics

    Vancouver, BC
    Full Time

    Amazon Development Centre Canada ULC

    3+ YOECandidates need 3+ years analyzing data with Redshift, Oracle or NoSQL, plus a bachelor's degree or equivalent. Amazon Development Centre Canada ULC asks for Tableau or QuickSight, ETL and data warehousing, SQL and advanced Excel skills.

    Tableau, QuickSight, Redshift, Oracle, SQL, Excel

  • Business Intelligence Engineer III, Talent Acquisition Analytics

    Vancouver, BC
    Full Time

    Amazon Canada Fulfillment Services, ULC

    5+ YOECandidates need 5+ years of professional or military experience, 5+ years of SQL and advanced SQL skills, scripting for automation such as Python, experience with experiments and statistical analysis, and AWS experience. Strong communication with business stakeholders and senior leaders is preferred.

    SQL, Python, AWS, BI tools

  • Senior Business Intelligence Engineer

    Edmonton, AB +3
    $126k–$170k/yrHybridFull Time

    Jobber: The company continually ranks as one of Canada's fastest-growing and most innovative companies by Canadian Business and Macleans, The Globe and…

    Candidates need extensive data architecture and dimensional modeling experience, expert SQL skills, and experience building pipelines with DBT. They also need dashboard design skills in Tableau or similar tools, familiarity with Snowflake, and a background in data governance.

    SQL, DBT, Tableau, Snowflake

Locations & environments

Locations

All of CanadaRemote · Hybrid · On-site · Field

Pro tip: add remote jobs to widen your search.

Exclude locations

Workplace type

Company jobs in these results

These are this company’s jobs loaded in your current search. The company may have more openings.