Director, Data Engineering
Core
Design, develop, and optimize scalable data solutions and platforms for a media agency, connecting real-time data with creative and media content to drive growth and ROI.
Role type
Director, Data Engineering
Builds
Data-driven software platforms, scalable data pipelines, and advanced Snowflake/Databricks data models for media measurement and analytics.
Domain
Digital Media & Advertising
Deliverable
production ML models
Required skills
Advanced SQL (CTEs, window functions, stored procedures), Snowflake, Databricks, PySpark, Delta Lake, Data Modeling (Star Schema), AWS Glue, Python, ETL/ELT, CI/CD, Git, Cloud Platforms (AWS/Azure/GCP), Business Intelligence tools (Tableau/Power BI), REST APIs.
Preferred skills
Media Agency experience, Redshift, Machine Learning principles, Unity Catalog, Digital media measurement and analytics.
Responsibilities
Analyze complex business requirements and partner with product/analytics teams to design scalable data solutions; Design, develop, and optimize complex SQL transformations and data pipelines in Snowflake and Databricks; Develop advanced Snowflake database objects including Stored Procedures, UDFs, Views, Tasks, Streams, and Dynamic Tables; Design scalable data models to support reporting and downstream applications; Troubleshoot database issues and optimize stored procedures for performance; Extract, transform, and load data from multiple sources using Python and AWS Glue; Mentor a team and serve as an escalation point for technical issues.
Seniority
Director, hands-on IC with team leadership