Lead Data Analyst
We are seeking an analytically rigorous and business-oriented Lead Data Analyst to help transform how our newsroom, product, marketing, and advertising teams use data to grow digital subscriptions and audience engagement. This role combines SQL, statistical analysis, audience segmentation, and AI-enabled analytics to uncover retention and conversion opportunities, develop actionable audience segments for testing and personalization, and enable stakeholders to explore trusted data through conversational and self-service analytics tools built on BigQuery, dbt, and modern AI workflows.
What You’ll Do
- Analyze user engagement and retention patterns using behavioral data in BigQuery, applying lightweight statistical models (e.g., logistic regression, survival analysis) to identify drivers of conversion, churn risk, and lifetime value
Develop and operationalize audience segments using clustering and propensity modeling (e.g., k-means, logistic regression) within dbt/SQL workflows, enabling targeted activation and personalization across marketing and product channels
- Help business users effectively explore data using AI tools - translate stakeholder questions into structured data models and AI-ready datasets, ensuring alignment with standardized metrics and business logic
Build and maintain AI-enabled self-service analytics workflows (e.g., NLQ in Hex using BigQuery/dbt models) that allow stakeholders to answer business questions without using SQL
- Develop and document curated datasets and semantic definitions that improve the accuracy and usability of AI-generated insights
- Iterate on data models and documentation based on stakeholder usage patterns and feedback from AI-assisted analysis
- Consult with Product Managers on digital product performance measurement
- Partner with engineering to ensure AI tools are properly connected to governed data sources (e.g., dbt models in BigQuery), improving trust and adoption
- Present new capabilities and analyses to senior leaders and less technical audiences inside The Inquirer, and serve as a trusted partner for stakeholder outreach
- Contribute to an inclusive and positive work environment
Who We are Looking For
- 5+ years of experience in product analytics, business intelligence, or a similar analytical role.
- Proficiency in SQL for querying and analyzing large datasets.
- Experience with Python or R for statistical analysis and data manipulation.
- Strong background in A/B testing methodologies and experimentation.
- Experience with event tracking and analytics tools (e.g., Google Analytics, Mixpanel, Amplitude, Adobe Analytics).
- Excellent communication and storytelling skills to consult with stakeholders and translate complex data into actionable insights.
- Ability to work cross-functionally and influence product roadmaps through data.
About Us.
The Philadelphia Inquirer is the media brand of record in Philadelphia and the region, and the largest news media organization in the state of Pennsylvania. A daily habit for almost 200 years, The Inquirer delivers Pulitzer Prize-winning news, sports, food, and lifestyle journalism multi-platform: Inquirer.com, Inquirer newspaper, e-editions, apps, newsletters, social, video, podcasts, and live events, generating 15M monthly impressions. Locally owned and headquartered in Philadelphia, no media brand is more deeply connected to the city or better understands what drives it. Our influence also extends across key drive markets, including Pennsylvania, New Jersey, Delaware, and New York, as well as to Philadelphia expats who live across the country and root for the Eagles, Phillies, Sixers, Flyers, and the Union.
The Inquirer is an equal opportunity employer for all regardless of race, ethnicity, religion, national origin, gender identity, sexual orientation, age, disability, veteran status, and any other category protected by federal, state and/or local law.