Loading jobs…
Loading jobs…
Penske Media — Los Angeles, California
PMC is seeking a Senior Analytic Engineer to help shape how data is sourced, integrated, and structured within our data warehouse, ensuring it is consistent, trusted, and usable for decision-making across PMC. This role sits at the intersection of analytics engineering and data engineering, with responsibility for helping build and maintain the data models, transformation workflows, and quality standards that make data from CMS platforms, web analytics tools, ad tech systems, and internal applications reliable and useful. As a senior individual contributor, you will be a hands-on builder who designs scalable data models, contributes to ingestion and transformation strategies, and partners with Data Engineering and analytics stakeholders to deliver well-structured, business-ready datasets.
You will have a chance to work on some of the best brands in media including Variety, Billboard, Deadline, WWD, and Rolling Stone.
Key Responsibilities
: Design, build, and maintain scalable data models that transform raw data into structured, business-ready datasets Develop and improve transformation workflows (e.g., dbt) within Snowflake and BigQuery environments, contributing hands-on to complex modeling efforts Help define how data is sourced and integrated from key systems, including CMS platforms, web analytics tools, ad tech platforms, and business applications Support the identification and maintenance of appropriate sources of truth across systems, with attention to data accuracy and usability Establish and follow standards for how data is organized, documented, and used across the data warehouse Implement data quality checks, validation frameworks, and monitoring to ensure reliability of critical datasets Partner closely with Data Engineering on ingestion patterns, pipeline performance, and upstream data quality Build datasets that support consistent analysis across Editorial, Product, Audience, Ad Sales, and Finance use cases Support BI tools such as Looker with well-defined, governed datasets that reduce fragmentation in reporting Translate analytics and reporting
Requirements
into scalable data models and transformations Investigate data discrepancies, document business logic clearly, and improve consistency in metric definitions Contribute to best practices for modeling, transformation, and documentation across the team As part of a team, support break/fix scenarios when necessary and serve in an on-call rotation
Qualifications
: You do not need to check every box for the experience below. If you are passionate about this opportunity, we would love to hear from you.