Data Engineer (Data Modeling/Data Governance)

Scotiabank; Toronto; Hybrid; CAD 120,000 - 150,000; Full time

Job summary

Tangerine, Canada’s leading digital bank, is hiring an experienced Data Engineer to design, develop, and support scalable data solutions in a financial services setting. You will work with GCP, BigQuery, Airflow, Informatica, Python, SQL, and Git to build data products with strong governance and security practices.

Join a collaborative team delivering innovative banking solutions and data-driven insights, with hybrid work options and a focus on integrity, inclusion, and impactful communities

Qualifications

• Design, develop, and support scalable data pipelines, data warehouses, data models, and data products.
• Cloud-based data solutions using GCP and BigQuery with ETL/ELT focus.
• Strong governance, metadata, lineage, data quality, security, and privacy principles.

Responsibilities

• Design, build, and support scalable data pipelines, data warehouses, data models, and data products.
• Develop cloud-based data solutions using GCP, BigQuery, Airflow, Informatica, Python, and SQL.
• Collaborate with business, architecture, governance, security, and technology teams.

Skills

Data engineering

Data governance

Stakeholder management

Communication

Mentoring

Education

University or college degree or equivalent experience

Tools

GCP

BigQuery

Apache Airflow

Informatica

Python

SQL

Git

Data modeling tools

Job description

At Tangerine,we’reredefining banking. As Canada’s leading digital bank, we thrive on innovation, agility, and bold thinking, tackling every challenge head-on with leading technology and the unstoppable power of collaboration.

Our client-obsessed teams deliver flexible, accessible banking solutions, breakthrough products, and award-winning service. Beyond banking,we’recommitted to making an impact in the communities we serve and across our organization. We foster a culture built on integrity, inclusion, and fearless ambition – where diverse perspectives are valued, and people are empowered to do their best work.

Are you ready to disrupt the status quo? Do you crave challenges that push boundaries? Ifyou’rea high performer looking to accelerate your career and reimagine the banking landscape, this is your moment.

Let’sshape the future of banking together!

Position Overview

We are looking for an exp erienced Data Engineer to design, develop, and support scalable enterprise data solutions within a financial services environment.

The ideal candidate will have strong hands-on experience in data engineering, data modeling, data warehouse development, and building data products, with expertise in GCP, BigQuery, Apache Airflow, Informatica, Python, SQL, and Git. A strong focus on data governance, data quality, security, and privacy is essential.

Is this role right for you?

In this role, you will:

• Design, build, and support scalable data pipelines, data warehouses, data models, and data products.
• Develop cloud-based data solutions using GCP, BigQuery, Apache Airflow, Informatica, Python, and SQL.
• Design conceptual, logical, physical, and dimensional data models.
• Build reliable ETL/ELT processes and optimize data transformation workloads.
• Apply data governance, metadata, lineage, data quality, security, privacy, and access-control principles throughout solution design and development.
• Troubleshoot data and technical issues and recommend effective solutions.
• Produce clear technical documentation covering data models, data flows, designs, and operational processes.
• Collaborate with business, architecture, governance, security, and technology teams.
• Participate throughout the SDLC, including design, development, testing, deployment, release, and production support.
• Provide technical guidance and support engineering best practices.

Do you have the skills that will enable you to succeed in this role?

We'd love to work with you if you have:

• University or College degree in a relevant field, or equivalent professional experience.
• 5+ years of experience in data engineering, data management solution design, and development.
• Strong experience in data modeling, data warehouse development, ETL/ELT, and data product development.
• Strong financial services background, with retail banking knowledge preferred.
• Proven ability to work effectively with technical and business stakeholders.
• Strong analytical, problem-solving, and documentation skills.
• Strong hands-on experience with: GCP and BigQuery,Apache Airflow, Informatica,Python and SQL,Git,Data modeling and dimensional modeling,Data warehouse design and development,ETL/ELT and data pipeline engineering,Data product development,Data governance, metadata, lineage, and data quality,Data security, privacy, and access control,SDLC and release management
• Excellent written and verbal communication skills.
• Strong analytical and problem-solving abilities.
• Strong collaboration and stakeholder-management skills.
• Commitment to data quality, governance, security, reliability, and maintainability.
• Positive, proactive attitude with the ability to influence, lead, and mentor others.

What's in it for you?

• You will be part of a diverse and inclusive team of Client-focused go-getters looking to learn from each other in an environment that celebrates and recognizes success!
• You will have access to thousands of online and in person courses so you can shape your career growth with the support from diverse industry leaders.
• You will get our help to save for your future and to invest in your total wellbeing through our Tangerine benefits*.
• You belong here, we are equal and un-complicated. Bring your true self to work, dress codes don’t apply here.
• You will enjoy workspace flexibility and all the excitement that comes from working at the official Bank of the Toronto Raptors.

*Tangerine employees participate in Scotiabank’s pension & benefits programs (available to permanent employees)

At Tangerine we value the unique skills and experiences each individual brings to the team, and are committed to creating and maintaining an inclusive and accessible environment. If you require accommodation during the recruitment and selection process, please let our Recruitment team know.