Analytics Engineer

Why Deliveroo? We're constructing the ultimate online food company, revolutionizing the way the world dines by making localized food offerings more accessible and convenient. We obsess over shaping the future of food while employing our network as a force for good. We're at the cutting edge of an industry, propelled by our state-of-the-art technology and unparalleled network, delivering exceptional convenience and variety to our customers. Working at Deliveroo offers the perfect setting to carve out an impressive career, driven by collective impact. First and foremost, the impact your work here will have on your personal growth, enabling you to develop faster than you might elsewhere; secondly, the impact you can make on Deliveroo, leaving your stamp as we expand; and lastly, being part of a larger cause, through the impact we make collectively in our marketplace and communities. The Role As part of our analytics engineering team and reporting to an Analytics Engineering Manager, your role involves creating data sets that are clean, tested, well-documented, and well-modeled. This will empower data scientists and business users alike, utilizing tools like Snowflake and/or Looker. You'll collaborate with product engineering teams to ensure the modeling of source data meets downstream requirements. You will maintain and develop SQL data transformation scripts, guiding and reviewing data scientists on data modeling to yield denormalised and aggregated output datasets. You'll cooperate with data scientists and other analytics engineers to provide accessible, intuitive datasets in our BI tool, Looker. Your responsibilities include optimization and further adoption of Looker as a data product in the company, serving to ~1500 current active users who need to explore and interact with data. Skillset Required - Exceptional SQL skills - Understanding of data warehousing, data modeling concepts and structuring new data tables - Proficiency in cloud-based MPP data warehousing (e.g. Snowflake, BigQuery, Redshift) Nice to have - Experience developing in a BI tool (Looker or similar) - Solid practical understanding of version control - SQL ETL/ELT knowledge, experience with DAGs for script dependency management - Python coding skills, especially in automation and integrations - Sound knowledge of the Looker API Workplace & Diversity At Deliveroo, we understand that our people are the heart of the operation and we prioritize their wellbeing. We offer numerous incredible benefits in the realms of health, family, finance, community, convenience, growth, and relocation. We believe an excellent workplace is representative of the world we inhabit and its wonderful diversity. Accordingly, we make no judgements based on your gender, race, sexuality, religion, or even your secret dislike for coriander. All you require is a passion for (most) food and a wish to be part of one of the fastest growing startups around.