PMC: Principal Analytic Engineer

Penske Media Corp. • Los Angeles, CA

12h • $150,000 - $170,000 • Hybrid

About The Position

We are seeking a Principal Analytic Engineer to lead 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 data engineering and business operations, with responsibility for shaping how data from a wide range of systems—CMS platforms, web analytics tools, ad tech systems, and internal applications—is collected, standardized, and made available for use. As a senior individual contributor, you will operate as both architect and hands-on builder: designing data models, guiding data ingestion and transformation strategies, and working closely with stakeholders to ensure data aligns with real business needs across editorial, audience, product, and advertising teams. You will have the chance to work on some of the largest, trusted brands in entertainment and fashion news, including Variety, Billboard, Deadline, WWD, and Rolling Stone.

Requirements

• 8+ years of experience in data engineering, analytics engineering, or related roles
• Expert-level SQL and strong experience designing scalable data models for analytics and reporting use cases
• Proven experience working with modern data warehouses (e.g., Snowflake, BigQuery) and cloud environments (AWS and/or GCP)
• Hands-on experience building transformation workflows (e.g., dbt or similar tools)
• Experience working with complex, multi-source data environments (e.g., combining web analytics, ad tech, and business systems)
• Familiarity with Google Analytics 4 and Parsely analytics platforms
• Experience working with advertising data (e.g., Google Ad Manager, programmatic ecosystems)
• Experience evaluating and reconciling conflicting data sources
• Experience implementing data quality, validation, and monitoring practices
• Experience supporting BI tools such as Looker

Responsibilities

• Define how data is sourced and integrated from key systems, including CMS platforms, web analytics tools, ad tech platforms, and business applications
• Evaluate and establish appropriate sources of truth across competing systems, ensuring data is accurate and fit for use
• Design and maintain scalable data models that transform raw data into structured, business-ready datasets
• Lead development of transformation workflows (e.g., dbt) within Snowflake and BigQuery environments, contributing hands-on to complex modeling efforts
• Establish 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 with Data Engineering on ingestion patterns, pipeline performance, and upstream data quality
• Structure data to support consistent interpretation across Editorial, Product, Audience, Ad Sales, and Finance teams
• Support BI tools (e.g., Looker) with well-defined, governed datasets and reduce fragmentation in reporting
• Translate business needs into scalable data solutions, working closely with cross-functional stakeholders
• Act as a central authority on data meaning, resolving questions around definitions, discrepancies, and interpretation
• Establish best practices for modeling, transformation, and documentation while mentoring analysts and engineers
• As part of a team, support break/fix scenarios when necessary and serve in an on-call rotation

Benefits

• PMC-Paid Healthcare with no employee paycheck contributions on medical, dental, and vision for you and your family
• Flexible Spending Accounts (Healthcare, Dependent Care & Commuter)
• Employee Assistance Program
• Life Insurance
• Short- & Long-Term Disability
• Paid Parental Leave
• 401(k) Retirement Plan with an Employer match
• Company discounts and perks including Pet Insurance, Home & Auto Insurance, Mortgage discounts, and a variety of other savings on wellness, lifestyle, and financial essentials
• Flexible Vacation Policy

What This Job Offers

• Job Type: Full-time
• Career Level: Principal
• Education Level: No Education Listed
• Number of Employees: 101-250 employees