Senior Data Insights Analyst, Mobile App

New
J
JobgetherDigital media
Must be able to work remotely from an approved location within the United States, work on-site at an approved facility, or follow a hybrid arrangement.Full-TimeSenior
Salary105,435.13 - 116,380.66 USD per year
Apply NowOpens the employer's application page

Job Details

Experience
At least 5 years of advanced SQL experience; at least 5 years of hands-on mobile and web analytics experience; at least 2 years of experimentation experience.
Required Skills
SQLTableauMicrosoft ExcelA/B testingBigQueryLooker

Requirements

  • Have at least 5 years of advanced SQL experience, including writing complex queries from scratch and analyzing raw, unaggregated event data.
  • Have experience with data warehousing tools such as BigQuery and Dataform.
  • Be able to extract, transform, and manipulate complex data structures, including unnesting arrays and parsing JSON and structured fields.
  • Have at least 5 years of hands-on mobile and web analytics experience with digital behavioral datasets and tools such as Google Firebase and Google Analytics 4 (GA4).
  • Have at least 2 years of experimentation experience, including designing, executing, and evaluating A/B or multivariate tests using Optimizely or a comparable enterprise platform.
  • Have advanced data visualization and reporting skills, including experience with Looker, Tableau, Excel, and Google Sheets.
  • Be able to communicate analytical findings to technical and non-technical audiences and provide actionable recommendations.
  • Have experience mentoring colleagues, training stakeholders, and establishing self-service analytical frameworks.
  • Have experience promoting SQL quality, documentation, and data hygiene standards.
  • Demonstrate analytical judgment, statistical reasoning, project ownership, and prioritization skills.
  • Preferred: experience in digital news, public broadcasting, or media streaming.
  • Preferred: proficiency in statistical modeling with Python or R.

Responsibilities

  • Write, optimize, and quality-check complex SQL queries in BigQuery using raw event logs, nested arrays, JSON structures, and unaggregated datasets.
  • Conduct cohort, behavioral, and retention analyses across mobile and web platforms.
  • Own the experimentation lifecycle, from hypothesis development and A/B or multivariate test design through evaluation and product recommendations.
  • Deliver recurring performance reporting and in-depth mobile analytics to product managers, newsroom leaders, and station stakeholders.
  • Share SQL expertise, conduct code reviews, train colleagues, and develop self-service insight tools.
  • Improve scheduled queries, data summaries, and automated pipelines; collaborate with data product teams to troubleshoot tracking anomalies and refine analytical tools.
  • Assess analytical requests by business impact, align deliverables with departmental strategy, and manage projects as priorities evolve.
  • Establish data dictionaries, technical documentation, and consistent measurement standards for mobile app, video, and web metrics.
View Full Description & ApplyYou'll be redirected to the employer's site
105,435.13 - 116,380.66 USD per year
Apply Now