We're looking for a hands-on Data Engineer with 5+ years of experience building and optimizing pipelines across Snowflake, Azure, and AWS to own the data infrastructure behind media and marketing reporting.
This role sits at the intersection of engineering and media/marketing domain expertise — you'll build and maintain Snowflake data models and transformations, validate and reconcile data across multiple vendor and partner sources, and normalize inconsistent media data (naming conventions, schemas, data types) coming from programmatic platforms, social platforms, and ad servers into trusted, standardized datasets.
Responsibilities
- Build, maintain and optimize Snowflake data models, views and transformations
- Validate and reconcile data across multiple sources to ensure reporting accuracy
- Implement, manage and troubleshoot data feeds
- Have or develop awareness of what is available in vendor/partner APIs and data feeds (develop subject matter expertise)
- Normalize and standardize media data across disparate platforms (naming conventions, schemas, etc.)
- Implement consistent data typing, casting and transformation logic
- Develop and maintain regex-based parsing logic for file ingestion and classification
- Troubleshoot data discrepancies and proactively identify data quality issues — partner with data ops and project managers to work on priority-based incident response and issue resolution
- Partner with stakeholders to ensure datasets support trusted reporting and dashboards
- Improve performance and maintainability of existing queries and pipelines
- 5+ years in data engineering or analytics engineering roles (or equivalent hands-on pipeline experience)
Required Skills
- Strong hands-on experience with the following technologies:
- Snowflake
- Azure (Data Factory, storage or related services)
- AWS (S3, IAM, Step Functions)
- SQL (advanced level)
- Alteryx (preferred, but not required)
- dbt knowledge; comfortable working within a medallion architecture
- Experience working within a structured version control environment through Azure DevOps, following standard change management protocols, code management, etc.
- Working knowledge of CI/CD pipeline best practices via Azure DevOps
- Experience with media or marketing data sources such as (agency-side experience preferred): Programmatic platforms (Viant, Yahoo, Amazon, etc.) Social platforms (Meta, TikTok, etc.) Ad servers (Campaign Manager, etc.)
- Experience with a variety of data feeds (Excel, CSV, APIs) and experience managing inconsistent schemas
- Strong understanding of data normalization and standardization in marketing datasets
- Proven experience with data validation, QA and reconciliation
- Experience with Claude Code or some other agentic development platform
Nice to have
- Experience with Improvado or similar marketing ETL tools
- Familiarity with regex-based file handling and parsing logic
- Experience building reusable data models or transformation frameworks
- Exposure to BI tools (Looker, Tableau, etc.)