We’re looking for an Analytics Engineer with a history of supplying high quality analytical solutions for data science and other analytical stakeholder teams. You will contribute to the ongoing development of an analysis-first data ecosystem for the Direct Guaranteed R&D team. In collaboration with a team of data scientists, you will help empower data-driven decision-making across the product development process for our product management and engineering teams.

The Analytics Engineer will sit within our data science team and focus on defining and bringing our vision for our data environment to life. This involves discovering needs for data stakeholders, architecting solutions, and building infrastructure to transform raw data into high-value data assets that support those needs. Building these assets will be key in driving our mission to build word class monetization services for podcast creators.

As part of the Advertising R&D team, you’ll work on the latest advertising technologies to connect millions of brands to billions of fans. We’re paving the way for a sustainable global Spotify business that allows even more creators to make a living off their art. Come join us and help build the platform that powers promotion at Spotify.

What You'll Do

• Work as part of a cross-functional team of data scientists, analytics engineers, visualization engineers, and strategic researchers to build, maintain and support an ecosystem of analysis-friendly datasets, dashboards, and predictive model pipelines. 
• Work closely with Data Scientists to identify upcoming data needs and enhance existing datasets, models and 3rd party data injections or build new ones to fill those needs
• Collaborate with, and mentor, data scientists in building scalable analyses and datasets
• Develop tools and best practices to ensure high data quality and identify and prevent errors before they reach production datasets
• Contribute to comprehensive documentation of tools and datasets 
• Use your intimate knowledge of our datasets to lead and assist with investigations of user and advertiser behavior to make recommendations on new products and business strategies 
• Contribute to the development of the insights function and the wider analytics and data science community at Spotify

Who You Are

• At least 2+ years of experience in a similar role analyzing large scale data, using both SQL and Python, in a professional setting.
• You are a communicative person who values building strong relationships with colleagues and partners, enjoys mentoring and guiding others and you have the ability to explain complex topics in simple terms
• Consistent track record of supplying analytics solutions for existing teams, with ability to take open ended goals and scope them into defined and impactful objectives.
• Experience in conducting ETL / ELT 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 that is 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.

Spotify is committed to safety and well-being of our employees, vendors and clients. We are following regional guidelines mandating vaccination and testing requirements, including those requiring vaccinations and testing for in-person roles and event attendance. For the US, we have mandated that all employees and contractors be fully vaccinated in order to work in our offices and externally with any third-parties. For all other locations, we strongly encourage our employees to get vaccinated and also follow local COVID and safety protocols.