Overview
The Senior Analytics Engineer will play a pivotal role in supporting a client by building a new Retail Reporting solution on Google Cloud Platform (GCP). This hands-on position involves leading the technical development across BigQuery, Dataform, and Looker while collaborating with a dynamic commercial team to process diverse retail datasets. The role requires prompt availability to start within two weeks and includes hybrid work arrangements with a few days on-site in Central London.
Responsibilities
- Integrate and configure multiple retail data sources into GCP.
- Build and maintain Dataform pipelines across raw, staging, and gold layers.
- Develop unified sales, inventory, and shipping models in BigQuery.
- Implement key retail logic: on-hand vs on-order, Weeks of Supply, and calendar alignment.
- Optimise data models for Looker consumption, ensuring data quality, reconciliation, and performance.
- Work with BI and Commercial teams to translate requirements into scalable, well-structured data models.
Requirements
- Strong SQL and data modelling background.
- Hands-on experience with BigQuery, Dataform, and Looker modelling.
- Experience with retail or supply-chain datasets (POS, inventory, logistics) preferred.
- Ability to work independently and deliver within tight timelines.