Senior Data Engineer (7-month Contract)

StackAdapt; Canada; Remote; CAD 90,000 - 120,000; Full time

Job summary

A leading company is seeking a Senior Data Engineer for a 7-month contract. This remote-first role involves managing data architecture and building data pipelines within the Data Lake and Data Warehouse. Ideal candidates will have extensive experience in data engineering, cloud infrastructure, and ETL/ELT processes. Join a diverse team focused on innovative data solutions.

Qualifications

• Minimum 5 years of experience in data engineering.
• Hands-on experience with cloud data warehouses.

Responsibilities

• Managing data architecture, engineering, and operations.
• Building reliable data ingestion pipelines from various data sources.

Skills

Data Engineering

Cloud Infrastructure

ETL/ELT Pipelines

Data Modeling

Collaboration

Tools

Snowflake

Apache Airflow

Terraform

Spark

Python

Job description

Join to apply for the Senior Data Engineer (7-month Contract) role at StackAdapt

StackAdapt is a self-serve advertising platform that specializes in multi-channel solutions including native, display, video, connected TV, audio, in-game ads, and digital out-of-home ads. We empower thousands of digitally-focused companies to deliver outcomes and exceptional campaign performance every day. Founded with a vision to be more than just an advertising platform, it’s a hub of innovation, imagination, and creativity.

We have an exciting opportunity in the newly formed Enterprise Data Office (EDO), which aims to serve business leaders and stakeholders with trusted reporting and governed self-service analytics. Reporting to the Director of EDO, the Senior Data Engineer will be responsible for data architecture, pipelines, operations, and platform management of the data lake and enterprise data warehouse under development.

This role involves assessing business requirements to develop holistic data solutions, building data ingestion pipelines from multiple sources, designing data models for immediate and broader analytical needs, and collaborating with BI Engineers to ensure stakeholder needs are met.

StackAdapt is a Remote-First company, open to candidates across Canada.

What You'll Be Doing

1. Managing data architecture, engineering, and operations within the Data Lake and Data Warehouse (Snowflake), including:
2. Building reliable data ingestion pipelines from various data sources into the Data Lake with metadata tagging.
3. Orchestrating data pipelines for batch, near-real-time, or real-time operations.
4. Advising on data architecture, modeling, operations, and platform decisions.
5. Supporting day-to-day pipeline operations through monitoring, troubleshooting, and remediation.

What You'll Bring To The Table

1. Minimum 5 years of experience in data engineering within an Enterprise Data Warehouse environment.
2. Hands-on experience with cloud data warehouses (e.g., Snowflake, BigQuery, Redshift) and big data formats (e.g., Delta Lake, Parquet, Avro).
3. Knowledge of data warehousing fundamentals (e.g., Kimball/Inmon, dimensional modeling, SCDs).
4. Experience managing cloud infrastructure on AWS/Azure/GCP, with knowledge of container technologies like Kubernetes.
5. Experience building ETL/ELT pipelines using scripts (Spark, Python, Java, SQL) and integration platforms (PowerCenter, DataStage, Talend).
6. Proficiency in orchestrating data operations with tools like Apache Airflow, Cron, Astronomer, and managing infrastructure with Terraform.

We value diversity and inclusivity. If you need accommodations during the interview process, please inform our Talent team.