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.
#LI-TS1
Who we are:
We’re Northbridge Financial. We’re proud to be 100% Canadian and owned by Fairfax Financial. We serve through our Northbridge Insurance, Federated Insurance, and TruShield Insurance brands. We have a reputation for being one of Canada’s leading commercial property and casualty insurance company. Our employees are dedicated to understanding the needs of our customers and we go above and beyond to help Canadian businesses have a safer and brighter future. We’re a company of passionate people who put people first. Do you want to join a team that believes in working hard – and having fun at work – all while making a difference? Look no further than Northbridge.
At Northbridge Financial we embrace and celebrate you and are committed to creating an inclusive workplace for all! No matter who you are or what makes you unique, we welcome you. Please let us know how we can assist or accommodate you during the selection process.
