What You'll Do:

• You will be a primary contributor to the analytics data layer of our Data Science environment. This will involve building long term and robust solutions to surface critical data sourced from a huge and diverse collection of datasets.
• Work closely with our team of Data Scientists to craft data structures and pipelines, which will empower research and analytic questions.
• Engineer novel datasets and features, and improve existing ones, with a focus on enabling the flexible analysis of the dynamics of content consumption on our platform.
• Work with the engineering team to implement new ETL pipelines, and data infrastructure improvements, as needed.
• Build and guide reporting know-how to ensure data and key metric standardization across the larger business unit.

Who You Are:

• 5+ years of full-time, professional work experience analyzing data using both SQL and Python.
• Proven track record of supplying analytics solutions for existing teams, with ability to take open ended goals and scope them into defined and impactful objectives.
• Significant experience in conducting ETL with very large and complicated datasets and handling DAG data dependencies.
• Strong proficiency with SQL dialects on distributed or data lake style systems (Presto, BigQuery, Spark/Hive SQL, etc), including SQL based experience in nested data structure manipulation, windowing functions, query optimization, data partitioning techniques, etc. Knowledge of Google BigQuery optimization is a plus.
• Additional skills as a plus: Experience with Data Build Tool (DBT) or general knowledge of Jinja templating in Python. Hands-on experience with cloud provider integration and automation via CLIs and APIs.

Where You'll Be:

• We are a distributed workforce enabling our band members to find a work mode best for them!
• Where in the world? For this role, it can be within the Americas region in which we have a work location
• Prefer an office to work from home instead? Not a problem! We have plenty of options for your working preferences. Find more information about our Work From Anywhere options here.
• Working hours? We operate within the Eastern Standard time zone for collaboration


#remote 

Spotify is an equal opportunity employer. You are welcome at Spotify for who you are, no matter where you come from, what you look like, or what’s playing in your headphones. Our platform is for everyone, and so is our workplace. The more voices we have represented and amplified in our business, the more we will all thrive, contribute, and be forward-thinking! So bring us your personal experience, your perspectives, and your background. It’s in our differences that we will find the power to keep revolutionizing the way the world listens.

Spotify transformed music listening forever when we launched in 2008. Our mission is to unlock the potential of human creativity by giving a million creative artists the opportunity to live off their art and billions of fans the chance to enjoy and be passionate about these creators. Everything we do is driven by our love for music and podcasting. Today, we are the world’s most popular audio streaming subscription service with a community of more than 345 million users.