Data Analytics Engineer, Content Analytics

New York, NY

Spotify logo
Apply now Apply later

Posted 1 month ago

We’re looking for an Analytics Engineer with a proven history of contributing high quality analytical solutions for Data Science teams. You will contribute to the ongoing development of an analysis-first data ecosystem at Spotify, for the Content Business Unit. In collaboration with a team of Data Scientists you will help inform and guide decision making and strategy for stakeholders across the company. Above all, you will be at the nexus of Data Science and Business, at one of the most innovative companies in the world.
The Analytics Engineer will collaborate with Data Scientists, Data Engineers, and other Analytics Engineers to help us with crafting an efficient analytics datasuite, removing bottlenecks for complex analytics, and empowering all end data users to efficiently answer their own questions. This involves transforming, testing, deploying, maintaining, and documenting data all while ensuring reproducibility and consistency of analytical results at all stages of the pipelines.
A successful candidate will have a track record of applying a collaborative work ethic in successfully implementing analytics solutions for Data Science teams. They will be a natural communicator, who think in terms of solutions instead of tools, and can explain complex systems to technical and non-technical audiences with equal clarity.

What You'll Do

  • You will be a primary contributor to the analytics data layer of our team’s 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 Data Scientists to design 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.
  • Create and guide reporting best practices to ensure data and key metric standardization across the Content Business Unit.

Who You Are

  • At least 2+ years of relevant experience analyzing complex data, using both SQL and Python, in a professional setting.
  • Demonstrable track record of successfully contributing to analytics solutions for existing Data Science teams, with ability to take open ended goals and scope them into defined and actionable objectives.
  • Significant experience in conducting ETL with very large and complex datasets and managing DAG data dependencies.
  • Strong competency 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. Extensive knowledge of Google BigQuery best practices and 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.
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 brilliant. 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 opportunity to enjoy and be inspired by 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 299 million users.
Job tags: BigQuery Data Analytics Engineering ETL Python Research Spark SQL
Share this job: