Data Engineer I

Northbridge Financial; Winnipeg; Hybrid; CAD 80,000 - 110,000; Full time

Job summary

Join Northbridge Financial as a senior Data Engineer where you will design and develop ETL/ELT processes for the Enterprise Data Warehouse. This hybrid role offers a competitive salary, flexible health benefits, and opportunities for professional growth. We value diversity and inclusivity, inviting you to be part of our supportive team.

Benefits

Hybrid work model: 50/50 office and home work flexibility.

Competitive salaries and employee share purchase plan.

Flexible health benefits and wellness programs.

Career growth opportunities through education assistance.

Community engagement initiatives.

Qualifications

• 4-6 years of IT experience.
• 3 years of ETL design and development experience in a BI environment.
• Knowledge in Property and Casualty industry technologies and products.

Responsibilities

• Design and develop ETL/ELT processes and mappings.
• Interface with stakeholders and analyze/profiling source data.
• Provide production support and maintain performance of data warehouses.

Skills

ETL/ELT processes

Data analysis

Performance tuning

Data mapping

Agile/Scrum methodologies

Database modifications

Communication

Education

Post-secondary degree in Math, Computer Science, Engineering

Tools

Microsoft SQL Server 2012

Snowflake

SSIS

ADF

DBT

Control-M

TFS

Azure GIT

Job description

What is it like to be a senior Data Engineer at Northbridge Financial?

The Data Engineer supports the design and development of ETL/ELT processes that extract and manipulate data from complex sources to populate the Enterprise Data Warehouse, including new and legacy sources transitioning from legacy reporting environments.

We want your talent

If you are great at:

• Interfacing with business systems analysts, solution designers, data architects, and stakeholders to understand business requirements.
• Analyzing and profiling source data and understanding relationships between data sources.
• Parsing unstructured and semi-structured data such as JSON and XML.
• Designing and developing mappings and workflows to load data onto Data Marts.
• Performance tuning ETL/ELT mappings and queries.
• Designing and developing ETL/ELT pipelines for CI/CD.
• Communicating clearly and professionally across verbal, email, and documentation channels.
• Developing, testing, and documenting ETL/ELT solutions in a complex data warehouse environment.
• Using tools like Microsoft SQL Server 2012, Snowflake, SSIS, ADF, DBT, Control-M, and version control systems like TFS or Azure GIT.
• Applying Agile/Scrum methodologies.
• Adhering to development standards, naming conventions, and best practices.
• Performing database modifications as required.
• Providing production support and on-call assistance for data warehouses.

If you have:

• A post-secondary degree in Math, Computer Science, Engineering, or equivalent work experience.
• 4-6 years of IT experience.
• At least 3 years of experience in ETL design and development within a BI environment.
• Knowledge of Property and Casualty industry, technologies, and products.

We really mean it when we say we put you first. Here are a few ways how:

• Hybrid work model: 50/50 office and home work flexibility.
• Competitive salaries, employee share purchase plan, pension plans, RRSP, insurance discounts, and more.
• Flexible health benefits, early leave days, wellness programs, and recognition initiatives.
• Career growth opportunities through education assistance, internal mobility, and mentoring.
• Community engagement through donation matching and volunteer days.

#LI-TS1

Who we are:

Northbridge Financial is a proud Canadian company owned by Fairfax Financial, serving through brands like Northbridge Insurance, Federated Insurance, and TruShield Insurance. We are committed to understanding our customers' needs and helping Canadian businesses thrive. We value passionate people who believe in working hard and having fun while making a difference. Join us if you want to be part of a team that cares about your growth and inclusivity.

At Northbridge Financial, we celebrate diversity and are committed to creating an inclusive workplace. Let us know how we can support or accommodate you during the hiring process.