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.

Analytics Engineers at Depop help the business understand how its performing and what to do next. We work across all data domains to support our internal partners in building high-quality, analysis-ready datasets. As a member of the team, you’ll work with engineers, data scientists, analysts and product managers who are passionate about building high quality products.

You will help bridge the gap between Engineering and the business to build sources of truth for our business definitions and core datasets. You will use tooling such as Airflow, dbt, Looker and Databricks to develop these models. You will also help to set standards and guidelines so that we have improved productivity for our internal users.

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

• Design and build data models for Business Insights and Data Science.

• Work with data consumers to understand their needs and deliver solutions that meet their needs.

• Develop tooling and services to help develop our Looker instance.

• Support BI users and developers in developing self-serve models.

• Identify areas of improvement of our data practices to improve the developer experience.

• Seek feedback on existing data models and work with consumers to improve them

• Promote best practices in developing cost and time efficient models and self-serve analytics.

Requirements

• Proficiency in SQL using cloud data warehouses (e.g. Databricks, BigQuery, Athena) and comfortable building performant queries.

• Experience designing ELT pipelines using dbt or similar.

• Knowledge of data modelling and warehousing best practices.

• Experience with engineering best practices such as testing, standards, reviews and automation.

• Comfortable working in a fast paced environment and able to respond to change.

• Passion for learning new things and keeping on top of the latest developments in data engineering.

• Experience in working with version control (e.g. Git).

Bonus points if you have some of the following:

• Experience using Looker and LookML.

• Experience using Airflow or Databricks.

• Experience using shell scripting or working with APIs.

• Domain knowledge in either commercial reporting, product analytics, adtech or marketing analytics.

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 option to carry over up to 5 days

● 1 company-wide day off per quarter

● Impact hours: Up to 2 days additional paid leave per year for volunteering

● Fully paid 4 week sabbatical after completion of 5 years of consecutive service with Depop, to give you a chance to recharge or do something you love.

● Flexible Working: MyMode hybrid-working model with Flex, Office Based, and Remote options *role dependant

● All offices are dog-friendly

● Ability to work abroad for 4 weeks per year in UK tax treaty countries

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.