Business Intelligence Engineer

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 team in our Montreal office!

As a Business Intelligence Engineer, you will become a key part of a growing Business Intelligence team. Present across Canada you will work with a dedicated team whose goal is to leverage data and give the business the necessary tools and autonomy enabling them to make sound data-driven decisions resulting in a significant edge over the competition. Structures are in place for you to develop your skills.

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 ad hoc data analysis to support various business initiatives
• Understand structure of enterprise data to translate into reporting design
• Work with Physical and Logical Data Marts in Azure Synapse and SQL Server
• Maintain Data dictionary, and other documentation
• Follow best practices for Power BI report design & BI deliverables in general
• Work and collaborate with Data Engineering resources
• Collaborate with various Business Application Teams to understand the Source Data
• Identify potential gaps in reporting & BI needs across business domains by undertaking various initiatives
• Work in Agile framework/methodology

Our ideal candidate

• Bachelor's degree in related fields (preference for Computer Science and Information Technology related field) with some BI projects undertaken at university level.
• Experience working in organizational BI an asset.
• 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, etc. an asset.
• Willingness to be on top of new technological advances and features in BI (Power BI specifically).
• Passion for data & driving actionable insights from it.

You are also:

• Bilingual with strong verbal and written communication skills in French and English.
• Very analytical and good at problem-solving.
• Effective with time management and organizational skills.

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 1,300 professionals located in 26 offices across the country. Our employees have free rein to demonstrate their creativity, leadership, and entrepreneurial skills since we believe in each one of them. BFL CANADA is a founding Partner of Lockton Global LLP, a partnership of independent insurance brokers who provide Risk Management, Insurance, and Benefits Consulting services in over 140 countries around the world.

More about us

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

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. 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.