Analytics Engineer with SC Clearance - AWS/dbt Specialist

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

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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

SC Cleared Analytics Engineer - London - Inside IR35
SC Cleared Analytics Engineer - London - Inside IR35

Solirius Limited • Greater London

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

True North Consulting Group Ltd • City Of London

On-site
GBP 70,000 - 110,000
Remote Enterprise Data & AI Architect — SC Clearance Eligible
Remote Enterprise Data & AI Architect — SC Clearance Eligible

TechNET • Greater London

Hybrid
GBP 120,000 - 180,000
Senior AWS DB Architect – Aurora/RDS & PostgreSQL (SC)
Senior AWS DB Architect – Aurora/RDS & PostgreSQL (SC)

Investigo • Greater London

Hybrid
GBP 120,000 - 140,000
Data Engineer: AWS Data Lake for Public Sector
Data Engineer: AWS Data Lake for Public Sector

Blackstone& London • England

Hybrid
GBP 69,000 - 96,000
Data Analyst — Insight & Analytics Solutions
Data Analyst — Insight & Analytics Solutions

Solirius Reply • Greater London

Hybrid
GBP 42,000 - 60,000
Private Healthcare Insurance
25 Days Annual Leave + Bank Holidays
Up to 10 days allocated for develop*tr
+9
Data Engineer
Data Engineer

Blackstone& London • England

Hybrid
GBP 69,000 - 96,000
Analytics Engineer: Build Scalable Data Models & BI
Analytics Engineer: Build Scalable Data Models & BI

Harnham • Greater London

On-site
GBP 70,000 - 90,000
SC Clearance AWS Data Engineer — Cloud Data Pipelines
SC Clearance AWS Data Engineer — Cloud Data Pipelines

UBDS Group • Manchester

On-site
GBP 80,000 - 105,000
Hybrid Senior Security & Data Engineer (SC Clearance) — AWS, Splunk, Cribl
Hybrid Senior Security & Data Engineer (SC Clearance) — AWS, Splunk, Cribl

Searchability • City Of London

Hybrid
GBP 77,000 - 94,000
Hybrid working
2 days onsite per week
30 days annual leave
+5