Analytics Engineer

Department: Central

Employment Type: Permanent - Full Time

Location: Shoreditch, London

Reporting To: Shaan Dalwadi

Compensation: £70,000 - £90,000 / year

• Take ownership of and expand our transformation layer using DBT, ensuring new models align with the established architectural patterns.
• Design and extend dimensional models using frameworks like Kimball or BEAM, ensuring the schema accurately reflects the nuance of our business operations.
• Work with BigQuery.
• Establish data quality monitoring and testing frameworks.
• Act as a bridge between business and data: deeply analyse business workflows to gather requirements and translate them into reliable facts and dimensions.
• Document data definitions and business logic, ensuring the "why" behind the modelling decisions is clear.
• Maintain the long-term health and optimisation of the transformation layer.

• 4+ years experience in analytics engineering or a similar role.
• Startup/scale-up mindset - adaptable, hands-on, and comfortable wearing many hats.
• Strong Data Modelling expertise: experience designing schemas using methodologies like Star Schema, Kimball, or BEAM.
• Commercial Savvy: ability to visualise data structures needed to represent business processes.
• DBT experience essential.
• Git version control proficiency.
• Experience with BigQuery or similar data warehouses (Snowflake, Databricks, PostgreSQL, Redshift).
• Excellent communication skills: ability to discuss logical models with non-technical stakeholders.
• Passion for data quality and engineering best practices.

• Building ML models or running data science projects - our focus is on a rock-solid analytics foundation first.
• Working in isolation - you will be embedded in a small, tight team, working closely with the Business Analyst, Automation Engineer, Data Analyst, and Director of Data & AI, as well as department teams across the business.
• Building workflow automations (that's the Automation Engineer).

• Competitive salary - £70,000 - £90,000, based on experience and dedication.
• Flexible hybrid working model for work-life balance.
• Up to 35 days holiday - including a personal 'Me' day and Christmas closure.
• £100 annual learning fund, plus access to in-house development opportunities.
• Enhanced family leave for parents, carers, and more.
• 40% childcare discount, plus 6 emergency days annually.
• 5-year loyalty bonus - around-the-world trip + 2 bonus weeks off.
• 10-year loyalty bonus - 'Out of this world' experience + 2 extra weeks off.
• Referral bonus - earn up to £1,000 per successful hire.
• Amazing discounts - save on groceries, shopping, fitness and more.
• Travel support - season ticket loans and cycle-to-work scheme.
• Socials & wellbeing - annual parties, team events, gym discounts, and online fitness.