Top Benefits
About the role
What is it like to be a senior Data Engineer at Northbridge Financial The Data Engineer is responsible for supporting the design and development of ETL/ELT code that extracts and manipulates data from a variety of complex sources and populates the Enterprise Data Warehouse—various sources, including net-new sources and legacy sources transitioning from legacy reporting environments.
We want your talent If You Are Great At
- Interface with business systems analysts, solution designers, data architects, and other business stakeholders to understand the business requirements.
- Assist with analysis and profiling of various source data and understand the high-level relationships between data sources.
- Parse unstructured and semi-structured data such as JSON, XML etc.
- Design and develop efficient Mapping and workflows to load data onto Data Marts.
- Performance tuning of ETL/ELT mappings and queries.
- Design and develop ETL/ELT Pipeline for CI/CD.
- Ensure all forms of communication (verbal, email, business documents, and technical documents) are clear, concise, and professional.
- Develop, test, and document ETL/ELT solutions in a complex data warehouse environment with numerous disparate source systems.
- Use Microsoft SQL Server 2012, Snowflake and SSIS/ADF/DBT for data integration, Control-M for package scheduling, and TFS or Azure GIT repository for version control and task management.
- Use Agile/scrum project methodology.
- Ensuring that all development strictly adheres to the ETL/ELT framework, naming standards, and best practices as provided.
- Performing database modifications as required in accordance with team processes and standards.
- Provide production support for operations and on-call work of legacy and new data warehouses as assigned,
If You Have
- Post-secondary degree in Math, Computer Science, or Engineering or equivalent work experience.
- 4-6 years of IT experience.
- Minimum 3 years’ experience in ETL design and development in 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! you get to work from the office and at home 50/50, allowing you to manage both worlds with the ease and flexibility you need.
- We offer competitive salaries and support your financial health through our employee share purchase plan, pension plans, RRSP, discounts on staff insurance, and more!
- We help you prioritize your well-being from day one through flexible health benefits, early leave days, wellness programs, rewards, and recognition programs.
- We are invested in helping you grow in your career through education assistance, internal mobility, and mentoring programs.
- NBFC cares about the community and supports the causes you believe in with donation matching and team volunteer days.
Qui nous sommes Nous sommes la Financière Northbridge. Nous sommes fiers d’être une société canadienne à 100 %, détenue en propriété exclusive par Fairfax Financial. Nous offrons nos services par l’entremise de nos marques Northbridge Assurance, Les assurances Federated et TruShield Assurance. Nous sommes reconnus comme étant l’une des plus importantes sociétés d’assurance de dommages des entreprises au Canada. Nos employés sont engagés à comprendre les besoins de nos clients, et nous faisons tout en notre pouvoir pour aider les entreprises canadiennes à connaître un avenir meilleur et plus sécuritaire. Nous sommes une entreprise formée de personnes passionnées qui placent les gens au cœur de leurs préoccupations. Souhaitez-vous vous joindre à une équipe qui croit en l’importance de travailler fort, et d’avoir du plaisir au travail, tout en améliorant les choses? Ne cherchez pas plus loin que Northbridge.
À la Financière Northbridge, nous avons à cœur de créer un milieu de travail inclusif où nous célébrons les employés et les accueillons comme ils sont. Peu importe qui vous êtes ou ce qui vous rend unique, nous vous accueillons à bras ouverts. Veuillez simplement nous indiquer comment nous pouvons vous aider ou vous accommoder au cours du processus de sélection.
About Northbridge Financial Corporation
Northbridge Financial Corporation (NBFC) is a leading commercial property and casualty insurance group that has helped protect Canadian businesses for 100 years. We offer a wide range of innovative solutions through our Northbridge Insurance, TruShield Insurance, and Federated Insurance brands.
We’re passionate about protection, prevention and progress – for our customers, and in our communities. Our exceptional service and extensive offerings help Canadian businesses succeed, while our enthusiastic team works to support and uplift our neighbours from coast to coast to coast.
We’re proud to be 100% Canadian and are wholly owned by Fairfax Financial Holdings Limited.
We love where we work and think you will too!
...................................................................................
La Corporation financière Northbridge (la Financière Northbridge) est un chef de file en assurance de dommages des entreprises qui contribue à protéger les entreprises canadiennes depuis 100 ans. Nous offrons une vaste gamme de solutions novatrices sous les marques Northbridge Assurance, TruShield Assurance et Les assurances Federated.
Nous avons à cœur tout ce qui touche à la protection, à la prévention et au progrès, tant chez nos clients que dans nos collectivités. Notre service exceptionnel et notre large éventail de solutions novatrices aident les entreprises canadiennes à réussir, et notre équipe enthousiaste travaille à soutenir et accompagner leurs propriétaires d’un océan à l’autre.
Nous sommes fiers d’être une société canadienne à 100 %, détenue en propriété exclusive par Fairfax Financial Holdings Limited.
Nous aimons notre entreprise et nous pensons que vous l’aimerez aussi!
Top Benefits
About the role
What is it like to be a senior Data Engineer at Northbridge Financial The Data Engineer is responsible for supporting the design and development of ETL/ELT code that extracts and manipulates data from a variety of complex sources and populates the Enterprise Data Warehouse—various sources, including net-new sources and legacy sources transitioning from legacy reporting environments.
We want your talent If You Are Great At
- Interface with business systems analysts, solution designers, data architects, and other business stakeholders to understand the business requirements.
- Assist with analysis and profiling of various source data and understand the high-level relationships between data sources.
- Parse unstructured and semi-structured data such as JSON, XML etc.
- Design and develop efficient Mapping and workflows to load data onto Data Marts.
- Performance tuning of ETL/ELT mappings and queries.
- Design and develop ETL/ELT Pipeline for CI/CD.
- Ensure all forms of communication (verbal, email, business documents, and technical documents) are clear, concise, and professional.
- Develop, test, and document ETL/ELT solutions in a complex data warehouse environment with numerous disparate source systems.
- Use Microsoft SQL Server 2012, Snowflake and SSIS/ADF/DBT for data integration, Control-M for package scheduling, and TFS or Azure GIT repository for version control and task management.
- Use Agile/scrum project methodology.
- Ensuring that all development strictly adheres to the ETL/ELT framework, naming standards, and best practices as provided.
- Performing database modifications as required in accordance with team processes and standards.
- Provide production support for operations and on-call work of legacy and new data warehouses as assigned,
If You Have
- Post-secondary degree in Math, Computer Science, or Engineering or equivalent work experience.
- 4-6 years of IT experience.
- Minimum 3 years’ experience in ETL design and development in 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! you get to work from the office and at home 50/50, allowing you to manage both worlds with the ease and flexibility you need.
- We offer competitive salaries and support your financial health through our employee share purchase plan, pension plans, RRSP, discounts on staff insurance, and more!
- We help you prioritize your well-being from day one through flexible health benefits, early leave days, wellness programs, rewards, and recognition programs.
- We are invested in helping you grow in your career through education assistance, internal mobility, and mentoring programs.
- NBFC cares about the community and supports the causes you believe in with donation matching and team volunteer days.
Qui nous sommes Nous sommes la Financière Northbridge. Nous sommes fiers d’être une société canadienne à 100 %, détenue en propriété exclusive par Fairfax Financial. Nous offrons nos services par l’entremise de nos marques Northbridge Assurance, Les assurances Federated et TruShield Assurance. Nous sommes reconnus comme étant l’une des plus importantes sociétés d’assurance de dommages des entreprises au Canada. Nos employés sont engagés à comprendre les besoins de nos clients, et nous faisons tout en notre pouvoir pour aider les entreprises canadiennes à connaître un avenir meilleur et plus sécuritaire. Nous sommes une entreprise formée de personnes passionnées qui placent les gens au cœur de leurs préoccupations. Souhaitez-vous vous joindre à une équipe qui croit en l’importance de travailler fort, et d’avoir du plaisir au travail, tout en améliorant les choses? Ne cherchez pas plus loin que Northbridge.
À la Financière Northbridge, nous avons à cœur de créer un milieu de travail inclusif où nous célébrons les employés et les accueillons comme ils sont. Peu importe qui vous êtes ou ce qui vous rend unique, nous vous accueillons à bras ouverts. Veuillez simplement nous indiquer comment nous pouvons vous aider ou vous accommoder au cours du processus de sélection.
About Northbridge Financial Corporation
Northbridge Financial Corporation (NBFC) is a leading commercial property and casualty insurance group that has helped protect Canadian businesses for 100 years. We offer a wide range of innovative solutions through our Northbridge Insurance, TruShield Insurance, and Federated Insurance brands.
We’re passionate about protection, prevention and progress – for our customers, and in our communities. Our exceptional service and extensive offerings help Canadian businesses succeed, while our enthusiastic team works to support and uplift our neighbours from coast to coast to coast.
We’re proud to be 100% Canadian and are wholly owned by Fairfax Financial Holdings Limited.
We love where we work and think you will too!
...................................................................................
La Corporation financière Northbridge (la Financière Northbridge) est un chef de file en assurance de dommages des entreprises qui contribue à protéger les entreprises canadiennes depuis 100 ans. Nous offrons une vaste gamme de solutions novatrices sous les marques Northbridge Assurance, TruShield Assurance et Les assurances Federated.
Nous avons à cœur tout ce qui touche à la protection, à la prévention et au progrès, tant chez nos clients que dans nos collectivités. Notre service exceptionnel et notre large éventail de solutions novatrices aident les entreprises canadiennes à réussir, et notre équipe enthousiaste travaille à soutenir et accompagner leurs propriétaires d’un océan à l’autre.
Nous sommes fiers d’être une société canadienne à 100 %, détenue en propriété exclusive par Fairfax Financial Holdings Limited.
Nous aimons notre entreprise et nous pensons que vous l’aimerez aussi!