Data 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 Data Engineer to join our team in our Toronto office!

As a Data Engineer, you will be responsible to work with the Business Intelligence and AI Automation team whose goal is to leverage data and give the business the necessary tools and autonomy to make data-driven decisions resulting in a significant edge over the competition.

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 Data engineer

• Understand structure and rules of enterprise data to translate into database design.
• Develop and maintain ETL Data Flows using Azure Synapse.
• Develop and maintain SparkSQL, PySpark code within notebooks in Azure Synapse workspace
• Develop and maintain Physical and Logical data Marts in Azure Synapse and SQL Server.
• Maintain Data Dictionary, Data Mapping and Design Documents.
• Work on Version control tools like Azure DevOps.
• Establish best practices for a growing team.
• Work and collaborate with Power BI and AI Automation resources.
• Collaborate with various Business Application Teams to understand the Source Data.
• Work in Agile framework/methodology.

Our ideal candidate

• Min 2+ years of working in Azure Data Engineering projects
• Experience in Azure Synapse, Data Factory, Data Lake, SQL Data Warehouse.
• Bachelor’s degree in a related IT field
• Proficient in PySpark, SparkSQL, Python, SQL
• Experience with Data Lakes, Data warehousing, Data Mart concepts and Cloud Technologies.
• Excellent grasp of Data Modeling & Data Transformation concepts.
• Familiarity working with programming languages like, R, and Java etc.
• Nice to have Insurance Domain ex- Commercial insurance.
• Proficiency in English; French is a plus.
• Exceptional problem-solving and communication skills.
• Team Player, Reliable, flexible and dedicated.

This posting is for an existing vacancy position.

The expected salary for this role ranges from $80,000 to $130,000. Annual salary will be determined by factors including prior experience, location, business segment, and relevance of the candidate’s skills to the role.

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 Toronto office is located in beautiful downtown, in the core of the Financial District. Easily accessible by public transit, our office is close to a plethora of top-notch restaurants, ideal for enjoyable lunches or drinks after work.

Let’s stay in touch: follow us on to get privileged access to our activities and see our other job opportunities.

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.

BFL CANADA does not use any Artificial Intelligence tool or technology to screen, evaluate, or select applicants.

Offers of employment at BFL CANADA are conditional upon satisfactory results of background verifications.

#LI-Hybrid