Analytics Engineer

Team: Engineering & Data

Location: Depop - London

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.

Life is about creating. That's why we're home to over 30 million artists, stylists, designers, sneakerheads — and you? We're the community-powered, circular-minded marketplace changing the world of online fashion. Now it's time to get inspired at Depop.

Responsibilities

Job description

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.

How we work

MyMode is our new 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 (Default)

Tell me more +

Flex is our default working mode, meaning all employees will automatically enrol in this mode and there is no application required to enter this mode. Flex employees will be expected to work from the office at least 4 days per month. Teams will determine whether there are set weekly or monthly in-office days based on their operating rhythms and practices. You will need to work with your manager to determine your in-office schedule for your team.

Office Based

Tell me more +

This option is for employees who are committing to work from the office for a minimum of 4 days per week. As part of taking on the Office Based working mode you will be able to apply for a permanent desk in the office if you need one, but you won’t need to apply to become an Office Based employee.

Remote

Tell me more +

Under the Remote working mode you are able to work anywhere within the country you are employed in. This mode requires around 2- 4 days per year in the office, depending on organisational guidance. You will be able to expense travel if you are asked to attend the office, but not for office attendance by your choice.

*Remote working is not applicable for all roles at Depop, please check with our Talent Team.

How We Care

  • Your health
    Tell me more
    • Enhanced Maternity + Paternity Leave, plus adoption leave, IVF leave, shared parental leave + paid emergency parent/carer leave
    • Private Healthcare (UK and US) - choice of a healthcare plan that best suits you
    • Subsidised counselling through Selfspace
    • Employee Assistance Programme (EAP)
    • Mental Health First Aiders across the business
    • Life Insurance
    • Pension
  • Your balance
    Tell me more
    • 25 days annual leave plus bank holidays
    • 1 company-wide day off per quarter, for you to take some time for yourself and decompress
    • Impact hours to be used for volunteering, demonstrations or internal initiatives
    • Apply to work abroad 4 weeks of the year (in UK tax treaty countries)
    • 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.
  • Your growth
    Tell me more
    • Budgets for conferences, learning subscriptions and more
    • Learn new perspectives from other people in the company with our mentoring programme
    • Promoting inclusion and diverse viewpoints with DEI training
    • Upskilling our employees with year-long programming like manager training, workshops, conferences and meetups

Location

20 Farringdon Rd

EC1M 3HE

Go to map

Application Process

  • Stage 1: Talent Partner Call

    This initial stage is a general conversation about your background, skills and what you’re looking for in your next role. You’ll gain further insight into life at Depop and the opportunity at hand.

  • Stage 2: Hiring Manager Call

    The Hiring Manager is most likely the person you’d report into at Depop, so they’ll be delving deeper into your experience. This is another opportunity to learn more about the team’s mission and goals.

  • Stage 3: 1st Stage Interview

    This interview is centred around assessing your role-specific skills, usually in the form of a paired-programming sesion, whiteboard session or presentation (depending on the role). You’ll meet with peers at Depop who can guide you through your day-to-day responsibilities in the role and answer any of your more technical questions.

  • Stage 4: Final Interview

    Our final interviews are usually made up of an executive interview with a senior stakeholder. In this session, we'll dive even deeper into your working styles and the type of culture you thrive in, as well as provide you with more information around our mission as a company and how your role would contribute to this.

    *Please note that the order of this process may be subject to change, based upon certain requirements or circumstances. If this is the case, you will be notified at the beginning of your process.

Our DNA encompasses the central reasons that people are proud to work at Depop and unites us with a shared language and sense of community.

It guides our daily interactions and empowers individuals, teams, departments and our company as a whole to have a greater impact and achieve our mission.

Show up for the community

Tell me more +

We go above and beyond. When they succeed, we succeed.

We’re changing how millions of people buy, sell and explore their style, so we do everything we can to create a safe space in a community where you can learn, grow and succeed on your own terms.

Have each other's backs

Tell me more +

We empower each other with kindness and respect our differences.

Everyone at Depop is seen, heard, valued and encouraged. Our genius is born from our diversity of thought, so we celebrate our wins together and hold each other up when things get tough.

Act with purpose

Tell me more +

We take conscious risks, deliver efficiently and learn from our mistakes.

Our mission is to be the world’s most diverse and progressive home of fashion. We have the conviction to succeed, the patience to learn and the confidence to fail and try again - being open all the way.

Think thrift

Tell me more +

We’re resourceful, seek out opportunities and we hustle.

We’re powering a future that is more thoughtful, circular and better for people and planet. To do it, we stay curious, savvy, resourceful and empowered to get the job done – effectively and responsibly.

At the heart of our mission...

Winking gif

INCLUSION

Fashion is global. It’s for everyone. So, we’re building a diverse ecosystem at Depop where everyone is seen, heard, valued and empowered to succeed. We’re working towards a future where DEI is at the heart of everything that we do. When you succeed, we succeed.

COMMUNITY

We know culture is felt, rather than told. But at Depop, you'll find a place where everyone can bring their own style to everything they do. We keep it circular as we recognise our impact on our community of sellers, our users, on the planet and on the future of fashion.

SUSTAINABILITY

Together, we’re shaping a new circular fashion system. One that’s kinder to people and to the planet. It’s simple. But it’s massive, too. It helps the environment, builds new connections and creates new ways to experience clothing.

At the heart of our mission...

Winking gif

INCLUSION

Fashion is global. It’s for everyone. So, we’re building a diverse ecosystem at Depop where everyone is seen, heard, valued and empowered to succeed. We’re working towards a future where DEI is at the heart of everything that we do. When you succeed, we succeed.

COMMUNITY

We know culture is felt, rather than told. But at Depop, you'll find a place where everyone can bring their own style to everything they do. We keep it circular as we recognise our impact on our community of sellers, our users, on the planet and on the future of fashion.

SUSTAINABILITY

Together, we’re shaping a new circular fashion system. One that’s kinder to people and to the planet. It’s simple. But it’s massive, too. It helps the environment, builds new connections and creates new ways to experience clothing.