We are looking for a Snowflake Data Engineer with 5+ years of experience in data engineering or analytics engineering, with strong hands-on expertise in Snowflake, Azure Data Factory, AWS, and advanced SQL. The ideal candidate will have experience working with media, marketing, or AdTech data and be comfortable integrating and standardizing data from programmatic platforms, social platforms, ad servers, APIs, and file-based sources. Strong experience in data validation, reconciliation, transformation, data quality, and pipeline optimization is required.

Build, maintain, and optimize Snowflake data models, views, transformations, and reusable data pipelines. Validate and reconcile data across multiple sources to ensure data accuracy and trusted reporting. Implement, manage, and troubleshoot data feeds from APIs, files, and external media and marketing platforms. Develop subject matter expertise around vendor and partner APIs, available data feeds, and source-specific data structures. Normalize and standardize media and marketing data across disparate platforms, including naming conventions, schemas, data types, and transformation logic. Develop and maintain regex-based parsing logic for file ingestion, classification, and handling inconsistent schemas. Troubleshoot data discrepancies and proactively identify data quality issues while partnering with Data Operations and Project Managers on priority-based resolution. Partner with stakeholders to ensure datasets support reliable reporting and dashboards, while continuously improving query and pipeline performance.

Strong hands-on experience with Snowflake, including data modelling, transformations, views, and performance optimization. Strong experience with Azure Data Factory and Azure storage services, along with working knowledge of AWS S3, IAM, and Step Functions. Advanced SQL skills with proven experience in data transformation, validation, reconciliation, and complex data processing. Experience with dbt and familiarity with Medallion Architecture and structured data transformation frameworks. Experience working with media, marketing, or AdTech data sources, including programmatic platforms, social platforms, and ad servers. Experience handling data feeds from Excel, CSV, APIs, and other sources with inconsistent schemas, requiring normalization and standardization. Hands-on experience with Azure DevOps, version control, change management, and CI/CD pipeline practices. Experience with Claude Code or another agentic development platform, with Alteryx, Improvado or similar marketing ETL tools considered an advantage.