Senior Analytics Engineer - Build Scalable Data Models

Scrumconnect Limited; Greater London; On-site; GBP 75,000 - 120,000; Full time

Job summary

Scrumconnect Ltd. seeks a Senior Data Analytics Engineer to design, build and maintain robust data models for analytics and reporting within public sector programmes aligned to GDS standards.

The role is hands-on with stakeholder engagement, collaborating with Analytics Engineers, Data Engineers and Analysts. You will deliver conformed models, ensure data quality and support adoption of modern analytics tools in a regulated environment.

Qualifications

• SC cleared (first preference) or SC eligible.
• Strong experience as an Analytics Engineer or in a similar data-focused role.
• Proven experience designing and building dimensional data models for analytics and reporting.
• Hands-on experience with dbt and modern analytics engineering practices.
• Experience working with complex data sources and integrating multiple systems into conformed models.
• Strong understanding of data quality, metadata management and data profiling techniques.
• Able to communicate effectively with technical and non-technical stakeholders.
• Experience in government or public sector data environments aligned to GDS standards.
• Experience with orchestration tools such as Airflow.
• Familiarity with cloud-based data platforms and modern data stacks.
• Understanding of data governance and ethical data use in regulated environments.

Responsibilities

• Work with stakeholders and delivery teams across GDS-aligned programmes and complex public sector domains to understand business processes, data relationships and analytical needs.
• Interpret the needs of technical and non-technical stakeholders, and manage expectations through clear, proactive and reactive communication.
• Gather user requirements and turn them into clear, actionable, deliverable tasks.
• Act as a key point of contact for analytical user communities, supporting adoption and effective use of analytical data products.
• Design, build and maintain flexible, quality-assured dimensional data models for analytics and reporting.
• Build and review complex data models using tools such as dbt, keeping to agreed standards and best practice.
• Integrate and model data from complex source systems, combining multiple sources into conformed analytical models.
• Make sure data models work with other datasets to support reuse and scalability.
• Design and contribute to metadata repositories, and suggest improvements to existing metadata management.
• Use a range of tools for storing, managing and working with metadata.
• Make sure analytical data meets defined data quality standards.
• Apply data profiling techniques to assess completeness, accuracy and reliability.
• Review data models and documentation for consistency with standards and best practice.
• Work with Data Engineers to support end-to-end data services and deploy solutions in a reproducible, sustainable way.
• Collaborate with other data professionals to improve modelling, integration patterns and analytics engineering standards.
• Support analytical teams to use modelled data effectively through well-documented, well-governed data.
• Enable automation and adoption of modern analytics tools such as dbt and Airflow.
• Clear analytical data requirements, turned into deliverable tasks.
• High-quality dimensional data models built and maintained using dbt.
• Well-documented, quality-assured analytical datasets ready for reporting and advanced analytics.
• Better metadata capture, storage and presentation, enabling intelligent and responsible data use.
• Consistent application of data modelling standards, documentation and best practice.

Skills

dbt

Airflow

Dimensional modelling

Metadata management

Data quality

Stakeholder comms

Tools

dbt

Airflow

Job description

Scrumconnect Ltd. seeks a Senior Data Analytics Engineer to design, build and maintain robust data models for analytics and reporting within public sector programmes aligned to GDS standards.

The role is hands-on with stakeholder engagement, collaborating with Analytics Engineers, Data Engineers and Analysts. You will deliver conformed models, ensure data quality and support adoption of modern analytics tools in a regulated environment.