Lead Data Engineer - Retail Media Network

The Intersect Group

  • Remote
  • Remote
  • Posted Aug 14, 2026
Sign up — let your agent apply Sign in

BestApply tailors your resume and applies for you.

Data WarehousingData QualityMedallion ArchitectureSnowpipeStreamsSnowparkSQLPythonOLAPOLTPData GovernanceEntity Relationships

Job description

About the role

As Lead Data Engineer you will design and optimize Snowflake‑based analytics data architectures, own key technical decisions, establish best‑practice adoption, and lead the development of scalable batch and near‑real‑time pipelines that serve BI and data‑science teams across the retail advertising ecosystem.

About the company

The employer runs a fast‑growing Retail Media Network that powers advertising and customer insights for retailers, focusing on data‑driven solutions.

Requirements

  • 6+ years of data engineering experience with lead‑level ownership of delivery and architecture decisions.
  • Strong hands‑on expertise with Snowflake, including Snowpipe, Streams, and Tasks.
  • Advanced SQL and data transformation skills.
  • Python experience, especially with Snowpark (preferred).
  • Proven experience building analytics‑focused data warehouses.
  • Deep understanding of dimensional modeling (star and snowflake schemas), data warehousing architecture, data quality and governance, entity relationships, and OLTP vs OLAP concepts.
  • Knowledge of medallion architecture concepts.
  • Experience with integration/orchestration tools such as dbt, Airflow, and Fivetran (nice to have).
  • Background in retail or retail media network environments (nice to have).
  • Familiarity with customer data platforms (CDPs) and advertising/attribution datasets (nice to have).
  • Experience supporting analytics and BI use cases at scale (nice to have).
  • Exposure to AI/ML data pipelines and building AI‑ready datasets (nice to have).
  • Authorization to work in the United States.