Data Engineer

• Design, develop and maintain ETL/ELT workflows using Informatica.
• Build and maintain data pipelines using Python and SQL.
• Develop complex SQL queries, stored procedures and data transformation logic.
• Perform data extraction, cleansing, validation and transformation.
• Integrate data from multiple sources into enterprise data platforms.
• Monitor, troubleshoot and optimise ETL processes and data pipelines.
• Ensure data quality, accuracy, consistency and integrity.
• Collaborate with data architects, analysts and development teams to deliver data engineering solutions.
• Follow data governance, security and compliance standards within secure environments.
• Identify opportunities to improve data processing efficiency and performance.

We are looking for an experienced Data Engineer with strong hands-on expertise in Informatica, Python and SQL to design, develop and maintain robust data integration and ETL solutions. The ideal candidate should have experience in data transformation, data migration, data warehousing and building scalable data pipelines.

The candidate must hold active UK SC Security Clearance (SC Cleared) and be comfortable working within secure environments., * Strong experience with Informatica PowerCenter and/or Informatica Intelligent Cloud Services (IICS).

• Strong programming and Scripting skills in Python.
• Advanced knowledge of SQL, including complex queries, joins, subqueries and performance optimisation.
• Hands-on experience in ETL/ELT development.
• Good understanding of data warehousing and data integration concepts.
• Experience with relational databases such as Oracle, SQL Server or PostgreSQL.
• Strong analytical, problem-solving and troubleshooting skills.

Security Clearance

• Active UK SC (Security Check) Clearance is mandatory.
• Candidates must be able to demonstrate their current clearance status.

Desirable Skills

• Experience working on UK Government, Defence or Public Sector projects.
• Knowledge of cloud-based data platforms and data engineering solutions.
• Experience with data migration, data modelling and data quality frameworks.
• Familiarity with Agile delivery methodologies.

Ideal Candidate Profile

We are looking for a technically strong Data Engineer who can independently develop and support enterprise-level data integration solutions using Informatica, Python and SQL, while working within a security-cleared environment.