Senior Data Engineer

On behalf of UK Export Finance, we are looking for a Senior Data Engineer for an 8 month contract based Hybrid in London. About the Role We are looking for a Senior Data Engineer with strong Informatica expertise to join our team. You will be responsible for designing, building, and supporting scalable data integration solutions, working closely with data architects, analysts, and business stakeholders to deliver reliable, performant data pipelines. This role sits within a finance reporting modernisation programme, supporting complex, regulated financial datasets used for monthly reporting. The work involves large, interdependent datasets and complex financial calculations, where accuracy, traceability, and clear documentation are critical. Experience working with finance or insurance data in regulated environments will be highly beneficial. We are looking for a Senior Data Engineer who has hands-on experience working in SME-scale teams where adaptability, autonomy and end-to-end ownership is essential - taking on multiple roles outside of the typical engineer workload and contributing across the full data lifecycle. As a Senior Data Engineer your main responsibilities will be to: • Work directly with SMEs, finance users and business stakeholders to collect requirements, clarify business logic and translate these into clear technical designs, data models and pipeline architectures. • Design, develop and maintain ETL/ELT pipelines using Informatica Cloud (IDMC / IICS), ensuring data quality, reliability and performance at scale. • Write and optimise complex SQL for data transformation, validation, troubleshooting and performance tuning. • Support and enhance existing Informatica mappings, workflows and data integration processes. • Monitor, troubleshoot and resolve data pipeline issues, performing root cause analysis and implementing preventative measures. • Own data engineering deliverables across the full lifecycle - requirements gathering, design, build, testing, deployment and early‑life support. • Contribute to data engineering standards, documentation, code reviews, testing and release processes, promoting best practices across the team. Essential: • Significant hands on experience with Informatica Cloud (IICS / IDMC) - Cloud Data Integration design, development and support • Strong SQL skills with experience writing complex queries, stored procedures, and performance tuning • Solid data engineering background, ideally within Azure-based environments • Experience working with Kimball data models or traditional dimensional modelling approaches • Proven ability to work directly with business stakeholders and SMEs to gather requirements, ask the right questions, communicate effectively across technical and non‑technical audiences, and independently shape technical solutions • Comfortable operating without detailed specifications - able to break down business problems and deliver effective solutions when working with large, complex datasets across multiple source systems SC Clearance is an essential requirement for this role, as a minimum you must be willing & eligible to undergo checks. Please note, due to the exceptional requirements of this position (short-term nature of this role and speed at which we require a postholder in situ) preference may be given to candidates who meet all of the essential criteria and hold active security clearance. Desirable: • Experience with Microsoft Fabric (Data Factory, Synapse, OneLake) • Exposure to financial services / FinTech environments • Working knowledge of financial reporting or accounting standards (e.g IFRS 9 / IFRS 17) • Familiarity with Azure DevOps and/or GitHub for CI/CD and version control • Experience with testing practices for data pipelines (unit testing, data quality checks, QA) • Broader Azure data services experience (Azure SQL, Managed Instance, Data Lake Storage) • Understanding of data governance, metadata management and data cataloguing Please be aware that this role can only be worked within the UK and not Overseas. DE&I commitment UKEF guarantees to interview all candidates who have a disability and who meet all the essential criteria for the vacancy. In cases where we have a high volume of candidates who have a disability who meet all the essential criteria, we will interview the best candidates from within that group. Armed Forces commitment UK Export Finance guarantees to interview veterans or spouses / partners of military personnel who meet all the essential criteria for the vacancy. In cases where we have a high volume of ex-military candidates / military spouses or partners, who meet all of the essential criteria, we will interview the best candidates from within that group. In applying for this role, you acknowledge the following "this role falls in scope of the Off Payroll Working in the Public Sector legislation. Any rates of payment quoted will reflect the gross rate per day for the assignment and will be subject to appropriate taxes and statutory costs. As such the payment to the intermediary and your income resulting from this contract will be different".