Note: The job is a remote job and is open to candidates in USA. DEPT® is a Growth Invention company operating at the intersection of technology and marketing to help ambitious brands grow faster. The Principal, Data Analyst/BI Engineer will own the end-to-end Creative-Media data function, building data models, ETL/ELT pipelines, Snowflake and BigQuery integrations, and Looker dashboards. The role also sets technical direction, partners with client data science and creative strategy teams, and ensures data quality and governance across cloud platforms.
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
Skills
- 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
Benefits
- Healthcare, Dental, and Vision coverage
- 401k plan, plus matching
- PTO
- Paid Company Holidays
- Parental Leave
Company Overview