Lead Analytics Engineer; FTC

Job Description

We are undertaking a strategic migration of our reporting and analytics estate from SSRS to a modern cloud data platform (Snowflake). This role will support the design and delivery of that transformation—establishing best‑in‑class practices while remaining hands‑on in building models, pipelines, and reporting layers.

You will play a critical role in not just migrating existing assets, but improving how we model, govern, and deliver data across the organisation.

This is a high‑impact role at the centre of a major data transformation. The successful candidate will shape how data is modelled, accessed, and trusted across the organisation for years to come.

• Support the end‑to‑end migration of reporting assets from SSRS into Snowflake
• Assess and rationalise existing reports (remove duplication, improve logic, simplify where possible)
• Redesign reporting structures to align with modern data modelling principles

• Establish scalable standards for:
  • Data modelling (e.g. dimensional modelling, layered architecture)
  • Transformation workflows (ELT patterns)
  • Testing and validation
  • Documentation and governance
• Introduce modern development practices (e.g. version control, CI/CD where appropriate)

• Build and optimise data models, transformations, and reporting datasets
• Write high‑quality, performant SQL in Snowflake
• Develop reusable data assets for downstream reporting and analytics
• Troubleshoot and resolve data quality or performance issues

• Design a clean, scalable semantic layer for reporting
• Standardise key business metrics and definitions
• Support transition away from legacy report‑first design toward model‑first design

• Provide technical guidance and coaching to BI developers and analysts
• Raise engineering standards across the team
• Promote consistency and good practices without over‑engineering

• Work closely with business stakeholders to understand reporting needs
• Translate requirements into robust, scalable data solutions
• Challenge and refine requirements where needed to improve outcomes

• Strong SQL expertise (advanced level)
• Proven experience working with Snowflake (or similar cloud data warehouse)
• Experience migrating from legacy BI/reporting tools (e.g. SSRS, Cognos, Business Objects)
• Strong data modelling experience (dimensional modelling, star schemas, etc.)
• Experience building transformation layers in ELT environments
• Track record of delivering in hands‑on roles (not purely architectural)

• Experience with dbt or similar transformation frameworks
• Familiarity with modern data stack principles
• Experience implementing testing and data quality frameworks
• Exposure to CI/CD in data environments
• Experience rationalising large, complex reporting estates

• 26 days holiday, increasing with service + buy/sell scheme + bank holidays
• 7% Pension with matched contributions
• Discretionary bonus scheme
• Share schemes (including free shares and BAYE)
• Health Cash Plan and discounted private healthcare
• Free onsite gym
• Enhanced family leave (subject to qualifying criteria)
• Travel and bike loan schemes
• Employee Assistance Programme