Senior Data Engineer x2

Details

Reference number

432847

Salary

£56,475 - £76,671

£56,475 - £67,974 (Leeds)

£61,250 - £76,671 (London)

A market supplement of 20% is attached to the role.

A Civil Service Pension with an employer contribution of 28.97%

GBP

Job grade

Grade 7### Contract type

Permanent### Business area

UKEF - DDaT - CTO### Type of role

Architecture and Data### Working pattern

Flexible working, Full-time### Number of jobs available

2

Contents

Location

About the job

Benefits

Things you need to know

Apply and further information

Location

Westminster, London or LeedsAbout the job

Job summary

The Digital, Data and Technology (DDAT) directorate has recently been established in UKEF, drawing together the expertise in digital currently within the organisation to provide representation of digital services, user centred design, analytics and technology at the highest levels. The areas with the directorate work closely with all areas of the business such as the Business Group, Operations and Strategy and Policy.### Job description

UKEF is committed to being a more customer-centric organisation, making it easier for customers to engage with us through improved response times, quicker decision-making, and streamlined case-processing. To support this, UKEF is embracing digital as the primary channel for managing relationships with a broader range of stakeholders. Focused on delivering end-to-end services that meet user needs and enable business outcomes, this is an exciting new role that reflects the growth and ambition of UKEF’s digital strategy.

This role requires hands-on experience with Informatica to develop and maintain data integration solutions, as well as proficiency in Azure cloud services to build scalable and secure data platforms. You will identify opportunities to improve data infrastructure and processes, manage ETL workflows, and oversee the deployment and release of data pipelines and applications.

Main Activities

Design, build, and maintain scalable data integration pipelines using tools such as Informatica, ensuring efficient ingestion, transformation, and delivery of structured and unstructured data.

Develop and manage cloud-based data solutions leveraging Azure services including Azure Data Lake, Azure SQL, and Azure Managed Instance, with a focus on performance, security, and cost-efficiency.

Leverage Microsoft Fabric’s unified data platform to support end-to-end workflows — from ingestion and transformation to analytics and visualization — integrating services like OneLake, Data Factory, and Synapse.

Monitor and troubleshoot data processing systems to ensure high availability, reliability, and timely resolution of issues across production and development environments.

Ensure data governance and compliance with regulations such as GDPR, through implementation of access controls, encryption, and data masking strategies.

Collaborate with stakeholders to identify opportunities for improving data infrastructure, automation, and analytics capabilities.

Lead code reviews and quality assurance efforts to uphold engineering best practices and maintain high standards across the data engineering team.

Manage deployment and release processes for data pipelines and applications, ensuring robust versioning, rollback strategies, and change control.

Contribute to the organisation’s data strategy and roadmap, staying current with industry trends and emerging technologies in data engineering and cloud computing.

This role Is aligned with the Government Digital and Data Profession Capability Framework - Senior Data Engineer.

This list is not exhaustive, and you may be required to carry out additional duties according to business needs.

Person specification

UK Export Finance is looking for motivated individuals with a desire to learn about the business. Successful candidates will be provided not only with functional training to enable them to do well in their role, but also with personal development to help them to achieve their career ambitions. Please note that the person specification below outlines at which stage(s) you will be assessed on how you meet the criteria for the role(s) including:-

A\= assessed at application stage I \= assessed at interview stage P \= assessed at presentation stage

Essential

Evidence of continuing professional development. (A, I)

Expert knowledge of SQL and T-SQL. (A, I)

Knowledge of ETL and ELT tools. (A, I)

Expert knowledge of Data warehouse architectures and Data modelling techniques. (A, I)

Communicating between the technical and non-technical (A, I)

• You can communicate effectively with technical and non-technical stakeholders.

• You can support and host discussions within a multidisciplinary team, with potentially difficult dynamics.

• You can be an advocate for the team externally and can manage differing perspectives.

Data analysis and synthesis (A, I)

• You can undertake data profiling and source system analysis.

• You can present clear insights to colleagues to support the end use of the data.

Data development process (A, I)

• You can design, build and test data products that are complex or large scale.

• You can build teams to complete data integration services.

Data innovation (A, I)

• You can understand the impact on the organisation of emerging trends in data tools, analysis techniques and data usage

Data integration design (A, I)

• You can understand the concepts and principles of data modelling.

• You can produce relevant data models across multiple subject areas.

• You can reverse-engineer data models from a live system.

• You can understand industry-recognised data modelling patterns and standards, and when to apply them.

• You can compare and align different data models.

Data modelling (A, I)

