At a Glance
- Tasks: Transform raw data into actionable insights and optimise data structures for our products.
- Company: Join Arbor, a mission-driven tech company revolutionising education.
- Benefits: Enjoy 32 days holiday, wellness support, and flexible working options.
- Other info: Collaborative culture with opportunities for professional development and community engagement.
- Why this job: Make a real impact in schools while working with cutting-edge data technologies.
- Qualifications: Expertise in data modelling, SQL, Python, and experience with Snowflake.
The predicted salary is between 75000 - 80000 £ per year.
Location: Remote
Salary: £75,000 - £80,000
About us
At Arbor, we’re on a mission to transform the way schools work for the better. We believe in a future of work in schools where being challenged doesn’t mean being burnt out and overworked. Where data guides progress without overwhelming staff. And where everyone working in a school is reminded why they got into education every day. Our MIS and school management tools are already making a difference in over 12,000 schools and trusts. Giving time and power back to staff, turning data into clear, actionable insights, and supporting happier working days. At the heart of our brand is a recognition that the challenges schools face today aren’t just about efficiency, outputs and productivity - but about creating happier working lives for the people who drive education every day: the staff. We want to make schools more joyful places to work, as well as learn.
About the role
The Data function at Arbor powers the delivery of analytics and analytics-enablement to our customers, including schools, local authorities and multi-academy trusts. We are looking for a collaborative and experienced Senior Analytics Engineer to join our Data team and help us turn raw data into high-quality, actionable insights that power both our external customer products and our internal decision-making. The remit and focus of the role is to work at the intersection of data engineering and business logic, ensuring our Medallion-based Snowflake warehouse is robust, scalable, and optimised for our next phase of growth. It’s a broad and exciting role, so we’re looking for someone up for a challenge - if you’re highly technical and a proactive problem-solver, this is the role for you.
Core responsibilities
- Data Modelling & Transformation: Lead the development and maintenance of our dbt-enabled data models, transforming raw data into Silver and Gold layers within our Snowflake Medallion architecture.
- Product Delivery: Build and optimise the data structures that power our customer-facing BI products, ensuring high performance and accuracy for our external users.
- AI Integration: Architect and deliver high-quality data sets specifically designed to be consumed by both core applications, AI features and LLM-driven functionalities within the Arbor suite.
- AI-First Workflow: Embrace and pioneer the use of AI-assisted engineering tools to accelerate planning, architecting, and coding tasks, setting the standard for efficiency within the team.
- Collaboration: Work closely with Warehouse Data Engineers to ensure upstream data quality.
- Domain Exploration: Partner with Product Managers and domain experts to translate business requirements into technical schemas, bridging the product teams into the data function.
- Data Integrity: Support the wider data team in maintaining rigorous data quality and observability standards, utilising Datadog and dbt tests to ensure one version of the truth.
- Mentorship & Best Practice: Act as a Senior pillar for the analytics engineering community, performing code reviews and championing best practices.
About you
- Data Warehouse & dbt Expert: Extensive experience building complex, performant data models within a modern warehouse (Snowflake, Databricks etc.) ideally using dbt. You should have a deep understanding of Jinja, macros, and dbt project structure.
- SQL & Python: Mastery of SQL for analytics use cases is a must. You should also be comfortable using basic Python for data manipulation tasks that sit outside the standard SQL transformation layer.
- Medallion Architecture: Proven experience working structured warehouse/lakehouse architectures, ideally within a Bronze/Silver/Gold framework.
- Product Thinking: Experience building data products for external and internal customers, with an understanding of how to balance performance with deep analytical utility.
- AI-First Mindset: A proactive interest in how AI is changing data engineering. You should be able to demonstrate how you use AI tools (like Cursor, CoCo or LLMs) to improve your output and how you prepare data for AI consumption.
- Stakeholder Management: Ability to bridge the gap between technical data engineering and the needs of Product Managers and internal domain experts.
- Ownership Culture: Demonstrable experience working in an environment where quality, performance, and observability are core responsibilities of the engineer.
Bonus Skills
- Power BI: Familiarity with Power BI (or Looker, etc.) for front-end visualisation and an understanding of how to optimise the data layer for BI consumption.
- DataOps: Experience with CI/CD pipelines for data (e.g., GitHub Actions) and automated testing frameworks.
What we offer
The chance to work alongside a team of hard-working, passionate people in a role where you’ll see the impact of your work every day. We also offer:
- A dedicated wellbeing team who champion initiatives such as mindfulness, lunch n learns, manager training, mental health first aid training and much more!
- 32 days holiday (plus Bank Holidays). This is made up of 25 days annual leave plus 7 extra company wide days given over Easter, Summer & Christmas.
- Life Assurance paid out at 3x annual salary.
- Comprehensive wellness benefit provided by AIG Smart Health, which provides a 24/7 virtual GP service, Mental health support, Counselling, and personalised Health Checks.
- Private Dental Insurance with Bupa.
- Salary sacrifice Pension provided by Scottish Widows.
- Enhanced maternity and adoption leave (20 weeks full pay) and paternity (6 weeks full pay) pay.
- 5 free return to work maternity coaching sessions, helping you adapt to this new exciting time of life!
- Access to services such as Calm and Bippit (financial wellbeing coaching).
- All of our roles champion flexible working and we are happy to discuss what this means to you.
- Social committees that plan team, office and company wide events to bring people together and celebrate success.
- Dedicated professional development training budget (CPD courses, upskilling resources, professional memberships etc).
- Volunteer with a charity of your choice for a day each year.
- Dog friendly offices!
Arbor Education is an equal opportunities organisation. Our goal is for Arbor to be a workplace which represents, celebrates and supports people from all backgrounds, and which gives them the tools they need to thrive - whatever the ambitions may be so we support and promote diversity and equality, and actively encourage applications from people of all backgrounds.
Please note: We are unable to provide visa sponsorship at this time.
Senior Analytics Engineer employer: Arbor Education
Contact Detail:
Arbor Education Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Senior Analytics Engineer
✨Tip Number 1
Network like a pro! Reach out to people in your industry on LinkedIn or at events. A friendly chat can lead to opportunities that aren’t even advertised yet.
✨Tip Number 2
Prepare for interviews by researching the company and its culture. Show them you’re not just another candidate, but someone who genuinely cares about their mission and values.
✨Tip Number 3
Practice your technical skills and be ready to showcase them. Whether it’s SQL or Python, being able to demonstrate your expertise can set you apart from the competition.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, we love seeing candidates who are proactive!
We think you need these skills to ace Senior Analytics Engineer
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the Senior Analytics Engineer role. Highlight your experience with data modelling, SQL, and any relevant projects that showcase your skills in a Medallion architecture. We want to see how you can bring value to our team!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're passionate about transforming education through data. Share specific examples of how you've tackled challenges in previous roles and how you align with our mission at Arbor.
Showcase Your Technical Skills: Don’t hold back on showcasing your technical prowess! Mention your experience with dbt, Snowflake, and any AI tools you've used. We’re looking for someone who can hit the ground running, so let us know how you’ve applied these skills in real-world scenarios.
Apply Through Our Website: We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it shows you’re keen on joining our team at Arbor!
How to prepare for a job interview at Arbor Education
✨Know Your Data Inside Out
Before the interview, dive deep into your experience with data modelling and transformation. Be ready to discuss specific projects where you've built complex data models using dbt and Snowflake. Highlight how you’ve turned raw data into actionable insights, as this aligns perfectly with what Arbor is looking for.
✨Showcase Your AI Savvy
Arbor values an AI-first mindset, so come prepared to talk about how you've integrated AI tools into your workflow. Share examples of how you've used AI to enhance data engineering tasks or improve efficiency. This will demonstrate your proactive approach and fit with their innovative culture.
✨Bridge the Gap
Since collaboration is key in this role, think about how you've worked with product managers and domain experts in the past. Be ready to explain how you translated business requirements into technical solutions, showcasing your ability to communicate effectively across teams.
✨Emphasise Quality and Observability
Discuss your commitment to data integrity and quality. Prepare to talk about the tools and practices you use to maintain rigorous data standards, like Datadog and dbt tests. This will show that you understand the importance of delivering reliable data products, which is crucial for Arbor's mission.