Senior Data Engineer (7-month Contract)

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

Job summary

StackAdapt, a leading self-serve advertising platform, is seeking a Senior Data Engineer to join their newly formed Enterprise Data Office. This remote role focuses on data architecture, pipeline management, and operational oversight in a collaborative environment. With a strong commitment to diversity, StackAdapt offers an innovative workplace where your contributions will have a significant impact.

Qualifications

• Minimum 5 years of experience in data engineering within an Enterprise Data Warehouse environment.
• Hands-on experience with cloud data warehouses (e.g., Snowflake, BigQuery, Redshift).
• Proficiency in scripting languages like Spark, Python, Java, SQL.

Responsibilities

• Managing data architecture and operations within the Data Lake and Enterprise Data Warehouse.
• Building reliable ingestion pipelines from various data sources.
• Orchestrating data pipelines for seamless execution.

Skills

Data architecture

Data engineering

ETL/ELT pipelines

Cloud infrastructure

Scripting languages

Tools

Snowflake

Apache Airflow

Terraform

Job description

StackAdapt is a self-serve advertising platform specializing 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, StackAdapt is 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 currently under development.

This role involves assessing business requirements gathered by the Business Data Analysis team to formulate comprehensive data solutions that meet or exceed BI needs. Responsibilities include building ingestion pipelines from multiple sources, architecting data models for immediate and broader analytical purposes, and collaborating with BI engineers to ensure data consumption needs are met.

StackAdapt is a Remote-First company, open to candidates located anywhere in Canada.

What You'll Be Doing

1. Managing data architecture, engineering, and operations within the Data Lake and Enterprise Data Warehouse (Snowflake), including building reliable ingestion pipelines from various data sources.
2. Orchestrating data pipelines via batch, near-real-time, or real-time operations to ensure seamless execution.
3. Advising on data architecture, modeling, operations, and platform decisions.
4. Supporting daily operations by monitoring alerts, troubleshooting, and remediating production issues.

What You'll Bring to the Table

1. Minimum 5 years of experience leading data engineering in 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, conformed dimensions, SCDs).
4. Experience managing cloud infrastructure on AWS/Azure/GCP, with knowledge of container technologies like Kubernetes and networking fundamentals.
5. Proficiency in building ETL/ELT pipelines using scripting languages (e.g., Spark, Python, Java, SQL stored procedures) and integration platforms (e.g., PowerCenter, DataStage, Talend).
6. Experience orchestrating data operations with tools like Apache Airflow, Cron, Astronomer, and managing infrastructure-as-code with Terraform.

At StackAdapt, we value diversity and inclusivity. Regardless of your background, identity, or abilities, you are welcome. Please inform our Talent team of any accommodations needed during the interview process.

About StackAdapt

Recognized for our diverse and supportive workplace, high-performing campaigns, and innovation, we've received awards such as:

• Ad Age Best Places to Work 2024
• G2 Top Software and Marketing Products 2024
• Campaign’s Best Places to Work 2023 UK
• 2024 Best Workplaces for Women and in Canada by Great Place to Work
• #1 DSP on G2 and leader in Cross-Channel Advertising

#LI-Remote