Senior Analytics Engineer

Role Overview

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

Requirements

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

Tech Stack

• Python
• SQL

Benefits

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