At a Glance
- Tasks: Enhance DWP's data integration services and manage data pipelines using Informatica PowerCenter.
- Company: Join a forward-thinking government department focused on modernising data services.
- Benefits: Competitive pay, hybrid work model, and opportunities for professional growth.
- Other info: Diverse and inclusive workplace with guaranteed interviews for candidates with disabilities.
- Why this job: Make a real impact on public services while working with cutting-edge data technologies.
- Qualifications: Strong experience in Informatica PowerCenter, SQL, and ETL processes required.
The predicted salary is between 63000 - 77000 £ per year.
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 or Newcastle.
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.
Main Responsibilities
- 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 and the application of consistent business rules before data is released for use.
- Develop and maintain error handling, monitoring and logging within mappings, scripts and procedures to support issue identification and resolution.
- Use parameterisation techniques, including parameter files, to create flexible, reusable and maintainable workflows.
- Follow development standards and best practices when building solutions.
- 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.
- Deploy solutions in line with agreed release processes, including version control, labelling and configuration management.
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.
Senior Data Engineer (Informatica) employer: Alexander Mann Solutions - Public Sector Resourcing
Joining UK Parliament as a Microsoft M365 and Copilot Specialist offers a unique opportunity to contribute to the public sector while enjoying a hybrid work model in the vibrant city of London. With a strong emphasis on employee growth, you will have access to continuous learning and development opportunities, alongside a collaborative work culture that values innovation and stakeholder engagement. The role not only allows you to leverage your technical expertise but also to make a meaningful impact on how technology enhances productivity and collaboration within the organisation.
Contact Details:
Alexander Mann Solutions - Public Sector Resourcing Recruitment Team
StudySmarter Expert Advice🤫
We think this is how you could land Senior Data Engineer (Informatica)
✨Tap into Online Data Science Communities
Join online communities focused on data science like Kaggle, LinkedIn groups, or Reddit threads. These are goldmines for temporary gigs, as you can network with professionals and potentially hear about opportunities at companies like Alexander Mann Solutions - Public Sector Resourcing before they're even advertised!
✨Show Off Your Skills With Projects
Got some cool data science projects? Showcase them on platforms like GitHub or create a personal portfolio website. This visibility is crucial for landing temporary roles—let recruiters see your actual skills in action, which can set you apart from the crowd.
✨Check Out Specialist Job Boards
For temp roles, hit up job boards dedicated to tech and data science, like Stack Overflow Jobs or DataJobs. These platforms often feature openings that you won’t find on general job sites, including contracts with companies like Alexander Mann Solutions - Public Sector Resourcing.
✨Leverage University Resources
If you're currently at uni or recently graduated, tap into your school's career services. They often have connections with companies looking for temporary data science interns or contract workers, and they might even host job fairs with employers like Alexander Mann Solutions - Public Sector Resourcing.
We think you need these skills to ace Senior Data Engineer (Informatica)
Some tips for your application 🫡
Highlight Your Data Projects:When applying for a temporary data science role at Alexander Mann Solutions - Public Sector Resourcing, make sure to showcase any relevant projects you've worked on. Whether it's a personal project, an academic undertaking, or contributions to an open-source initiative, detailing these experiences can really set you apart and demonstrate your practical skills.
Emphasise Your Analytical Skills:In your CV and cover letter, focus on the specific analytical skills that are key to data science. Mention any experience with statistical tools, programming languages like Python or R, and data visualisation software. Don't forget to include any certifications that may bolster your expertise!
Show Your Flexibility:Since this is a temporary role, it's important to convey your adaptability and willingness to learn. In your cover letter to Alexander Mann Solutions - Public Sector Resourcing, emphasise how quickly you can get up to speed with new tools or projects. Highlight any previous experiences where you've had to adjust to new environments or challenges.
Craft a Unique Data-Driven Cover Letter:Instead of the usual generic cover letter, spice it up with some data! Maybe you’ve improved a process by 20% in a past role or cleaned a dataset with over a million entries. Use these stats to your advantage to grab Alexander Mann Solutions - Public Sector Resourcing’s attention and show the tangible impact of your work.
How to prepare for a job interview at Alexander Mann Solutions - Public Sector Resourcing
✨Showcase Your Analytical Skills
For a data science gig, it's crucial to demonstrate your analytical abilities. Be ready to discuss previous projects and the methodologies you used. Think about how you can quantify your impact—did your analysis improve efficiency or save costs? These are the stories that will stick with interviewers at Alexander Mann Solutions - Public Sector Resourcing.
✨Brush Up on Technical Skills
You might face technical questions on tools relevant to data science, like Python, R, or SQL. Prepare to solve a problem live—perhaps they'll ask you to write a simple query or code snippet. It’s cool to talk about them, but we need to show we can do it in practice, especially in a temporary role where quick results matter.
✨Highlight Your Adaptability
Since this is a temporary position, emphasise your ability to learn quickly and adapt to new tools or workflows. Share examples of how you've thrived in fast-paced environments before, and how you can hit the ground running at Alexander Mann Solutions - Public Sector Resourcing.
✨Prepare a Portfolio of Your Work
Bring your portfolio to the table—showcase projects where you've leveraged data science techniques to solve problems. Whether it’s a GitHub repository or a set of case studies, having tangible examples of your work will help you stand out and show what you bring to the team at Alexander Mann Solutions - Public Sector Resourcing.
