Depop is the fashion marketplace where the next generation buy, sell and get inspired. We are headquartered in London, UK with locations in Manchester, New York, Los Angeles and Australia. 🌍

We have almost 20 million registered users in 147 countries. In the UK, 1 in 3 Gen Z/Millennials are registered and in the US we have grown 300% over two years. As well as this, we are also the only European player to have recently entered the top 25 shopping apps by daily active users. 📈

We operate on three pillars:

Community: Our buyers, sellers and employees are inclusive, diverse and accessible. We are committed to empowering diversity within the fashion community. 💛

Entrepreneurship: We support our community and help them build their business with Depop. We thrive on supporting innovation by shaping an environment where creators, makers or hustlers can thrive. 🛍

Sustainability: Depop helps extend the life of garments and reduce waste, we care about the world and want to make a positive change within the fashion industry. ♻️

The Role

Data is at the heart of what we do.

Depop is looking for a Senior BI Engineer to join our growing cross-functional BI team. Our platform receives tens of thousands of requests every second; we’re looking to cut through the noise, leverage this vast data, and find value.

At Depop we treat data as one of our digital products, and the BI team serves as the gatekeeper between our data stack and our business stakeholders. The BI team is a cross-functional unit that includes a technical product manager, a team of engineers and several data analysts. 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 writing and testing ETLs and other aggregations 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.

Responsibilities:

• Responsible for the overall delivery of the entire BI/ETL pipeline, including ETL development and delivery, resource scheduling and QA.
• Design, build and maintain data sets and table structures, and the ETL processes required to populate them, in order to enable key business processes and the design and development of analytics visualisations.
• Build robust solutions to support 3rd party data integrations.
• Design and promote monitoring and alerting solutions to ensure the highest levels of data integrity.
• Proactively identify and implement ways to improve data processes and warehousing, navigating complex challenges as our data grows and becomes an integral piece of our business and product operations.
• 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 & transforming data and using our BI and reporting tools by writing clear documentation, tutorials and hosting training sessions.
• Work closely with BI Analysts and business stakeholders to gather requirements for data projects and efficiently translate into technical specifications for the engineering functions.
• Support and coordinate other large-scale BI projects within Depop.

Requirements:

Must-haves:

• Strong Proficiency in SQL including a solid understanding of how to optimise query performance.
• Advanced knowledge in a high-level programming language commonly used in ETL pipelines, such as Python or Scala.
• Experience creating resilient ETL pipelines with workflow management tools such as Airflow or Luigi.
• Working knowledge around data modeling best practices.
• In-depth knowledge of AWS data solutions such as Redshift, S3, and Athena.
• Familiarity with best-in-class BI and reporting tools like Looker, Chartio or Tableau.
• Ability to display complex quantitative data in a simple, intuitive format and to present findings in a clear and concise manner.
• 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-paced 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.
• BA/BS in a technical field such as Computer Science, Engineering, or Statistics, preferred.

Bonus points for:

• Proven experience building data pipelines with Airflow.
• Previous experience in Looker implementation and familiarity with LookML.
• Experience working on a marketplace, in a mobile first environment or on social products.

Benefits

Depop offers the opportunity to work in one of the UK's fastest-growing scale-ups, with a vibrant and diverse group of people, building a product we all deeply care about, in addition to:

Learn and Grow: We sponsor and run a myriad of programs, conferences and meet-ups to up-skill our employees and enhance their journey with us, just ask! 📚

Wellbeing: We care about wellbeing. We offer a cycle to work scheme, healthy fruit and snacks in the office, breakfast every Tuesday, eye-care vouchers and a discounted gym membership. 🤸‍♀️

Mental Health: Mental health is a top priority for Depop. We offer subsidised counselling appointments through SelfSpace, have mental health first aiders and also run yoga, meditation and more. 💛

Work/life balance: We have 25 days of holiday with the opportunity to buy or sell 5 more, a day off for activism, and sabbaticals for our long-serving employees. 🏖

Family life: We offer flexible working (based on your team), generous parental leave policies, and, all of our offices are dog-friendly! 🐶

Financial: We match up to 6 percent on your pension based on qualified earnings and have retail discounts from benefithub. 💸

Fun: We love to celebrate our successes at Depop. On Friday we finish an hour early to socialise with free food, and have amazing Winter and Summer Parties. We also host internal employee socials such as quiz night, games night, movie night and more. 🍹

Depop is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.