PMC: Principal Analytic Engineer

Penske Media Corporation; Los Angeles (CA); Hybrid; USD 150,000 - 170,000; Full time

Benefits offered by this job

Healthcare benefits

Flexible vacation policy

401(k) employer match

Job summary

Penske Media Corporation seeks a Principal Analytic Engineer to shape data sourcing, modeling, and transformation across CMS platforms, web analytics, ad tech, and internal apps. You will design scalable data models and contribute hands-on to ingestion strategies, partnering with Data Engineering to deliver trusted, business-ready datasets for decision-making.

You will collaborate with stakeholders to define data quality standards, maintain documentation, and support BI tools like Looker.

Qualifications

• 6+ years of experience in analytics engineering, data engineering, or related roles.
• Strong SQL skills and experience designing scalable data models for analytics and reporting use cases.
• Experience with modern data warehouses like Snowflake and BigQuery.
• Hands-on experience building transformation workflows using dbt or similar tools.
• Experience with complex, multi-source data environments (web analytics, ad tech, business systems).
• Familiarity with Google Analytics 4 and Parse.ly analytics platforms.
• Experience with advertising data including Google Ad Manager.
• Experience implementing data quality, validation, and monitoring practices.
• Experience supporting Looker.

Responsibilities

• Design, build, and maintain scalable data models transforming raw data into structured datasets.
• Develop and improve transformation workflows (e.g., dbt) within Snowflake and BigQuery.
• Define how data is sourced and integrated from CMS, web analytics, ad tech, and business systems.
• Identify sources of truth and ensure data accuracy and usability across systems.
• Establish standards for data organization, documentation, and usage in the warehouse.
• Implement data quality checks, validation, and monitoring for critical datasets.
• Collaborate with Data Engineering on ingestion patterns and pipeline performance.
• Build datasets supporting cross-functional analysis across Editorial, Product, Audience, Ad Sales, and Finance.
• Support Looker with governed datasets to reduce reporting fragmentation.
• Translate analytics requirements into scalable models and transformations.
• Investigate data discrepancies and document business logic for consistency.
• Contribute to best practices for modeling, transformation, and documentation.
• Provide on-call support for break/fix scenarios.

Skills

SQL

Data modeling

dbt

Snowflake/BigQuery

GA4/Parse.ly

Advertising data

Looker

AWS/GCP

Multi-source data

Data quality

Tools

dbt

Job description

PMC is seeking a Principal 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.

• At least 6+ years of experience in analytics engineering, data engineering, or related roles
• Strong SQL skills and experience designing scalable data models for analytics and reporting use cases
• Experience working with modern data warehouses such as Snowflake and/or BigQuery
• Hands-on experience building transformation workflows using dbt or similar tools
• Experience working with complex, multi-source data environments, including web analytics, ad tech, and business systems
• Familiarity with Google Analytics 4 and Parse.ly analytics platforms
• Experience working with advertising data, including Google Ad Manager or related programmatic ecosystems
• Experience investigating and reconciling conflicting data sources
• Experience implementing data quality, validation, and monitoring practices
• Experience supporting BI tools such as Looker
• Familiarity with cloud environments such as AWS and/or GCP

What Success Looks Like

• Trusted, well-documented datasets for audience, content, and revenue reporting are broadly used across teams
• Recurring discrepancies between key systems are reduced through thoughtful data modeling, validation, and source selection
• Teams increasingly rely on shared, well-structured datasets instead of one-off logic and fragmented reporting
• Standardized data models are adopted across core reporting use cases, reducing duplicate logic and inconsistency
• Data consumers have greater confidence in key metrics and can more easily understand how important KPIs are defined
• A more unified and usable data layer supports better decisions around content performance, audience engagement, and monetization
• Improvements to data models, documentation, and metric definitions are durable, maintainable, and shared across the Data team

As PMC values in-person collaboration and team cohesion, employees work onsite 4 days a week and 1 day remotely with a focus on maintaining a vibrant and inclusive culture.

Typical wage range: $150k - $170k. Factors that could be used to determine your actual salary may include your specific skills, years of experience and comparison to current employees already in this role. If you have more or less experience than specified on this job posting, please apply and list your salary expectations.

If hired, employee will be in an “at-will position” and the Company reserves the right to modify base salary (as well as any other discretionary payment or compensation program) at any time, including for reasons related to individual performance, Company or individual department/team performance, and market factors).

It’s All About You…

PMC's comprehensive benefits package is thoughtfully designed to support every aspect of your life, empowering you to thrive both personally and professionally. We offer PMC-Paid Healthcare with no employee paycheck contributions on medical, dental, and vision for you and your family. PMC also offers Flexible Spending Accounts (Healthcare, Dependent Care & Commuter), an Employee Assistance Program, Life Insurance, Short- & Long-Term Disability, Paid Parental Leave, and a 401(k) Retirement Plan with an Employer match. Employees are also eligible to take advantage of company discounts and perks including Pet Insurance, Home & Auto Insurance, Mortgage discounts, and a variety of other savings on wellness, lifestyle, and financial essentials. As part of PMC's dedication to consistently meeting employees’ needs, we are currently launching a new Flexible Vacation Policy.

At PMC, we believe working in a highly collaborative, office-first environment fosters real-time communication, spontaneous idea sharing, and stronger interpersonal relationships that drive innovation and team cohesion. PMC prioritizes in-person collaboration and does not offer remote-only roles.

Penske Media Corporation (PMC) is a leading global media and information services company whose award-winning content attracts a passionate monthly audience of more than 500 million people. Since 2004, PMC has been a pioneer in digital media and owns over 300 live events, while reaching audiences across all screens. Penske Media is recognized, as one of the Top 100 Private Companies in the United States and North America.

• Iconic Media Brands (PMX): Variety, Rolling Stone, The Verge, Billboard, The Hollywood Reporter, WWD, SHE Media, Robb Report, Deadline, Eater, Sportico, ARTnews, Fairchild Media, VIBE, IndieWire, SB Nation, ARTFORUM, POPSUGAR, Gold Derby, BEAUTY INC, Art in America, Punch, The Dodo, and more.
• Live Events & Experiences: The Golden Globes, SXSW, Academy of Country Music Awards (ACMs), Billboard Music Awards (BBMAs), Dick Clark's New Year’s Rockin’ Eve, SXSW London, American Music Awards (AMAs), and Latin Music Week.
• Data & Analytics: Luminate, the premier music and entertainment data and analytics company.

Global Footprint

PMC and its subsidiaries are co-headquartered in New York and Los Angeles, with additional offices spanning 14 countries worldwide.

Want to learn more? Visit www.PMC.com to explore our complete portfolio.