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
Strong Data Modelling expertise: You have experience designing schemas using methodologies like Star Schema, Kimball, or BEAM (Business Event Analysis & Modelling) and can confidently extend existing models.
Commercial Savvy: You can look at a business process (e.g., nursery occupancy or team scheduling) and intuitively visualise the data structures needed to represent it.
dbt experience essential.
Git version control proficiency.
BigQuery or similar data warehouse experience (Snowflake, Databricks, PostgreSQL, Redshift).
Excellent communication skills: Ability to discuss logical models with non-technical stakeholders.
Passion for data quality and engineering best practices.

Analytics Engineer

Key skills