Location: MontrealWe 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 & dashboardsUnderstand & Develop RLS modules while maintaining the existing onesBuild Business cubes to curate datasetsUndertake data analysis initiatives to support the businessUnderstand structure of enterprise data to translate into reporting designWork with Physical and Logical Data Marts in Azure Synapse and SQL ServerFollow best practices for Power BI report design & BI deliverables in generalWork and collaborate with Data Engineering resourcesExplore potential data science initiatives within the existing frameworkCollaborate with various Business stakeholdersIdentify potential gaps in reporting & BI needs across business domainsWork in Agile framework/methodologyOur 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 domainsTechnical 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 stakeholdersEffective 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…