Principal, Data Analyst/BI Engineer

DEPT® is a Growth Invention company built to help the world’s most ambitious brands grow faster. They are seeking a Principal, Data Analyst/BI Engineer to work with clients on data related to media and creative measurement, focusing on building reliable data models and dashboards.

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
• 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
• Familiarity with Matillion