Sr. Associate

Role overview

Responsibilities

• Onboard and normalize multi-source marketing, media, and platform data through Adverity and Data Refinery pipelines.
• Ingest, model, and reconcile DSP data against CM360; resolve discrepancies in impressions, spend, and attribution.
• Maintain governed Trifacta recipes to cleanse, standardize, and shape raw data.
• Govern Databricks assets, including catalogs, schemas, permissions, lineage, and metadata.
• Build and optimize SQL and PySpark transformations, notebooks, and workflows across medallion architecture layers.
• Operate data quality checks for integrity, schema validation, reconciliation, and error monitoring.
• Use modular, tested, documented transformations and GitHub for version control, CI/CD, review, and change governance.
• Build reusable, documented models and prepare certified datasets for analytics, AI, and Power BI reporting.
• Work with analysts, engineers, and business leads; contribute to quality standards, monitoring, and platform roadmap.

Qualifications

• 4–6+ years of experience as a Data Engineer or similar, building and operating scalable production data pipelines.
• Bachelor's degree in Computer Science, Engineering, Information Systems, or a related field required; graduate degree preferred.
• Hands-on experience with Adverity and Data Refinery ingestion pipelines across multiple marketing and media sources.
• Experience with Trifacta (Alteryx Designer Cloud) transformations and governed wrangling recipes.
• Advanced Databricks experience, including Unity Catalog, SQL, PySpark, Workflows, Notebooks, and Jobs.
• Experience designing and operating data quality checks, reconciliation, schema validation, and automated monitoring in Databricks.
• Familiarity with dbt and GitHub; strong SQL and Python proficiency; working knowledge of medallion architecture, modeling, lineage, and governance.

Platforms and data domains

• The data environment includes Adverity, Trifacta, Databricks Unity Catalog, SQL, PySpark, Python, dbt, GitHub, and Power BI.
• Programmatic media sources include DSP platforms such as DV360, The Trade Desk, and Amazon DSP, reconciled against CM360.