SC Cleared Analytics Engineer - London - Inside IR35

About Us:

Solirius Reply part of the Reply Group, is a technology consultancy and digital transformation partner that helps organisations solve complex challenges through strategy, design, engineering, and delivery.

We work closely with our clients to deliver secure, accessible, user-focused services that evolve with their needs. By combining deep technical expertise with people-centred design, we create solutions that deliver meaningful, lasting impact.

Our consultants partner directly with client teams, embedding into organisations to understand their goals, challenges, and users. This collaborative approach enables us to deliver tailored solutions that drive measurable outcomes across public and private sectors.

Past and present clients include the Ministry of Justice, Department for Education, Ministry of Housing, Communities and Local Government, UEFA, International Olympic Committee, and Mercedes-Benz. Our services span the full digital delivery life cycle, including architecture, engineering, delivery management, user-centred design, business analysis, data, DevOps, and AI.

We operate as a collaborative and inclusive organisation that empowers our people to take ownership, innovate, and develop their expertise. As an equal opportunities employer, we are committed to encouraging equality, diversity, and social mobility, while creating opportunities for our teams to work on meaningful projects that deliver lasting impact.

About You:

You are a motivated and adaptable professional with a strong analytical mindset and a passion for using technology to solve real-world problems. You enjoy working in collaborative, agile teams and take pride in delivering high-quality solutions that make a tangible impact. With strong communication skills and a consultative approach, you're comfortable engaging with clients, understanding their needs, and translating them into effective outcomes.

Role Overview:

We are looking for an experienced Analytics Engineer with active Security Clearance (SC) to join our high-performing data team delivering modern data solutions for public sector clients. In this role, you will bridge the gap between raw data ingestion and analytical consumption, transforming complex datasets into clean, reliable, and well-modeled data structures.

Working within an agile delivery environment, your primary focus will be designing and building robust transformation pipelines using advanced SQL and dbt, deploying workloads across modern AWS cloud environments. You will collaborate closely with data engineers, analysts, and business stakeholders to ensure data models adhere to high standards of testing, documentation, and performance, delivering trusted data ready for downstream reporting and decision-making.

One day per week in our London office, with the remainder completed remotely. Working arrangements may vary slightly based on client and project needs. Active Security Clearance (SC) is required prior to starting.

Key Responsibilities:

Skills and Experience Required

  • Advanced SQL & Data Modeling (Primary): Deep expertise in writing performant, modular SQL and designing dimensional models, relational schemas, and analytical data marts.

  • dbt (Data Build Tool): Proven track record developing, orchestrating, and testing data transformation pipelines using dbt, including experience with macros, custom schemas, snapshots, and documentation generation.

  • AWS Cloud Ecosystem: Solid experience operating within AWS cloud environments, working with cloud storage and services (such as S3, Athena, or Glue) supporting modern data lake and warehouse architectures.

  • Data Quality & Testing: Practical experience defining automated data tests, assertions, and validation rules to ensure data reliability, completeness, and consistency across environments.

  • CI/CD & Version Control: Proficiency with Git and modern CI/CD pipelines to manage versioned analytics code, code reviews, and automated deployment of dbt projects.

  • Active Security Clearance (SC): Active UK Security Clearance (SC) is mandatory to enable immediate onboarding and access to secure client systems.

Technical Experience and Tooling

  • Core Stack: Advanced SQL, dbt Core/dbt Cloud, and Git.

  • Cloud Platform: AWS services supporting data analytics (S3, Athena, Glue, Redshift).

  • Modern Data Stack Practices: Familiarity with data cataloging, lineage tracking, and automated documentation generation.

Specific Deliverables/Artifacts

  • Modular Transformation Models: Production-grade dbt models and SQL transformations turning raw source data into analytics-ready marts.

  • Automated Testing & Documentation: Fully documented dbt projects complete with automated data quality tests, schema documentation, and lineage graphs.

  • Deployment & Runbooks: Operational deployment scripts and maintenance runbooks facilitating clean handovers and ongoing pipeline monitoring.

Job Details

Company
Solirius Limited
Location
London, United Kingdom
Employment Type
Contract
Salary
GBP Annual
Posted