Analytics Engineer - Business Strategy & Insights at Spotify

New York, New York, United States

Spotify Logo
Not SpecifiedCompensation
Junior (1 to 2 years), Mid-level (3 to 4 years)Experience Level
Full TimeJob Type
UnknownVisa
Technology, EntertainmentIndustries

Requirements

  • 2+ years of professional experience analyzing complex data with SQL and Python
  • Demonstrable track record of contributing to analytics solutions for Data Science teams; turning open-ended goals into scoped, actionable plans
  • Significant ETL/ELT experience with very large and complex datasets, including managing DAG dependencies (e.g., Airflow, Dagster, or similar)
  • Deep competency with SQL on distributed/data-lake systems (e.g., BigQuery, Presto, Spark/Hive SQL), including nested data handling, window functions, query tuning, and partitioning strategies
  • Collaborative, low-ego, and invested in helping peers level up; care about reliable pipelines, clear models, and measurable impact

Responsibilities

  • Be a primary contributor to the analytics data layer — designing, modeling, and maintaining datasets that surface critical signals from massive, heterogeneous sources
  • Work hand-in-hand with Data Scientists to design schemas, features, and pipelines that unlock exploratory research and repeatable analysis
  • Engineer novel datasets and features, and elevate existing ones, to enable flexible analysis of subscription and consumption dynamics across the platform
  • Implement and evolve ETL/ELT pipelines in dbt and BigQuery; collaborate with the engineering team on data infrastructure improvements as needed
  • Establish and champion reporting best practices and a standardized metrics layer for the Business Strategy & Insights Org. — driving consistency, documentation, and discoverability
  • Raise the bar on analytics engineering: code review, testing, data quality checks, performance optimization, observability, and CI/CD for analytics code
  • Support downstream users — debugging queries, optimizing models, and sharing context — while mentoring teammates and uplifting standards

Skills

SQL
Python
BigQuery
dbt
ETL
ELT
data modeling
pipelines
CI/CD
data quality

Spotify

Digital music streaming service with podcasts

About Spotify

Spotify provides a digital music streaming service that allows users to access millions of songs and podcasts from various artists and creators. Users can choose between a free plan, which includes advertisements, and a premium subscription that offers an ad-free experience along with features like offline listening and higher sound quality. This tiered model caters to different user preferences and budgets. Spotify generates revenue through subscription fees from premium users and advertising from the free tier. Unlike its competitors, Spotify stands out with its extensive music library, user-friendly interface, and personalized playlists. The company's goal is to connect listeners with a wide range of audio content while supporting artists and advertisers.

Stockholms kommun, SwedenHeadquarters
2006Year Founded
$2,004.2MTotal Funding
IPOCompany Stage
Consumer Software, EntertainmentIndustries
10,001+Employees

Benefits

Extensive learning opportunities, through our dedicated team, GreenHouse
Global parental leave, six months off - fully paid - for all new parents
Flexible public holidays, swap days off according to your values and beliefs
Flexible share incentives letting you choose how you share in our success
All The Feels, our employee assistance program and self-care hub
Spotify On Tour, join your colleagues on trips to industry festivals and events

Risks

Accidental display of adult content may harm Spotify's reputation.
Creating its own music to avoid royalties could lead to legal issues.
Layoffs may affect Spotify's operational efficiency and employee morale.

Differentiation

Spotify offers a vast library of music and podcasts globally.
The platform's user-friendly interface enhances user experience and engagement.
Spotify's personalized playlists cater to individual user preferences.

Upsides

Spotify's AI-powered Wrapped feature enhances user engagement and personalization.
Expansion into political podcasting taps into new audience segments.
Growing podcast popularity in Africa presents expansion opportunities for Spotify.

Land your dream remote job 3x faster with AI