• You can understand the concepts and principles of data modelling and can produce relevant data models.

• You can work across government and industry, recognising opportunities for the reuse and alignment of data models in different organisations.

• You can design the method to categorise data models within an organisation.

Metadata management (A, I)

• You can design an appropriate metadata repository and present changes to existing metadata repositories.

• You can understand a range of tools for storing and working with metadata.

• You can provide oversight and advice to more inexperienced members of the team.

Problem resolution (A, I)

• You can respond to problems in databases, data processes, data products and services as they occur.

• You can initiate actions, monitor services and identify trends to resolve problems.

• You can determine the appropriate remedy and assist with its implementation, and with preventative measures.

Programming and build (A, I)

• You can use agreed standards and tools to design, code, test, correct and document moderate-to-complex programs and scripts from agreed specifications and subsequent iterations.

• You can collaborate with others to review specifications where appropriate.

Technical understanding (A, I)

• You can understand the core technical concepts related to the role and apply them with guidance.

Experience in any of the following disciplines below; (A, I)

• Microsoft Fabric: Familiarity with Microsoft Fabric’s unified data platform capabilities, including integration with OneLake, Data Factory, and Synapse experiences. Understanding of how Fabric supports end-to-end data workflows, from ingestion and transformation to analytics and visualisation, within a single SaaS environment.

• ETL Tools: Experience using Informatica IICS, with an understanding of how these can complement or transition into Microsoft Fabric’s Data Factory pipelines.

• Azure Cloud Computing: Experience using Azure services such as Azure Managed Instance, Azure Data Lakes, and Azure SQL to build scalable and secure cloud-based data solutions.

• SQL Coding: Proficient in T-SQL for querying, data manipulation, and performance tuning.

• MSSQL Stack: Hands-on experience with the Microsoft SQL Server stack, including SSMS, SSIS, SSRS, and SSAS.

• SQL Server Optimisation: Knowledge and practical experience in SQL Server optimisation techniques, including indexing strategies, query tuning, and execution plan analysis.

• Database Design: Skilled in designing efficient, scalable, and conformant relational database schemas.

• SQL Server Troubleshooting: Experience diagnosing and resolving performance and connectivity issues in SQL Server environments.

• Agile Methodologies: Practical experience working in Agile environments, including Scrum and Kanban frameworks, with a focus on iterative delivery and stakeholder collaboration.

• Unit Testing: Familiarity with unit testing practices for data pipelines and SQL procedures to ensure reliability and maintainability.

Behaviours

We'll assess you against these behaviours during the selection process:

Changing and Improving

Delivering at Pace

Communicating and Influencing

Technical skills

We'll assess you against these technical skills during the selection process:

Question - Please provide an example of a data engineering solution you have developed using Microsoft Fabric and/or Informatica IICS. What was the business impact and what technical challenges did you overcome?

Question - Describe your experience with SQL and data warehouse architectures. What techniques have you used to ensure data integrity and optimise performance in cloud or hybrid environments?

Questions - This will be a technical question assessing against the Government Digital and Data Profession Capability Framework – Senior Data Engineer.

We only ask for evidence of these technical skills on your application form:

Question - Please provide an example of a data engineering solution you have developed using Microsoft Fabric and/or Informatica IICS. What was the business impact and what technical challenges did you overcome?

Question - Describe your experience with SQL and data warehouse architectures. What techniques have you used to ensure data integrity and optimise performance in cloud or hybrid environments?

Benefits

Alongside your salary of £56,475, UK Export Finance contributes £16,360 towards you being a member of the Civil Service Defined Benefit Pension scheme. Find out what benefits a Civil Service Pension provides.* Learning and development tailored to your role

An environment with flexible working options

A culture encouraging inclusion and diversity

A Civil Service pension with an employer contribution of 28.97%

Things you need to know

Selection process details

This vacancy is using Success Profiles , and will assess your Behaviours, Experience and Technical skills.

We are assessing candidates using Success Profiles (see Appendix 1) and across the whole process we will assess your Experience, Technical and Behaviours as highlighted below.

The application must be completed by 23.55 on the day of the closing date for it to be accepted.

Use of Artificial Intelligence (AI)

Artificial Intelligence can be a useful tool to support your application, however, all examples and statements provided must be truthful, factually accurate and taken directly from your own experience. Where plagiarism has been identified (presenting the ideas and experiences of others, or generated by artificial intelligence, as your own) applications may be withdrawn and internal candidates may be subject to disciplinary action. Please see our candidate guidance for more information on appropriate and inappropriate use.

All applications will be sifted against our essential criteria outlined in the personal specification.

