About the company
Deliveroo’s mission is to transform the way you shop and eat, bringing the neighbourhood to your door by connecting consumers, restaurants, shops and riders. We obsess about building the future of food, whilst using our network as a force for good. We're at the forefront of an industry, powered by our market-leading technology and unrivalled network to bring incredible convenience and selection to our customers.
Responsibilities
- Working 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-modelled data sets, that will enable and empower data scientists and business users alike, via tools like Snowflake and/or Looker.
- You'll work with product engineering teams to ensure modelling of source data meets downstream requirements.
- You will maintain and develop SQL data transformation scripts, and advise and review data scientists on data modelling to achieve denormalised and aggregated output datasets.
- You'll work with data scientists and other analytics engineers to surface clean, intuitive datasets in our BI tool, Looker.
- You will be responsible for optimisation and further adoption of Looker as a data product in the business, catering to ~1500 current active users who need to discover and interact with data.
Requirements
- 6+ years Analytics Engineering / Data Engineering / BI Engineering experience
- Excellent SQL skills
- Understanding of data warehousing, data modelling 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)
- Good practical understanding of version control
- SQL ETL/ELT knowledge, experience with DAGs to manage script dependencies
- Python coding skills, particularly in the areas of automation & integrations
- Good knowledge of the Looker API