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 Business Intelligence team in our Montreal 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

• 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

• 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 1,400 professionals located in 27 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.

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

BFL CANADA is an equal-opportunity employer.  We welcome and encourage applications from people with disabilities. 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.

#LI-Hybrid