> Markdown version of [/jobs/ext/4755641-sc-cleared-analytics-engineer-london-inside-ir35](https://www.wearedevelopers.com/jobs/ext/4755641-sc-cleared-analytics-engineer-london-inside-ir35). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # SC Cleared Analytics Engineer - London - Inside IR35 - **Company:** Solirius Limited - **Location:** London, United Kingdom (Remote available) - **Contract:** Temporary contract - **Skills:** Amazon Web Services, Amazon S3, Data Analysis, Automation of Tests, Cloud Computing, Cloud Storage, Code Review, Continuous Integration, Data Transformation, Data Warehousing, Meta-Data Management, Runbook, SQL Databases, Macros, Sql Optimization, Data Build Tool (dbt), Git, SC Clearance, Data Lakes, Data Lineage, Deployment Automation, Data Analytics, Software Version Control - **Published:** November 17, 2026 - **Apply:** https://www.careerboard.com/gb/en/find-jobs-in-United-Kingdom/-FB32E586B813B912FE/ ## About the Role 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. ## Description 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., 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.