SC Cleared Analytics Engineer - London - Inside IR35

Solirius Limited

Greater London

Hybrid

GBP 85,000 - 120,000

Full time

3 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Solirius Limited is seeking an experienced Analytics Engineer to join our data team in delivering modern data solutions for public sector clients. The role focuses on transforming complex datasets into reliable models using advanced SQL, dbt, and AWS services, within an agile environment.

You will design robust transformation pipelines, ensure data quality and documentation, and collaborate with engineers, analysts, and stakeholders to enable trusted analytics for decision-making.

Qualifications

  • Deep expertise in writing performant SQL and dimensional modeling.
  • Experience with dbt to build, orchestrate, and test data pipelines.
  • Solid AWS experience with S3, Athena, Glue for data lake/warehouse architectures.
  • Experience defining automated data tests, assertions, and validation rules.
  • Proficiency with Git and modern CI/CD pipelines for analytics code.
  • Active UK Security Clearance (SC) is mandatory to enable onboarding.

Responsibilities

  • Develop modular transformation models in production-grade dbt and SQL.
  • Implement automated data quality tests and maintain schema documentation and lineage graphs.
  • Create deployment scripts and runbooks to support ongoing pipeline monitoring and handovers.

Skills

Advanced SQL
Data modeling
dbt
AWS
Data quality testing
CI/CD
Security clearance (SC)

Tools

dbt Core
dbt Cloud
Git
AWS S3
AWS Athena
AWS Glue
AWS Redshift

Job description

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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Data Analytics Engineer ( SC Cleared/ SC Eligible )
Senior Data Analytics Engineer ( SC Cleared/ SC Eligible )

Scrumconnect • Greater London

Hybrid
GBP 70,000 - 95,000
Data Analyst – SC Cleared
Data Analyst – SC Cleared

Searchability • City Of London

Hybrid
GBP 54,000 - 66,000
Pension 6%
30 days leave
Data Analyst (SC Cleared)
Data Analyst (SC Cleared)

Scrumconnect Consulting • Newcastle upon Tyne

Hybrid
GBP 45,000 - 65,000
Analytics Engineer with SC Clearance - AWS/dbt Specialist
Analytics Engineer with SC Clearance - AWS/dbt Specialist

Solirius Limited • Greater London

Hybrid
GBP 85,000 - 120,000
Data Engineer
Data Engineer

Blackstone& London • England

Hybrid
GBP 69,000 - 96,000
Data Engineer I SC Cleared
Data Engineer I SC Cleared

Matchtech • North East

Hybrid
GBP 72,000 - 92,000
Data Engineer – SC Cleared
Data Engineer – SC Cleared

Searchability • City Of London

Hybrid
GBP 68,000 - 83,000
Pension (6%)
30 days leave
Analytical Engineer
Analytical Engineer

Harnham • Greater London

Hybrid
GBP 80,000 - 110,000
Data Engineer
Data Engineer

Scrumconnect Ltd • Newcastle upon Tyne

Hybrid
GBP 70,000 - 95,000
Data Analyst
Data Analyst

Made Tech Limited • Greater London

Remote
GBP 35,000 - 55,000
30 days of paid annual leave plus bank holidays
Remote working for all staff
Paid counselling and financial and legal advice