SC Cleared Data Engineer

We are seeking anSC-Cleared Data Engineerto support the development and maintenance of data integration and transformation solutions within a secure government or regulated environment. The role will focus heavily on XML and JSON processing, data transformation, and ETL pipelines, with specific involvement in CRS and FATCA XML transformation and splitting.

The successful candidate will work as part of a multidisciplinary engineering team, contributing to secure, scalable, and robust data processing solutions, primarily using Java, Unix Shell Scripting, and relational database technologies., * Design, develop, and maintain data processing and transformation solutions using Java and related technologies

• Perform XML transformation, validation, splitting, and enrichment, particularly for CRS-FATCA regulatory reporting formats
• Develop and maintain ETL workflows and data integration pipelines
• Work with JSON and XML data formats to support data ingestion, transformation, and output
• Write and optimize SQL queries to support data extraction, transformation, and validation
• Develop and maintain Unix/Linux Shell Scripts to support automation, batch processing, and system integration
• Integrate data solutions with relational databases such as Oracle DB and MySQL
• Troubleshoot and resolve data quality, performance, and processing issues
• Ensure solutions comply with security, data protection, and regulatory requirements
• Produce and maintain technical documentation, including design documents and operational runbooks
• Collaborate closely with other engineers, data analysts, and stakeholders in an Agile or DevOps environment

• Active SC Clearance (mandatory)
• Strong commercial experience with Java development
• Experience working in Unix/Linux environments, including Shell Scripting
• Proven experience working with XML and JSON, including parsing, transformation, and validation
• Solid experience with relational databases such as Oracle DB and/or MySQL
• Strong understanding of SQL, including complex queries and performance tuning
• Experience delivering software or data engineering solutions in secure or regulated environments

Square One is acting as both an employment agency and an employment business, and is an equal opportunities recruitment business. Square One embraces diversity and will treat everyone equally. Please see our website for our full diversity statement.