[Hiring] Senior Data Insights Analyst @NPR

Role Description

You will be critical to building a new, leaner, audience-centric, data-driven app that serves NPR and partnering stations in multi-modal formats. As the Senior Insights Analyst, Mobile Analytics, you will drive data-informed decision-making for the NPR App, serving as the core owner of platform experimentation and advanced mobile product analytics.

Central to this role is high-level SQL mastery. You will extract actionable insights from complex, unaggregated datasets—frequently writing advanced queries (e.g., raw GA4 and Firebase exports in BigQuery) for deep cohort, behavioral, and retention analyses. Additionally, you will establish quality control standards for SQL execution across the team, train colleagues on query optimization, and design end-to-end A/B tests that expand weekly audiences, deepen listening habits, and maximize revenue yield.

This role reports to the Audience Insights Senior Manager, Product. This is a union-represented role covered under the terms of a collective bargaining agreement with NABET-CWA DMU.

Responsibilities

• Advanced SQL & Raw Data Engineering: Write, optimize, and QC complex SQL queries using BigQuery; transform raw event logs, access nested arrays, and perform advanced cohort, pattern, and behavioral analysis across app and web platforms.
• Experimentation Ownership: Lead the experimentation lifecycle on NPR’s owned and operated platforms using Optimizely (or comparable tools); partner across teams to formulate hypotheses, design rigorous A/B testing frameworks, run experiments, and translate results into product recommendations.
• Product Insights & Strategy: Deliver foundational trend reporting and deep-dive mobile app analytics to product managers, newsroom leaders, and station stakeholders to advocate for audience needs and guide strategy.
• Technical Mentorship & Enablement: Share advanced SQL and analytical expertise with teammates; build sustainable self-service insight tools and train cross-functional partners to utilize data effectively in daily decision-making.
• Data Infrastructure & QC: Streamline scheduled queries, data summaries, and automated pipelines; partner with Data Products to diagnose and resolve tracking anomalies and optimize tool design based on user needs.
• Workload & Stakeholder Prioritization: Manage incoming analytical requests by evaluating business impact, aligning deliverables directly with departmental strategy and media landscape trends.
• Culture & Best Practices: Proactively share research tools and insights to cultivate a transparent, data-driven learning culture across NPR and partner stations nationwide.
• Documentation & Standards: Establish guidelines, data dictionaries, and technical documentation for app, video, and web metrics to ensure organizational reporting consistency.

Qualifications

• 5+ years of advanced SQL experience: Demonstrated expertise writing complex SQL queries from scratch, querying raw, unaggregated event logs, and utilizing data warehousing environments (e.g., BigQuery, Dataform).
• Raw Data & Array Manipulation Expertise: Proven ability to fetch, transform, and manipulate complex data structures, taking raw data to create audience cohorts and behavioral pattern modeling.
• 5+ years of Mobile & Web Analytics: Hands-on experience with app and digital behavioral analytics datasets (e.g., Google Firebase, GA4) across mobile product environments.
• 2+ years of Experimentation Design: Demonstrated experience formulating, executing, and evaluating A/B and multivariate tests using enterprise platforms (e.g., Optimizely).
• Data Visualization & Reporting: Expert proficiency in converting complex SQL outputs into clear visual stories (Looker, Tableau) and advanced spreadsheet models (Excel/Google Sheets) for non-technical stakeholders.
• Stakeholder Enablement & Training: Proven track record of training partners on data tools, establishing self-service frameworks, and mentoring peers on SQL and data hygiene best practices.

Preferred Qualifications

• Experience within digital news media, public broadcasting, or media streaming platforms.
• Statistical modeling proficiency using scripting languages such as R or Python.
• Demonstrated success in building cross-functional partnerships to solve complex, multi-departmental analytical problems.

Required Skills/Competencies

• Advanced SQL & Raw Data Extraction: Exceptional ability to write efficient SQL to unnest arrays, parse JSON/struct fields, and build scalable datasets from raw event-level digital behavior.
• Experimental Methodology: Deep competency in A/B testing design, statistical significance testing, hypothesis formulation, and post-test behavioral analysis.
• Data Translation & Communication: Mastery in presenting quantitative findings to executive, technical, and non-technical audiences with clarity and actionable strategic connections.
• Technical Mentorship: Demonstrated dedication to elevating team-wide technical capabilities through SQL code reviews, documentation, and training.
• Prioritization & Autonomy: Strong ability to independently navigate shifting priorities, evaluate business impact, and lead complex projects from inception to completion.

Work Location & Requirements

This is a remote-permitted role. This role is based out of our Washington, D.C. office, but the employee may choose to work on a remote basis from a location that NPR approves. You will have the option of working (a) remotely from a location of your choosing within the United States that is supported by NPR; (b) on-site at an NPR facility, based on the availability of desks and approval from NPR; or (c) a combination of both. Regardless of where you choose to work from, you may be expected to travel to other locations from time to time to perform the duties of your position.

Compensation

The U.S.-based anticipated salary range for this opportunity is $105,435.13 to $116,380.66 plus benefits. The range displayed reflects the minimum and maximum salaries NPR expects to provide for new hires for the position across all US locations.

Benefits

• NPR provides comprehensive benefits for employees and dependents.
• Regular, full-time employees scheduled to work 30 hours or more per week are eligible to enroll in NPR’s benefits options.
• Benefits include access to health and wellness, paid time off, and financial well-being.
• Plan options include medical, dental, vision, life/ accidental death and dismemberment, long-term disability, short-term disability, and voluntary retirement savings to all eligible NPR employees.

Company Description

NPR is committed to being an inclusive workplace that welcomes diverse and unique perspectives, all working toward the same goal – to create a more informed public. Qualified applicants receive consideration for employment without regard to race, color, ethnicity, national origin, ancestry, age, religion, religious belief, sex (including pregnancy, childbirth and related medical conditions, lactation, and reproductive health decisions), sexual orientation, gender, gender identity or expression, transgender status, gender non-conforming status, intersex status, sexual stereotypes, nationality, citizenship status, personal appearance, marital status, family status, family responsibilities, military status, veteran status, mental and physical disability, medical condition, genetic information, genetic characteristics of yourself or a family member, political views and affiliation, unemployment status, protective order status, status as a victim of domestic violence, sexual assault, or stalking, or any other basis prohibited under applicable law.