Data Engineer/Analyst

Southampton Financial Inc; Toronto; On-site; CAD 60,000 - 70,000; Full time

Job summary

Join a forward-thinking company as a Data Engineer/Analyst, where you'll shape the future of data integration and analytics. In this dynamic role, you'll design efficient data pipelines, collaborate with cross-functional teams, and utilize cutting-edge tools to transform data into actionable insights. This innovative firm is committed to disrupting the insurance landscape in Canada, empowering you to take ownership of your projects and contribute to a best-in-class customer experience. If you're passionate about data and eager to make a significant impact, this opportunity is perfect for you.

Qualifications

• 3+ years of experience in ETL development and data engineering.
• Proficiency in SQL and Python for data analysis and visualization.

Responsibilities

• Design and implement scalable data pipelines for ETL processes.
• Collaborate with teams to gather requirements and ensure data accuracy.

Skills

ETL Development

Data Engineering

SQL

Python

Data Visualization

Data Analysis

Data Modeling

NoSQL Databases

Azure Data Factory

AWS Glue

Education

Bachelor's Degree in Computer Science or related field

3+ years of experience in data roles

Tools

Power BI

Google Analytics

MongoDB

Job description

Get AI-powered advice on this job and more exclusive features.

Southampton Financial’s Mission: Bring Clarity to Insurance

Southampton Financial is a value-added strategic investor in the Canadian property and casualty distribution space. We are the majority equity owner of Alteri Insurance and have acquired Onlia Insurance and aha insurance in recent months. Our goal is to build the insurance brokerage of the future by combining leading-edge technology with high-quality brokers catering to the overall insurance needs of Canadians by providing them with customized solutions to suit their individual needs.

At Southampton Group of Companies, we're not just merging companies; we're fusing expertise, innovation, and a relentless commitment to excellence. Our purpose is clear: to disrupt the insurance landscape in Canada. As we assemble a team of industry heavyweights, our goal is to make this vision a reality. In our collaborative, fast-paced, and agile environment, we strongly believe in empowering every member of our team to take ownership of their role. Together, we're dedicated to building a best-in-class experience for our customers.

Job Description

We are seeking a high-skilled and experienced all-round Data Engineer/Analyst to join our dynamic team. As a fully empowered data specialist you will play a pivotal role in shaping the technical direction and core backbone of our business from a data perspective

You will be involved in all aspects of data, including the building of pipelines/data warehouse, analysis and trending of data, and the visualization of that data in reports/dashboards.

Key Accountabilities:

• Design and implement scalable and efficient data pipelines to extract, transform, and load data from various sources into target systems or data warehouses.
• Collaborate with data engineers, data analysts and business stakeholders to gather requirements and translate them into technical specifications for ETL workflows.
• Perform data profiling, cleansing, and transformation to ensure data accuracy, consistency, and integrity throughout the ETL process.
• Writing stored procedures, functions, and queries in SQL or a relevant database language.
• Data modeling and designing efficient database schemas for data warehouses or data marts.
• Implement data quality controls and validation checks to identify and address data anomalies, inconsistencies, or errors.
• Develop and maintain documentation, including technical specifications, data mappings, and workflow diagrams.
• Experience working with version control systems and following software development best practices for code management and collaboration.
• Perform deep dive analysis of customer data to identify key demographics.
• Analysis of website traffic to understand how our sites are used, user engagement and conversion tracking etc.
• Visualization of data through dashboards and reports

Qualifications

You Have:

• 3+ years proven experience as an ETL Developer, Data Engineer, or similar role, with expertise in designing and developing data integration solutions using Azure Data Factory (ADF) or AWS Glue.
• Strong understanding of ETL concepts, data warehousing principles, and data integration patterns.
• Familiarity with data modeling tools and techniques, such as ER diagrams, dimensional modeling, and star schemas.
• Experience in parsing and transforming semi-structured data – JSON, XML.
• Experienced in data integration patterns and techniques, including change data capture (CDC), incremental loading, and data synchronization.
• Proficiency in SQL and experience working with relational databases, data modeling, and query optimization.
• Advanced skills in data analysis using Python – experience working with different formats – xml, web API calls, Excel.
• Proficient working with No SQL databases such as MongoDB.
• Experience with data visualization tools such as Power BI for both static and dynamic reporting.
• Well versed in Google Analytics.
• Solid understanding of statistical analysis, hypothesis testing, and experimental design.
• Experience with data wrangling, cleaning, and manipulation.
• Strong problem-solving skills and ability to troubleshoot and resolve complex data-related issues.
• Excellent communication skills and ability to collaborate effectively with cross-functional teams.
• Self-motivated, proactive, and able to work independently with minimal supervision.

Nice To Have:

• Familiarity with Property & Casualty Insurance/Brokerage domain

Seniority level

• Seniority level

  Associate

Employment type

• Employment type

  Full-time

Job function

• Job function

  Analyst

• Industries

  Insurance

Referrals increase your chances of interviewing at Southampton Financial Inc by 2x

Get notified about new Data Engineer jobs in Toronto, Ontario, Canada.

Software Engineer, Backend (All Levels / All Teams)

Software Engineer I, Entry Level (Fall 2024-Spring 2025) - Toronto

Velocity - Data Engineer Internship/Co-Op - Fall 2025

Toronto, Ontario, Canada $60,000.00-$70,000.00 3 weeks ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.