Principal, Data Analyst/BI Engineer

Role Overview

You will lead and own the end-to-end creative and media data function, designing trusted data architecture and analytics capabilities that support media and performance measurement. This is a hands-on principal role combining data engineering, BI/reporting, and strategic ownership in a collaborative marketing/tech environment.

Accountabilities

• Own the architecture, data modeling, pipelines, and reporting infrastructure for media/creative performance measurement.
• Build scalable data models integrating media, creative, and performance data across multiple platforms.
• Develop and manage ETL/ELT processes that ingest source data into cloud data warehouses with automation, reliability, and efficiency.
• Build and maintain Looker dashboards and LookML models for trusted measurement and reporting.
• Create reporting solutions using additional visualization tools when appropriate.
• Establish technical standards, processes, and foundational decisions to support growth of the data function.
• Partner with data science, creative strategy, media activation, and engineering teams to translate business questions into actionable insights.
• Apply strong digital media knowledge to structure datasets and keep performance reporting meaningful.
• Manage data quality, documentation, governance, and reliability across cloud-based data environments.
• Improve analytics workflows through disciplined engineering practices, automation, and scalable solutions.

Requirements

• 8+ years of hands-on experience in BI, analytics, data engineering, or related fields (ideally client-facing/agency).
• Advanced experience with Snowflake, BigQuery, SQL, and modern cloud data platforms.
• Strong expertise in Looker and LookML; experience building dashboards and reporting solutions.
• ETL/ELT development experience across multiple tools and data sources.
• Familiarity with Matillion is a plus.
• Working knowledge of AWS and GCP.
• Hands-on experience with paid media platforms (e.g., Meta, Google/YouTube, programmatic).
• Understanding of media performance metrics and creative measurement.
• Strong engineering fundamentals: version control, testing, documentation, and structured data modeling.
• Ability to independently own projects, set technical direction, and operate with limited oversight.
• Strong communication skills (posting truncates mid-sentence).