Data Engineer - Snowflake

About us: We are the Information Intelligence Group (IIG) of CACI UK, a specialist technical consultancy providing bespoke solutions to solve complex operational problems. Due to some exciting growth within our business, we are interested in speaking with an experienced Data Engineer to join us.

Role Location: You can work from any of our 5 offices in the UK (including Bristol, Cheltenham & London) or from home, you decide. The role will involve occasional travel to meet customers.

About the Role: As a Data Engineer at CACI IIG, you join a community of dedicated engineers who deliver cutting edge solutions for our public sector customers across Central Government, Defence, National Security and Critical National Infrastructure. You will collaborate closely with our clients to design and maintain robust, scalable data pipelines that guarantee data availability, accuracy, and performance for analytics and operational decision-making. In addition, you’ll help shape the data engineering roadmap by driving research, defining technical strategy, aligning with business priorities, and influencing key decisions. This role will be focussed on the delivery of high priority projects where you will be supporting our customers across the full project lifecycle from initiation to conclusion. Working with a broad range of technical tools, you will be support with compliance to data governance, standards and quality frameworks.

Key Responsibilities will Include:

• Interpret and validate data requirements, gather and analyse large-scale structured datasets, and perform profiling within data environments to ensure accuracy and completeness.
• Design and implement ETL frameworks to ingest, transform, validate, normalize, and cleanse data, ensuring it meets business and technical needs.
• Apply data quality controls and prepare datasets for visualisation, implementing data models and manage storage solutions like Amazon S3, Azure Blob Storage, BigQuery, and Snowflake.
• Support the development of data management standards and policies, including techniques for data synthesis and anonymisation to maintain compliance and security.
• Develop robust data models to support analytics and reporting within secure environments.
• Delivering performance optimisation through the monitoring and tuning of data workflows for speed, cost efficiency, and reliability.
• Establish and refine best practices in data engineering, while contributing to advanced analytics and visualisation strategies through research, evaluation of emerging technologies, and presentation of findings to stakeholders.

The Fit: The ideal candidate will have a background of working with industry best practices for data management, security, scalability, and awareness of Data Standards, Interoperability, Data Governance, and Data Sharing across security domains. We are looking for someone who is passionate about technology, enjoys problem-solving, and has a collaborative mindset.

Additional skills include:

• Proven experience as a Data Engineer within complex environments.
• Strong knowledge of data management principles, including data modelling, integration, and governance.
• Ability to assess existing data management systems and recommend improvements.
• Experience working with Snowflake - Essential.
• Familiarity with modern data architectures (e.g., cloud-based, distributed systems).
• Proficiency in SQL, Python, and data pipeline tools (e.g., Apache Airflow, Spark).
• Experience with cloud platforms (AWS, Azure, GCP) and big data technologies.
• Awareness and evidence of Data Analytics and Visualisation.

Due to the industries we work in, we require the successful candidate to be able to obtain high level security clearance. To qualify for this, you must be a British citizen and have lived permanently in the UK for the last 5 years.

Why work for us? IIG has the culture and feel of a small business, paired with the benefits of our position in a much larger organisation. The Data Engineer role is an excellent opportunity, and CACI reward their staff well with a competitive salary and impressive benefits package which includes:

• Flexi-time: 37.5 hour weeks to structure how you want.
• Hybrid working: Work from one of our offices or from home - you choose.
• L&D: Budget for conferences, training courses and other materials.
• Social: Fantastic culture with monthly social events.
• Future You: Matched pension and health care package.

As a Data Engineer, career development and ongoing training is a key part of your growth. You will be expected to take significant ownership of your career and proactively take the steps which you need to achieve the goals set for yourself. We take great pride in taking care of our talent, providing a highly dynamic, inclusive and team-led environment where everyone can thrive.

Equal Opportunities: CACI is proud to be an equal opportunities employer. Embracing the diversity of our people, we are on a journey to build a truly inclusive work environment where no one is treated less favourably due to ethnic origin, age, gender, veteran status, religion or belief, sexual orientation, marital status, and disability or health condition, actively working to prevent discrimination. As a Disability Confident employer, we will:

• Provide reasonable adjustments in the recruitment process where requested.
• Offer people with health conditions and disabilities, meeting the minimum criteria for a role, an interview.

Our people are unique, and we encourage and support them to be confident in contributing to our inclusion journey.