Lead Analytics Engineer

Company Description

Depop is the community-powered fashion marketplace to buy and sell circular fashion, with over 30 million registered users in more than 150 countries. Depop is a place for anyone to discover and celebrate their style on their own terms, and to feel good about their fashion choices by extending the lives of millions of garments.

The company was founded in 2011 and is headquartered in London with offices in Manchester and New York. Depop has approximately 400 employees dedicated to its mission of building the world’s most diverse progressive home of fashion, that’s kinder on the planet and kinder to people. In 2021, Depop became a wholly-owned subsidiary of Etsy – the global marketplace for unique and creative goods – and continues to operate as a standalone company.

Depop is an equal opportunity employer. Our mission is to build the world’s most diverse progressive home of fashion. To do this, we encourage people from underrepresented communities to apply. We celebrate diversity and are committed to creating an inclusive environment for all employees. We’re continuing to build recruitment processes that are fair and welcome requests for reasonable adjustments required throughout your interview experience with us. Depop supports visa sponsorship, sponsorship opportunities may be limited to certain roles and skillsets.

Job Description

Data is at the heart of what we do.

Depop is looking for a Analytics Engineering (AE) Lead to join our Insights team. The Insights team at Depop helps our product, marketing, strategy, finance, and operations teams make data-driven decisions, and our AEs are a critical part of enabling this by making data as accessible as possible to the analysts and the wider business. This role will drive our AE roadmap working closely with the wider data engineering ecosystem at Depop, and will also manage our team of AEs. You will help manage our growing information needs and support analysis of increasingly complex business problems by:

• Ensuring that our data is fit-for-purpose and usable by the business, including helping to design our data model and writing and testing dbt models and other ETLs to present data in an efficient and accessible format
• Building and promoting self-service tools and data best practices that will be used across the organisation, including taking ownership of our BI and reporting tools, in particular Looker.

You will work closely with business stakeholders from a wide variety of domains within Depop, as well as our Insights, MarTech and Data Engineering teams.

We’re building scalable and robust systems to harvest, process and analyse the vast data within our tech ecosystem. With an increasing demand to service other areas of the business, and ultimately our 25 million users, you’ll be at the forefront of pioneering Data-as-a-Service.

Want to find out more about Depop & our engineering team?

We write about technology, people and smart engineering right here –https://engineering.depop.com

Responsibilities

You will…

• Help to design a scalable data model that helps the business to efficiently obtain insights.
• Manage a team of Analytics Engineers and shape the team’s roadmap.
• Identify areas of possible inefficiency and work with cross-functional team members  to create working solutions for smoother delivery and clarity of requirements for backend engineering projects.
• Manage the health and stability of our BI analytics tools and work towards promoting best practices to allow for their scalable growth.
• Promote company-wide best practices around accessing data and using our BI and reporting tools by writing clear documentation, tutorials and hosting training sessions.
• Proactively identify and implement ways to improve data processes and warehousing for the Insights team.

Qualifications

Requirements

You have…

• Strong Proficiency in SQL including a solid understanding of how to optimise query performance.

• Experience designing production grade data ETLs using a tool such as dbt or similar.

• Experience designing sustainable and scalable Looker instances, with an understanding of efficient explore and view structures

• Working experience with Python in a Data Engineering or Data Science context

• Experience with cloud based data warehouse technologies, for example Databricks, Snowflake, Bigquery.

• Knowledge around data modelling best practices.

• Ability to apply advanced analytical capabilities and troubleshooting techniques to break down complex issues into deliverable action items.

• Collaborative and humble team player with an ability to work with cross-functional teams, including technical and non-technical stakeholders.

• Comfortable working in a fast-past environment and able to respond to change or uncertainty with a positive attitude and a willingness to learn.

• A strong sense of ownership and highly organised nature.

• A hunger to learn, natural curiosity and a keen eye for detail.

Bonus points if you have…

• Experience working on a marketplace, in a mobile first environment or on social products.

• Experience managing a team of Engineers or Analysts.

• Experience building A/B testing analysis tooling.

• Familiarity with workflow management tools such as Airflow.

Technologies and Tools

Must have:

• Cloud-based SQL warehouse experience (i.e. Databricks, Snowflake, Bigquery)

• Looker, LookML

• Python

• ETL development using a tool such as dbt or similar

Nice to have:

• Databricks

• Airflow

Additional Information

UK Benefits
Health + Mental Wellbeing

• Cash-plan or PMI – you have the choice of a healthcare plan that best suits you
• Subsidised counselling and coaching – we partner with Selfspace to provide you with the opportunity for a good conversation with a qualified person
• Cycle to Work scheme – choose between Evans or the Green Commute Initiative to help access a bike for your commute
• Employee Assistance Programme (EAP) – have access to a confidential support network of expert advice 24/7
• Mental Health First Aiders – we have trained individuals across the business to offer support and signposting

Work/Life Balance

• 25 days annual leave with the option to carry over up to 5 days
• 1 company-wide day off per quarter, for you to take some time for yourself and decompress
• 2 activism days per year for you to use for volunteering, demonstrations or internal initiatives

Flexible Working

We’re Flexa® accredited, meaning we offer genuinely flexible working.
MyMode is our hybrid-working model, designed to empower our employees to choose a working mode that works for them. MyMode is composed of 3 working modes: Flex, Office Based and Remote.

• Flex: we’d love you to head to your nearest Depop office once a week, but feel free to work from home the rest of the week.
• Office: Want to head into the office more? No problem, you can opt to be “Office-Based”, with your very own desk.
• Remote: depending on your role you can request to be a remote worker, and only head into the office 4 times per year.

All of our offices are also dog-friendly! Do your best work with your best friend.
You can also apply to work abroad for 4 weeks of the year (in UK tax treaty countries).

Family Life

Our parental leave policies aim to support and enable parents to play equal roles in nurturing their families, in a way that is flexible and truly gender-neutral. Our full-time regular employees are eligible for 18 weeks of paid parental leave for the birth or adoption of their child. We also offer IVF leave, shared parental leave and paid emergency parent/carer leave.

Learn and Grow

• We offer budgets for conferences, learning subscriptions and more. We also sponsor and run a myriad of programmes, conferences and meet-ups to upskill our employees and enhance their journey with us.

Your Future

• Life Insurance (financial compensation of 3x your salary)
• Pension (Depop will match your contribution up to 6% of your qualifying earnings)

And finally, as a valued Depop employee we waive all of our employees’ fees when they sell on Depop so you can ship your sold items anywhere in the UK for free.