BI Engineer

About us

N Family Club is one of the UK’s fastest-growing, children’s nursery Groups.

Based in London, we launched N in 2017 and in eight years, we’ve opened 50 sites, won a national Nursery World award & secured multi-million pound investment from a high profile investor to power our expansion.

If you’re excited about helping us build it - we’d love to hear from you.

Take a look for yourself: www.nfamilyclub.com

About the role:

Join N Family Club and lead the evolution of the data foundations for the UK's highest quality nursery group. You will take ownership of our emerging transformation layer (currently being established with external support), ensuring its architectural integrity as you scale it out to new domains. You will establish professional data engineering practices and enable data-driven decisions across 50+ nurseries.

To be successful in this role, you will; Go Beyond, Be Outstandingly Outstanding and Play as a Team.

What You'll Do

• 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.

Please note, the working hours for this role are 10am to 6pm, Monday to Friday

What You'll Bring

• 4-6+ 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.

 Benefits

• 25 days annual leave
• Monthly team meet ups at Belgrade co-working space & team Summer Party
• Annual all expenses paid trip to London and company Winter Party
• Round the World ticket after 5 years of service