Data Platform Engineer - ETL, Data Lake & Cloud

Love Where You Work; Headquarters; On-site; CAD 110,000 - 140,000; Full time

Job summary

Love Where You Work in Canada is seeking a Data Engineer to own the design, development, and optimization of the data infrastructure that underpins analytics, reporting, and machine learning initiatives within a regulated financial environment.

The role collaborates with business intelligence analysts, compliance teams, and technology leadership to translate complex data challenges into reliable, scalable solutions.

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, Data Engineering, or related field (or equivalent professional experience)
• 3–5 years of hands‑on experience in data engineering, data infrastructure, or related role
• Advanced proficiency in SQL and experience with large-scale relational and columnar databases (e.g., PostgreSQL, Redshift, Snowflake, BigQuery)
• Strong Python skills for data pipeline development and automation
• Experience designing and maintaining ETL/ELT workflows using dbt or Matillion
• Working knowledge of at least one major cloud platform (Snowflake, AWS, Azure, or GCP) and associated data services
• Solid understanding of data warehousing concepts including dimensional modeling and schema design
• Experience implementing data quality monitoring, lineage tracking, and observability practices
• Strong communication skills with the ability to work across technical and non-technical audiences

Responsibilities

• Architect, build, and maintain robust ETL/ELT pipelines to integrate data from core banking systems, lending platforms, digital banking channels, and third-party vendors
• Design and manage the credit union’s data warehouse and data lake, including schema design, partitioning strategies, and performance optimization
• Develop and enforce data quality frameworks, including automated testing, validation rules, and alerting for pipeline anomalies
• Lead the implementation of data modeling best practices (dimensional modeling, data vault, or similar) to support scalable analytics
• Collaborate with data analysts, compliance officers, and business stakeholders to define data requirements and deliver trusted data products
• Manage orchestration and scheduling of data workflows using tools such as Matillion, Snowflake, or equivalent
• Evaluate, implement, and maintain cloud data infrastructure on Snowflake or Azure, including compute, storage, and networking resources
• Ensure all data processes comply with applicable regulations, including NCUA guidelines, BSA/AML requirements, and GLBA data privacy standards
• Partner with the IT security team to enforce data access controls, encryption standards, and audit logging
• Mentor junior data engineers and analysts, providing technical guidance and code reviews
• Drive adoption of DataOps practices, including CI/CD for data pipelines, version control, and documentation standards
• Support data migration efforts during platform transitions, core system upgrades, or mergers and acquisitions
• Works a regular and predictable schedule.

Skills

SQL

Python

dbt

Matillion

Snowflake

Cloud platforms (AWS/Azure/GCP)

Data Warehousing

ETL/ELT

Data quality monitoring

CI/CD for data pipelines

Education

Bachelor’s degree in Computer Science or related field

Tools

dbt

Matillion

Snowflake

Power BI

Tableau

Looker

AWS/Azure/GCP

PostgreSQL/Redshift

Job description

Love Where You Work in Canada is seeking a Data Engineer to own the design, development, and optimization of the data infrastructure that underpins analytics, reporting, and machine learning initiatives within a regulated financial environment.

The role collaborates with business intelligence analysts, compliance teams, and technology leadership to translate complex data challenges into reliable, scalable solutions.