Senior Data Engineer (Snowflake, dbt)

Quick Facts

• Role: Senior Data Engineer (Snowflake, dbt)

• Focus: Building and scaling media/marketing data pipelines and harmonized data products

Description

You will shape and implement the architecture of a global Media Data Foundation that unifies paid media, digital analytics, and marketing performance data. This hands-on role turns raw media and marketing data into trusted, harmonized data products used by marketing, media, and analytics teams worldwide. You will work with modern tools and collaborate with cross-functional stakeholders to deliver scalable and secure data solutions.

Responsibilities

• Build, maintain, and optimize data pipelines for ingestion, transformation, and delivery of media data from platforms like Meta, Google Ads, DV360, TikTok, The Trade Desk, GA4, CM360, and others

• Implement scalable solutions to handle many data sources, frequent API and schema changes, and high volumes of data

• Design and maintain harmonized cross-platform data models for media reporting in Snowflake

• Lead the move of transformation logic to dbt, including orchestration, testing, documentation, and CI/CD

• Partner with Solution Architects to translate high-level designs into detailed implementation plans

• Align data solutions with business needs with Technical Product Owners, media agencies, and market teams

• Enable data readiness for media dashboards (Power BI), marketing mix modelling/ROI analytics, and campaign taxonomy governance

• Implement frameworks to monitor data freshness, completeness, quality, and pipeline performance with automated alerting

• Ensure security and compliance across the pipeline, including access controls and data protection for internal and external consumers

• Ensure compliance with GDPR/CCPA and internal data governance policies (data product tiers, tagging, naming standards)

• Monitor and address vulnerabilities, including service account and secret management, following security best practices

Requirements

• 4+ years of data engineering experience with strong technical expertise and critical thinking

• Hands-on experience with dbt and strong Python programming

• Proficiency in Snowflake and strong data modeling expertise

• Experience with marketing/media/advertising data (ad platform APIs, campaign hierarchies, web analytics)

• In-depth knowledge of Snowflake security and governance: RBAC, secure views, data sharing, masking, row access policies, object tagging

• Ability to design and promote scalable solution patterns and standards for complex multi-source data platforms

• Familiarity with cloud platforms (Azure preferred; focus on Azure, including ADF)

• Experience with ETL/ELT and data integration tools (Adverity, Fivetran or similar) and batch orchestration

• Strong SQL and relational database design skills for efficient large-scale data retrieval and preparation

• Proven ability to collect and process raw data at scale using scripting, REST API integration, and SQL querying

• BI tool experience (Power BI preferred) to support reporting consumers

• Experience collaborating in global environments with virtual teams and external agencies

• Bachelor’s or Master’s degree in Data Science, Computer Science, Economics, or a related discipline