Analytics Engineer - Data Engineer

Why Deliveroo? We're constructing the ultimate online food company, changing the way the world eats by making local food more accessible and convenient. We are passionately crafting the future of food, using our network as a force for good. We're spearheading an industry, relying on our top-tier technology and unmatched network to bring immense convenience and variety to our customers. Working at Deliveroo offers the ideal environment to shape a definitive career, inspired by impact. Firstly, the impact that working here will have on your growth, allowing you to develop faster than you might elsewhere; secondly, the influence you can have on Deliveroo, leaving your imprint as we scale; and finally, being part of something larger, through the impact we collectively make in our marketplace and communities. The Role As part of our analytics engineering team and reporting to one of our Analytics Engineering Managers, your role will be to provide clean, tested, well-documented, and well-modeled data sets, enabling and empowering data scientists and business users alike through tools like Snowflake and/or Looker. You'll collaborate with product engineering teams to ensure source data modeling meets downstream requirements. You will maintain and develop SQL data transformation scripts, and guide and review data scientists on data modeling to achieve denormalized and aggregated output datasets. You'll work with data scientists and other analytics engineers to present clean, intuitive datasets in our BI tool, Looker. You will be accountable for optimization and further adoption of Looker as a data product in the business, serving approximately 1500 current active users who require discovery and data interaction. Skillset Required - Exceptional SQL skills - Understanding of data warehousing, data modeling concepts and structuring new data tables - Knowledge of 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 to manage script dependencies - Python coding skills, especially in automation & integrations - Good knowledge of the Looker API Workplace & Diversity At Deliveroo, we understand that people are the backbone of the business and their wellbeing is our priority. We offer various benefits in areas like health, family, finance, community, convenience, growth, and relocation. We believe an excellent workplace is one that reflects the world we live in and its beautiful diversity. We have no judgement regarding any of the things that make you unique - be it your gender, race, sexuality, religion or a secret dislike for coriander. All you need is a passion for (most) food and the desire to be part of one of the fastest-growing start-ups around.