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 at Spotify, for the Advertising R&D organization. In collaboration with a team of Data Scientists and User Researchers you will help inform and guide decision making and strategy for partners across the company.

The Analytics Engineer will collaborate with Data Scientists, Data Engineers, and other Analytics Engineers to help us with crafting an efficient analytics data suite, removing bottlenecks for sophisticated analytics, and empowering all end data users to efficiently answer their own questions. This involves redefining, testing, deploying, maintaining, and documenting data all while ensuring reproducibility and consistency of analytical results at all stages of the pipelines.

What You'll Do

• Work as part of a cross-functional team of analytics engineers, visualization engineers, and strategic researchers to build, maintain and support an ecosystem of analysis-friendly datasets and dashboards
• Work closely with Data Scientists to identify upcoming data needs and enhance existing datasets or build new ones to fill those needs
• Collaborate with, and mentor, data scientists in building scalable analyses and datasets
• Develop tools and standard methodologies 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 behavior to make recommendations on new products
• Contribute to the development of the Product Insights function and the wider analytics and data science community at Spotify

Who You Are

• At least 3+ 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.