Senior Data Insights Analyst, Mobile App
New
N
NPRDigital news media
Remotely from a location of your choosing within the United States that is supported by NPRFull-TimeSenior
Salary105,435.13 - 116,380.66 USD per year
Apply NowOpens the employer's application page
Job Details
- Experience
- 5+ years of advanced SQL experience; 5+ years of Mobile & Web Analytics; 2+ years of Experimentation Design.
- Required Skills
- SQLTableauMicrosoft ExcelA/B testingBigQueryLooker
Requirements
- Bring 5+ years of advanced SQL experience, including writing complex queries from scratch against raw, unaggregated event logs.
- Have experience with data warehousing environments such as BigQuery or Dataform.
- Demonstrate ability to manipulate complex data structures, unnest arrays, parse JSON or struct fields, and build audience cohorts.
- Bring 5+ years of mobile and web analytics experience with app and digital behavioral datasets.
- Have hands-on experience with Google Firebase and GA4 or comparable analytics datasets.
- Bring 2+ years of experience designing, executing, and evaluating A/B and multivariate tests using platforms such as Optimizely.
- Understand experimental design, statistical significance testing, hypothesis formulation, and post-test behavioral analysis.
- Present SQL findings through data visualization and reporting tools such as Looker or Tableau and advanced Excel or Google Sheets models.
- Have experience training partners, establishing self-service frameworks, and mentoring peers on SQL and data hygiene.
- Preferred: experience in digital news media, public broadcasting, or media streaming.
- Preferred: statistical modeling experience using R or Python.
Responsibilities
- Write, optimize, and quality-check complex SQL queries in BigQuery to analyze raw event logs across app and web platforms.
- Transform raw data, access nested arrays, and perform cohort, behavioral, pattern, and retention analyses.
- Lead the experimentation lifecycle, including hypothesis development, A/B test design, execution, and interpretation.
- Translate experiment results and mobile app analytics into product recommendations for product managers, newsroom leaders, and station stakeholders.
- Build and maintain scheduled queries, data summaries, automated pipelines, and self-service insight tools.
- Partner with Data Products to diagnose tracking anomalies and improve tool design.
- Train colleagues and cross-functional partners in SQL, query optimization, data tools, and data hygiene.
- Create guidelines, data dictionaries, and technical documentation for app, video, and web metrics.
View Full Description & ApplyYou'll be redirected to the employer's site
