Senior Data Engineer

at  Department for Work and Pensions

JOB SUMMARY

Please note this role requires you to pass Security Check clearance. For further information, please see ‘Selection process details’.
Do you have strong SQL and/or Python data engineering skills? Would you like to put these to use whilst learning about cloud engineering, Informatica and/or SAS?
DWP is the UK’s largest government department. We help people into work and make payments worth over £195bn a year to support some of the most vulnerable people in our society.
DWP Digital creates digital services that almost everyone in the UK relies on at some point in their lives. We’re carrying out a once-in-a-generation digital transformation - a task of size and scale unmatched elsewhere.
Join us with solid SQL or Python fundamentals, and we will teach you the rest.

There are two roles available – one role in each of the following teams:

• Policy & Analysis - this team brings data in from several sources and systems and makes it available for our analytical community to make informed choices. The team warehouses and makes data efficient using Informatica and SAS.
• Centric – this team builds data solutions for DWP and external organisations. The team matches, merges, and exploits data to give people a solution to their business problem.

You will be expected to regularly work from Newcastle as part of the Policy and Analysis team, and from Blackpool as part of the Centric team.

JOB DESCRIPTION

Working with a mix of legacy on-premises and modern cloud engineering technologies, you’ll support the development of data solutions or warehousing. The role is fast-paced and offers you the opportunity to work with incredibly large datasets – often millions of rows of data. You’ll use efficient code to make it productionised and document how it works.
There’ll be lots of interaction with customers and stakeholders – you’ll collaborate with product and delivery managers, business analysts and data scientists.
You’ll oversee a small team of data engineers and oversee specialist contractor data engineers. You will explore new ideas and support your team in developing their technical and interpersonal skills.
This role has an emphasis on data engineering technical leadership – you’ll guide other data engineers in terms of direction setting and developing their technical capability. Your time will roughly be split 70% hands-on data engineering and 30% leadership, strategy, and management.

You will be responsible for:

• Overseeing the team to deliver all aspects of data development activities.
• Translating complex user requirements and data models into effective, robust ETL solutions in line with DWP build standards.
• Developing reusable, robust, and scalable products.
• Ensuring adherence to standards, legal, regulatory and security requirements across the DWP Data Engineering community.

TECHNICAL SKILLS

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

• Technical Breadth

Benefits

• An employer pension contribution of up to 28.97% For further information please click here.
• Annual leave rising up to 30 days, (based on your working pattern).
• Family friendly flexible working arrangements, such as hybrid working, job sharing, term-time working, flexi-time and compressed hours.
• Learning and development tailored to your role this could include industry recognised qualifications, coaching and mentoring.
• An inclusive and diverse environment with opportunities to join staff networks including: Women’s Network, National Race Network, National Disability Network (THRIVE) and many more.

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) (opens in a new window)
• 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 (opens in a new window)

There are two roles available – one role in each of the following teams:

• Policy & Analysis - this team brings data in from several sources and systems and makes it available for our analytical community to make informed choices. The team warehouses and makes data efficient using Informatica and SAS.
• Centric – this team builds data solutions for DWP and external organisations. The team matches, merges, and exploits data to give people a solution to their business problem

You will be responsible for:

• Overseeing the team to deliver all aspects of data development activities.
• Translating complex user requirements and data models into effective, robust ETL solutions in line with DWP build standards.
• Developing reusable, robust, and scalable products.
• Ensuring adherence to standards, legal, regulatory and security requirements across the DWP Data Engineering community