Software Engineer - Data-Driven Systems

Software Engineer - Data- Driven Systems (SC Cleared)

• Contract: 3 - month rolling
• Location: Remote (occasional visit to a regional hub)
• Clearance: Active SC Clearance required

Role Overview

We are seeking an SC - cleared Software Engineer with strong experience in SQL and Java, and a demonstrable background in hands - on implementation of database structures and data schema mappings.

This role is delivery - focused and implementation - heavy. The successful candidate will be responsible for building and implementing database schemas, mappings, and data - driven application components, rather than providing high - level architectural oversight. A well - rounded software developer with strong Back End and database skills is likely to be a better fit than someone operating primarily in a data architecture or governance capacity.

You will work on a UK Central Government programme delivering secure, auditable, data - driven systems, translating complex raw data into structured, queryable, and compliant database models. The role requires confidence working directly with relational databases, schema evolution, and application - level integration in Java.

Key Responsibilities

• Design and implement relational database schemas, including tables, relationships, constraints, and indexes

• Build and maintain data schema mappings between source data and target models (including POLE - aligned structures where applicable)

• Develop Java - based Back End components that read from, write to, and operate on relational databases

• W rite, optimise, and maintain complex SQL queries for data integration, validation, and application use

• Implement temporal and historical data structures to support auditability and time - based analysis

• Translate data modelling requirements into working, production - ready implementations

• Implement permission - aware data access patterns at database and application level

• Support and enhance audit logging, capturing:

• Who accessed data

• What data was accessed

• When access occurred

• Why access was permitted

• Build and support data processing workloads using AWS services

• Collaborate closely with analysts, architects, and security stakeholders to ensure solutions meet compliance and assurance requirements

• Contribute code directly to production systems, with a strong focus on quality, performance, and correctness

Essential Skills & Experience

• Strong proficiency in SQL, including:

• Schema creation and modification

• Query optimisation

• Joins, indexing, constraints, and transaction management

• Strong Java development experience, particularly in data - driven or Back End systems

• D emonstrable experience implementing database schemas and data structures, not just designing them

• Solid understanding of:

• Relational database design and normalisation

• Data integrity and consistency

• Schema versioning and evolution

• Hands - on experience working with PostgreSQL or a similar relational database

• Experience building auditable data systems with clear access and data lineage

• Comfortable working in a secure, delivery - focused government environment

• Ability to work independently and take ownership of implementation tasks end to end

• Strong proficiency in SQL, including:

• Schema creation and modification

• Query optimisation

• Joins, indexing, constraints, and transaction management

• Strong Java development experience, particularly in data - driven or Back End systems

• D emonstrable experience implementing database schemas and data structures, not just designing them

• Solid understanding of:

• Relational database design and normalisation

• Data integrity and consistency

• Schema versioning and evolution

• Hands - on experience working with PostgreSQL or a similar relational database

• Experience building auditable data systems with clear access and data lineage

• Comfortable working in a secure, delivery - focused government environment

• Ability to work independently and take ownership of implementation tasks end to end