Senior Data Engineer

Description & Requirements

On behalf of DWP, we are looking for a Senior Data Engineer (Informatica) for a 12 month (Inside IR35) contract based Hybrid in Birmingham, Blackpool, Leeds, Manchester, Newcastle or Sheffield.

Core Purpose

We are seeking an experienced Senior Data Engineer (Informatica) to support the enhancement and modernisation of DWP's data integration services. You will work within a legacy Informatica PowerCenter environment, helping to reduce technical debt, improve data quality, enhance existing data pipelines and support the ongoing migration of services to the cloud. You will help ensure business critical data remains accessible, performant and trusted by users across the organisation.

As a Senior Data Engineer (Informatica) your main responsibilities will be to:

• Build and manage data pipelines using Informatica PowerCenter and SAS Enterprise Guide, including extracting, combining, cleansing and loading data from multiple source systems into target environments.
• Ensure data quality through validation, standardisation, monitoring and error handling to support reliable data integration processes.
• Use parameterisation techniques, including parameter files, to create flexible, reusable and maintainable workflows.
• Test thoroughly by creating and using test data to make sure mappings and processes work as expected.
• Diagnose and fix issues by reading Informatica logs and understanding root causes.
• Monitor data loads by building control tables and mechanisms to show whether jobs ran successfully.
• Develop and maintain Informatica transformations and expressions to ensure data is processed accurately and efficiently.

Essential:

• Strong Informatica PowerCenter experience.
• Strong SQL and database knowledge, particularly Oracle and data warehouse structures (e.g. dimensional models, SCD types).
• Experience building and managing ETL processes, including data extraction, transformation, cleansing and loading activities.
• Scripting skills (Unix/Bash) to support data movement, cleansing and automation.
• Strong problem solving and root cause analysis skills.
• Ability to communicate technical issues clearly to both technical and non-technical stakeholders.
• SC Clearance, or eligibility and willingness to obtain SC Clearance.

Desirable:

• Experience with SAS Enterprise Guide.
• Experience supporting legacy and on premises data integration platforms.
• Previous experience working within UK Government or other public sector organisations.

PLEASE NOTE: 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.

Please be aware that this role can only be worked within the UK and not Overseas.

Disability Confident

As a member of the Disability Confident Scheme, DWP 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. This scheme encourages candidates with a disability and/or neurodivergence to apply. In exceptional circumstances, we may also need to apply the desirable criteria in our shortlisting process which may include holding active security clearance.

Armed Forces Covenant

DWP 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 exceptional circumstances, we may also need to apply the desirable criteria in our shortlisting process which may include holding active security clearance.

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".

General information

Posting ID

PSR1JP00105645

Type of employment

Contract

Organisation

Department for Work & Pensions

Contract duration

12 Months

Location

UK Wide

Workplace Type

Hybrid