How your CV stacks up
Upload your CV to see how well it fits this job role
?%
Overview
We are seeking an experienced SC Cleared Data Engineer to join a critical data transformation programme. The successful candidate will be responsible for designing, building, and maintaining robust data integration solutions across both on-premises and cloud environments. Working closely with business, analytics, and technology teams, you will enable reliable data movement, modernise existing data processes, and support the organisation's data and AI ambitions.
This role requires strong expertise in SQL Server technologies, ETL development, Azure data services, and data warehouse solutions, with a focus on delivering scalable and automated data pipelines.
Key Responsibilities
- Understand existing business application databases and current BI/Data Warehouse environments.
- Design, build, and maintain data pipelines and ETL processes to support operational and analytical workloads.
- Implement and manage data flows between operational systems, data warehouses, analytics platforms, and BI solutions.
- Re-engineer and automate manual data processes to improve efficiency, scalability, and reliability.
- Develop and integrate data products and services into business systems and enterprise processes.
- Support the migration and integration of data from on-premises environments into Azure-based platforms.
- Ensure data quality, integrity, governance, and consistency across multiple systems.
- Enable data alignment and optimisation to support current and future AI initiatives.
- Collaborate with stakeholders to understand data requirements and translate them into technical solutions.
- Contribute to CI/CD processes and DevOps practices for data engineering deployments.
Technical Responsibilities
On-Premises Data Engineering
- Develop solutions to ingest and manage data within SQL Server 2022 environments.
- Build and maintain ETL processes using:
- SQL
- T-SQL
- SSIS (SQL Server Integration Services)
- Manage and support SQL Server environments used as:
- A landing and staging area for enterprise data.
- The underlying platform for existing Qlik and SSRS reporting solutions.
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
Cloud Data Engineering
- Design and implement data movement from on-premises SQL Server environments into Azure.
- Develop and maintain Azure-based data pipelines using:
- Azure Data Factory (ADF)
- Azure SQL Database
- Python Notebooks
- Azure Databricks
- Support modern cloud-based data architecture and analytics initiatives.
Essential Skills & Experience
- Active SC Clearance (mandatory).
- Strong Experience with SQL Server 2022.
- Advanced SQL and T-SQL development skills.
- Hands-on ETL development Experience using SSIS.
- Experience with data modelling and schema design.
- Proven expertise in data integration and data migration projects.
- Experience working with Azure Data Factory (ADF).
- Experience with Azure Databricks and cloud-based data processing.
- Knowledge of Azure SQL Database.
- Familiarity with Qlik and SSRS reporting environments.
- Experience using Azure DevOps, CI/CD pipelines, and Git source control.
- Strong troubleshooting, optimisation, and performance tuning skills.
Desirable Skills
- Experience with TOAD Data Modeler.
- Python scripting and notebook development.
- Experience working within secure government, defence, or regulated environments.
- Exposure to data governance, master data management, and AI-enabled data platforms.
- Knowledge of modern data architecture and cloud migration best practices.
Technology Stack
- Azure DevOps
- Git
- TOAD Data Modeler
- SQL Server 2022
- T-SQL
- SSIS
- Qlik
- SSRS
- Azure SQL Database
- Azure Data Factory (ADF)
- Azure Databricks
- Python Notebooks
Fully Remote, and SC clearance is a MUST
Job Title: Data Engineer
Get help with your application
Your very own career expert that helps elevate your application to the next level.
Location: Carlisle, UK
Job Type: Contract
Trading as TEKsystems. Allegis Group Limited, Maxis 2, Western Road, Bracknell, RG12 1RT, United Kingdom. No. 2876353. Allegis Group Limited operates as an Employment Business and Employment Agency as set out in the Conduct of Employment Agencies and Employment Businesses Regulations 2003. TEKsystems is a company within the Allegis Group network of companies (collectively referred to as "Allegis Group"). Aerotek, Aston Carter, EASi, Talentis Solutions, TEKsystems, Stamford Consultants and The Stamford Group are Allegis Group brands.
To access our Online Privacy Notice, which explains what information we may collect, use, share, and store about you, and describes your rights and choices about this, please go to https://www.allegisgroup.com/en-gb/privacy-notices.
We are part of a global network of companies and as a result, the personal data you provide will be shared within Allegis Group and transferred and processed outside the UK, Switzerland and European Economic Area subject to the protections described in the Allegis Group Online Privacy Notice. We store personal data in the UK, EEA, Switzerland and the USA. If you would like to exercise your privacy rights, please visit the "Contacting Us" section of our Online Privacy Notice at https://www.allegisgroup.com/en-gb/privacy-notices for details on how to contact us. To protect your privacy and security, we may take steps to verify your identity, such as a password and user ID if there is an account associated with your request, or identifying information such as your address or date of birth, before proceeding with your request. If you are resident in the UK, EEA or Switzerland, we will process any access request you make in accordance with our commitments under the UK Data Protection Act, EU-U.S. Privacy Shield or the Swiss-U.S. Privacy Shield.
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills