Penske Media Corp.

PMC: Principal Analytic Engineer

California - Los Angeles Office · Principal

No sponsorship$150k-$170kDetected 8 days ago

SQLBigQuerySnowflakeAWSGCPCloud PlatformsdbtData EngineeringData VisualizationGoogle AnalyticsCommunicationCollaboration

About the role

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.
You will have a chance to work on some of the best brands in media including Variety, Billboard, Deadline, WWD, and Rolling Stone.
If you have more or less experience than specified on this job posting, please apply and list your salary expectations.

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
Support the identification and maintenance of appropriate sources of truth across systems, with attention to data accuracy and usability
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
Investigate data discrepancies, document business logic clearly, and improve consistency in metric definitions
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.

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
Experience working with modern data warehouses such as Snowflake and/or BigQuery
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
Strong SQL skills and experience designing scalable data models for analytics and reporting use cases
Hands-on experience building transformation workflows using dbt or similar tools

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.

PMC-Paid Healthcare with no employee paycheck contributions on medical, dental, and vision for you and your family.
As part of PMC's dedication to consistently meeting employees' needs, we are currently launching a new Flexible Vacation Policy.
Daily, PMC's journalists and creators deliver the most comprehensive, ambitious, and courageous news coverage in their respective industries.
PMC's comprehensive benefits package is thoughtfully designed to support every aspect of your life, empowering you to thrive both personally and professionally.

Luminate, the premier music and entertainment data and analytics company.
Global Footprint
PMC is 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.
As part of a team, support break/fix scenarios when necessary and serve in an on-call rotation

This listing is sourced directly from Penske Media Corp.'s careers page and normalized into a canonical job model.