Senior Data Engineer

Apply Digital; Vancouver; On-site; CAD 120,000 - 180,000; Full time

Job summary

Apply Digital in Vancouver, Canada is seeking a senior Data Engineer to design and implement scalable data pipelines and architecture. You will define data requirements, migrate sources, and build transformation layers using dbt on Snowflake, plus identity resolution and semantic layers for reporting.

You will work with CRM/email platforms, engage stakeholders, enforce data security, and contribute to best practices in ELT/ETL, data governance and cloud data warehousing.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, or a related field.
• At least 5 years of experience in data engineering or related fields.
• Expert-level SQL and strong experience in ELT/ETL and cloud data warehousing, with hands-on Snowflake experience.
• Strong hands-on experience with dbt (modelling, tests, documentation, macros) and git-based workflows (branching, code review, CI/CD).
• Proven experience in data modelling (dimensional and semantic layers) and analysis techniques.
• Experience with customer data modelling and identity resolution across CRM, marketing and product sources.
• Experience integrating data with customer engagement platforms.

Responsibilities

• Define data requirements and technology stack for projects.
• Audit source systems and define migration guidelines.
• Translate business requirements into technical specs including data streams and warehouses.
• Design and build dbt transformations on Snowflake.
• Build pipelines that activate data in engagement platforms.
• Run audits of digital products and provide data foundation recommendations.
• Work in git-based workflows with CI/CD for warehouse objects.
• Define data architecture standards and optimize models for performance and cost.
• Plan activities to populate new solutions with current and historical data.
• Implement data security and access controls.
• Document data sources, ELT/ETL processes, and data lineage for discovery.

Skills

SQL

Data Modeling

Cloud Data Warehousing

Python

Data Architecture

Communication

Education

Bachelor's degree in Computer Science/Information Systems or related

Tools

dbt

Snowflake

Git/CI-CD

Spark/PySpark

Docker

Kubernetes

Job description

RESPONSIBILITIES:

Work with internal disciplines, vendors, clients and stakeholders to define data requirements and the technology stack for projects.

Audit source systems (CRM and marketing platforms such as Salesforce and Sailthru) and define migration guidelines: what to migrate, in what structure and in what order, for execution by internal or third-party teams.

Translate business requirements into technical specifications including data streams, integrations, transformations, databases and data warehouses.

Design and build transformation layers in dbt on Snowflake, including identity resolution, semantic layer and consumption/reporting layers.

Build and maintain pipelines that activate data in customer engagement platforms (e.g., Braze).

Run discovery audits of digital products (apps, games, web) and produce data foundation recommendations.

Work in git-based workflows with code review, dbt tests and existing CI/CD processes for warehouse objects.

Define the data architecture framework, standards and principles, including modelling, metadata, security and reference data; analyze and optimize existing architectures and models for performance and cost.

Create a plan of activities required to populate new solutions with all current and historical data.

Implement data security and access controls to ensure compliance with company policies and regulation.

Document data sources, ELT/ETL processes, data dictionaries and metadata to facilitate data discovery; maintain data lineage and data flow documentation.

Research, evaluate and recommend new technologies, and develop best practices for data management, security and privacy.

REQUIREMENTS:

A Bachelor's degree in Computer Science, Information Systems, or a related field.

At least 5 years of experience in data engineering or related fields.

Expert-level SQL and strong experience in ELT/ETL and cloud data warehousing, with hands-on Snowflake experience.

Strong hands-on experience with dbt (modelling, tests, documentation, macros) and git-based workflows (branching, code review, CI/CD).

Proven experience in data modelling (dimensional and semantic layers) and analysis techniques.

Experience with customer data modelling and identity resolution across CRM, marketing and product sources.

Experience integrating data with customer engagement platforms (Braze, Salesforce Marketing Cloud, Sailthru or similar).

Experience planning data migrations between platforms: source audit, mapping, target structure definition and historical backfill.

Working knowledge of Python for data tooling and automation.

Working knowledge of at least one major cloud platform (AWS or GCP) and its data services.

Demonstrated ability to troubleshoot data issues and develop effective solutions.

Comfortable producing written guidelines and recommendations for client and third-party teams.

Understanding of data privacy and security best practices.

Excellent communication and problem-solving skills.

Fluent English.

Nice to Have

Snowflake (SnowPro) or dbt certification; cloud certifications welcome.

Spark/PySpark.

Docker and Kubernetes.

Experience with consumer or digital-product data (apps, games, subscriptions).