Analytics Engineer
Archer is matching candidates to this role at Solirius Reply. Create a free profile and Archer will check you against this role and every other live role, showing you exactly where you match.
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.
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.
Working Arrangements
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.
Apply knowing you're qualified
One free profile is all it takes. Archer checks you against this role and every other live role we list, and shows you exactly which requirements you meet before you apply.
More roles like this
See all Data Engineer jobs- Posted 14 days agoData ScientistInsights AnalystDigital Analyst +5
- Posted 30+ days ago
AI & Data Architect
Accenture
Machine Learning EngineerArtificial Intelligence EngineerData Engineer +6 - Posted 14 days ago
AI & Data Architect
Accenture
Machine Learning EngineerData EngineerData Architect +5
Not quite the right role?
Archer scans thousands of live roles and surfaces the ones you genuinely match, each with a clear explanation of why. It keeps working after you apply, so you hear about roles you would never have found by searching.
Create your free profile