Responsibilities

• Own the Creative-Media data function end to end — the architecture, models, pipelines, and reporting behind how the client measures creative performance in media.
• Design, build, and maintain the data models that bring media, creative, and performance data together from across platforms, structured and ready for analysis.
• Build and maintain the ETL/ELT that ingests data from multiple media platforms and sources into Snowflake and BigQuery, with a focus on automation, reliability, and cost-efficiency.
• Develop and own Looker dashboards and the underlying LookML models as the client's primary measurement surface, with supporting reporting in Data Studio (Looker Studio) where it fits.
• Set the technical direction and standards for the function as it grows from its first hire, making the foundational decisions others will build on.
• Partner directly with the client's data science and creative strategy teams, and collaborate with peer engineers on the account who own adjacent areas of media.
• Apply genuine digital media fluency — platform metrics, asset-level creative performance, and the data behind them — to structure data correctly and keep reporting meaningful.
• Work across AWS and Google Cloud Platform to run the data stack end to end, and own data quality, documentation, and governance so teams can trust the reporting.

Requirements

• 8+ years of hands-on BI, analytics, or data engineering, ideally in a client-facing or agency setting.
• Deep, hands-on experience with Snowflake and BigQuery, and strong SQL.
• Demonstrated Looker / LookML expertise, plus experience with Data Studio (Looker Studio).
• Strong hands-on ETL/ELT experience across a range of tools and sources; familiarity with Matillion is a plus.
• Solid working experience across AWS and Google Cloud Platform.
• Direct, hands-on experience with paid media platforms (e.g., Meta, Google / YouTube, programmatic) and the data they generate, including how performance is measured.
• Solid engineering fundamentals — version control, testing, and disciplined data modeling and documentation.
• A track record of owning work end to end and setting your own technical direction with limited oversight.
• Strong communication skills, with comfort working directly with clients.

Benefits

• Healthcare, Dental, and Vision coverage
• 401k plan, plus matching
• PTO
• Paid Company Holidays
• Parental Leave