Business Intelligence Engineer

BFL Canada; Vancouver; Hybrid; CAD 70,000 - 90,000; Full time

Job summary

A leading risk management firm based in Canada is seeking a Business Intelligence Engineer to join their dynamic team. This role will focus on leveraging data for decision-making and requires a bachelor's degree, experience in BI, and familiarity with tools such as Power BI. The ideal candidate is bilingual and has strong analytical skills, with a commitment to collaborative work and professional growth.

Benefits

Competitive salaries

Generous medical and dental coverage

Hybrid work program

Wellness allowance

Year-round social activities

Qualifications

• 1-2 years of experience working in organizational BI.
• Actual experience in data science applications in a corporate environment is an asset.
• Fundamental knowledge of BI concepts expected.

Responsibilities

• Develop RLS modules and maintain existing ones.
• Undertake data analysis initiatives to support the business.
• Collaborate with various business stakeholders.

Skills

Experience in BI

Data analysis

SQL knowledge

Power BI familiarity

Team collaboration

Problem-solving

Bilingual (French & English)

Education

Bachelor’s degree in Computer Science or related field

Tools

Power BI

SQL Server

Azure Synapse

Tableau

Python

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, Toronto or Vancouver 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

• 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
• Bachelor’s degree in Computer Science, Information Technology or related field, with BI / Data science projects undertaken at university level.
• 1-2 years of experience working in growing organizational BI.
• Actual experience in data science applications in corporate environment is an asset.
• Fundamental knowledge of BI related concepts is expected.
• Familiarity working with or projects undertaken using various reporting tools like Power BI, Tableau, etc.
• Knowledge of Data Lakes, Data warehousing, Data Mart concepts an asset.
• Knowledge of Data Modelling, Data Transformation & database normalization concepts.
• Understand SQL. Be willing to learn advanced SQL. Familiarity with SQL Server and relational databases (e.g., SQL Server, Oracle) an asset.
• Familiarity with Azure Synapse, Data Factory, Data Lake, SQL Data Warehouse an asset.
• Familiarity working with programming languages like Python, R, Java
• Willingness to be on top of new technological advances and features in BI (Power BI specifically).
• 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.
• Passion for data & driving actionable insights from it.
• Strong problem-solving and logical reasoning skills.
• Attention to details and data validation skills.
• Reliable, flexible & dedicated.
• Team Player with excellent communication skills.
• Professionalism a must (Meet deadlines, double check the deliverable, etc.).

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 over1,450 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 to get privileged access to our activities and see our other job opportunities.

Create a job alert for this search