Statement of suitability - you should fully articulate in 750 words how you meet the essential criteria outlined in the person specification within the Information Pack.

Technical Questions - 250 Word Limit

• Please provide an example of a data engineering solution you have developed using Microsoft Fabric and/or Informatica IICS. What was the business impact and what technical challenges did you overcome?

• Describe your experience with SQL and data warehouse architectures. What techniques have you used to ensure data integrity and optimise performance in cloud or hybrid environments?

For the initial sift your application will be evaluated against :

Experience - CV / Application and Statement of Suitability

Technical - Questions, 250 Word Limit

• Please provide an example of a data engineering solution you have developed using Microsoft Fabric and/or Informatica IICS. What was the business impact and what technical challenges did you overcome?

• Describe your experience with SQL and data warehouse architectures. What techniques have you used to ensure data integrity and optimise performance in cloud or hybrid environments?

In the event of a high volume of applications, there will be a pre-sift on the following;

Essential Criteria

• Communicating between the technical and non-technical (A, I)

You can communicate effectively with technical and non-technical stakeholders.

You can support and host discussions within a multidisciplinary team, with potentially difficult dynamics.

You can be an advocate for the team externally and can manage differing perspectives.

• Technical Questions, 250 Word Limit

Please provide an example of a data engineering solution you have developed using Microsoft Fabric and/or Informatica IICS. What was the business impact and what technical challenges did you overcome?

Describe your experience with SQL and data warehouse architectures. What techniques have you used to ensure data integrity and optimise performance in cloud or hybrid environments?

If you are successful following the sift stage, you will be invited to an initial interview; this will include the following assessment:

Behaviours - a formal panel interview where you will be interviewed across all three behaviours below.

• Behaviour - Changing and Improving

• Behaviour - Delivering at Pace

• Behaviour - Communicating and Influencing

Technical - Questions

• This will be technical questions assessing against the Government Digital and Data Profession Capability Framework – Senior Data Engineer.

Details of interview panel members will be e-mailed to all successful candidates who are invited for interview.

Feedback will only be provided if you attend an interview or assessment.### Security

Successful candidates must undergo a criminal record check.

Successful candidates must meet the security requirements before they can be appointed. The level of security needed is security check .

See our vetting charter .

People working with government assets must complete baseline personnel security standard (opens in new window) checks.### Nationality requirements

This job is broadly open to the following groups:

UK nationals

nationals of the Republic of Ireland

nationals of Commonwealth countries who have the right to work in the UK

nationals of the EU, Switzerland, Norway, Iceland or Liechtenstein and family members of those nationalities with settled or pre-settled status under the European Union Settlement Scheme (EUSS)

nationals of the EU, Switzerland, Norway, Iceland or Liechtenstein and family members of those nationalities who have made a valid application for settled or pre-settled status under the European Union Settlement Scheme (EUSS)

individuals with limited leave to remain or indefinite leave to remain who were eligible to apply for EUSS on or before 31 December 2020

Turkish nationals, and certain family members of Turkish nationals, who have accrued the right to work in the Civil Service

Further information on nationality requirements

Working for the Civil Service

The Civil Service Code sets out the standards of behaviour expected of civil servants.

We recruit by merit on the basis of fair and open competition, as outlined in the Civil Service Commission's recruitment principles .

The Civil Service embraces diversity and promotes equal opportunities. As such, we run a Disability Confident Scheme (DCS) for candidates with disabilities who meet the minimum selection criteria.

The Civil Service also offers a Redeployment Interview Scheme to civil servants who are at risk of redundancy, and who meet the minimum requirements for the advertised vacancy.### Diversity and Inclusion

The Civil Service is committed to attract, retain and invest in talent wherever it is found. To learn more please see the Civil Service People Plan and the Civil Service Diversity and Inclusion Strategy .Apply and further information

This vacancy is part of the Great Place to Work for Veterans initiative.

Once this job has closed, the job advert will no longer be available. You may want to save a copy for your records.### Contact point for applicants

Name : UKEF Recruitment

Email : Recruitment2@ukexportfinance.gov.uk

Email : Recruitment2@ukexportfinance.gov.uk

Further information

Should you have a complaint or wish to raise any concerns regarding the recruitment process, please e-mail your complaint to the Head of Pay and Resourcing (UKEF) at Recruitment2@ukexportfinance.gov.uk and include “Complaint” in the subject heading. Should you remain dissatisfied following UKEF’s investigation then you can refer your complaint to the Commission - http://civilservicecommission.independent.gov.uk/making-complaint.