Lead Analytics Engineer

Role overview

Responsibilities

• Lead design, build and maintenance of analytical models for reporting, analytics, AI and business intelligence.
• Translate stakeholder and business-process requirements into effective data structures and models.
• Develop and maintain transformation standards across Azure Data Factory, Azure Synapse and related technologies.
• Ensure data quality, consistency, interoperability and reuse.
• Collaborate with data engineers, data scientists and analysts to align platform design with analytical needs.
• Improve data modelling, transformation and analytics engineering practices.
• Set documentation standards and support metadata management and data governance.
• Resolve data pipeline and model issues, applying preventative measures and optimisations.
• Provide technical leadership and guidance, promoting best practice and building team capability.

Experience and capabilities

• Experience designing and optimising complex data models in a cloud-based environment.
• Strong experience with Azure Data Factory, Azure Synapse Analytics or equivalent platforms.
• Experience with programming languages such as Python and SQL.
• Knowledge of data transformation, modelling and metadata management practices.
• Ability to balance technical design with business needs and stakeholder requirements.
• Strong communication skills, including explaining technical concepts as actionable insights.
• Government or regulated-environment experience and experience supporting analytics are sought.

Locations and working pattern

• The listed job locations are Cardiff, Glasgow and London.
• The working pattern is flexible and full-time.

Salary and benefits

• The advertised salary range is £49,452–£62,699, with separate national and London ranges.
• The role includes a Civil Service Pension with a stated employer contribution of 28.97%.