Business Intelligence Engineer
Top Benefits
About the role
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
- 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 over 1,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 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.
About BFL CANADA
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,400 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 37 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.
Business Intelligence Engineer
Top Benefits
About the role
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
- 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 over 1,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 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.
About BFL CANADA
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,400 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 37 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.