Senior Data Engineer

Coast Capital Savings; Surrey; Hybrid; CAD 95,000 - 125,000; Full time

Job summary

A financial services provider in Surrey is seeking a Senior Data Engineer to design and operate a cloud-first Enterprise Analytics platform on AWS. The role involves building scalable data pipelines, ensuring data quality, and leading engineering standards. Ideal candidates should have over 10 years of data engineering experience, proficient in AWS and data modeling. Commitment to inclusion and teamwork is emphasized, welcoming diverse backgrounds.

Benefits

Inclusive work environment

Professional development opportunities

Qualifications

• 10+ years in data engineering with ownership of data platform builds.
• Proficiency in SQL and performance tuning.
• Expertise in star schema/Kimball modeling.

Responsibilities

• Design reliable ingestion and transformation pipelines on AWS.
• Translate business requirements into data models.
• Set engineering standards and mentor staff.

Skills

Data warehouse/data platform builds

Strong SQL

Star schema/Kimball modeling

Producing pipelines

Event/stream ingestion

Operationalizing data quality

Collaboration skills

Tools

AWS (S3, Glue, Lambda)

Informatica IDMC

Git-based workflows

Job description

Overview

Location(s): Help Headquarters (Surrey, BC); Toronto, ON

Job Type: Full Time Regular

myWork Program: Hybrid

Starting Salary Range: $95,900.00-$124,700.00

Background Screening Requirement:

• Enhanced Criminal Record Check (every 5 years)
• Credit Check (every 5 years)
• Identity Verification (every 5 years)
• Employment Verification
• References

Job Purpose

The Senior Data Engineer designs, builds, and operates our cloud-first Enterprise Analytics platform on AWS. You will partner with our Data Architect, Platform Engineering, DBAs, and Data Governance teams to ingest data from core banking and enterprise sources, transform it using repeatable, metadata‑driven patterns, and deliver curated data models that power self‑serve analytics, regulatory reporting, and enterprise decisioning. This role leads by example—establishing development standards, CI/CD practices, and data quality/governance controls across the engineering team—while ensuring all solutions meet CCS security, privacy, and regulatory expectations.

Accountabilities

Data Platform & Pipelines

• Design and deliver reliable, scalable ingestion and transformation pipelines on AWS using Informatica IDMC (e.g., Cloud Data Integration, Mass Ingestion, Cloud Data Quality, Cloud Data Governance & Catalog).

• Implement domain‑oriented, reusable data services and models optimized for analytics, regulatory reporting, and operational intelligence.

• Engineer pipeline observability and automate testing within CI/CD.

Modeling & Analytics Enablement

• Translate business and regulatory requirements into robust data models and marts.

• Apply best‑practice dimensional modeling (Kimball) and pragmatic lakehouse design.

Governance, Quality & Security

• Operationalize data governance policies with Informatica data governance and quality capabilities.

• Embed privacy and security by design across pipelines.

Regulatory & Risk Alignment

• Build data capabilities that support OSFI/FINTRAC/CDIC‑driven initiatives.

• Partner with Risk, Finance, Compliance, and Internal Audit to ensure traceable data lineage and control evidence.

Ways of Working & Leadership

• Set engineering standards and mentor engineers on cloud data engineering best practices.

• Contribute to backlogs, estimations, and delivery plans.

Skills & Qualifications

Minimum Job-Related Experience

• 10+ years in data engineering with significant ownership of data warehouse/data platform builds and 3+ years on cloud (AWS preferred).

• Strong SQL and performance tuning.

• Expert in star schema/Kimball modeling.

• Proven track record building production pipelines (Preferably on AWS leveraging core data services including Redshift).

• Experience with event/stream ingestion, CDC patterns

• Experience operationalizing data quality, lineage, metadata management, and access controls.

• Excellent collaboration and communication skills.

Nice-to-have

• Hands‑on expertise with Informatica IDMC and Informatica Cloud Data Quality & Governance.

• CI/CD for data and Infrastructure as Code.

• Experience building near‑real‑time analytics.

• Exposure to MDM, reference data management, and consent/privacy tooling.

• Background with the Microsoft BI stack to support legacy migrations.

• Demonstrated delivery in regulated financial services with familiarity across OSFI/FINTRAC/CDIC reporting.

• Familiarity with PCI DSS, PIPEDA/BC PIPA, data retention, and defensible deletion.

Tools & Environment

• Cloud: AWS (S3, Glue, Lambda, IAM; Lake Formation/Athena; Redshift)

• Integration & Quality: Informatica IDMC (Cloud Data Integration, Mass Ingestion, Cloud Data Quality), Informatica Cloud Data Governance & Catalog

• DevOps & Observability: Git‑based workflows, CI/CD for data, logging/metrics/alerting, data tests, lineage

Equity, Diversity & Inclusion at Coast Capital

Don’t meet every single requirement? At Coast Capital, we believe everyone has potential. We are committed to building better, brighter, more inclusive futures for everyone – including our employees. We see the potential in our employees to achieve amazing things and want to invest in your future. If you’re excited about this career opportunity and your experience may not perfectly align with every qualification in this job posting, we still encourage you to apply. You may be just the right candidate for this or other opportunities at Coast Capital.

At Coast Capital, we are committed to equity, diversity and inclusion. We strongly encourage applications from Indigenous Peoples, Black, and racialized persons, persons with disabilities, people of diverse sexual and gender identities and women. We value applicants who have demonstrated a commitment to equity, diversity and inclusion and recognize that diverse perspectives, experiences and expertise benefit of our employees, our members, and our community.

Coast Capital is committed to providing an accessible recruitment experience. If you are a candidate with a disability and require accommodation(s) during any stage of the recruitment process, please contact us at [e-mail] or 778-391-5836. This contact is intended solely for inquiries or feedback related to accessibility barriers, accommodation requests or alternate format requests. We will work with you to ensure your needs are met. You will only receive a response to inquiries related to these topics.