CS Interview Coach

Senior Data Engineer

Department for Work and Pensions

Department
Department for Work and Pensions
Location
Newcastle upon Tyne, Birmingham, Manchester, Leeds, Sheffield, Blackpool
Openings
2 posts
Grade
Grade 7
Salary
£57,946 to £75,664
Closing
6 days left
Profession
DDaT
Contract
Permanent
Security clearance
SC
Working pattern
Flexible working, Full-time, Job share, Part-time
Apply on Civil Service Jobs

Job summary

Please note this role requires you to pass Security Check clearance. For further information, please see 'Selection process details'.

Do you want to be part of an energetic, innovative team and bring your skills to one of the biggest changes to the administration of the Civil Service in decades?

We’re looking for people who are flexible, intuitive and are comfortable taking high levels of volume, speed and complexity in their stride.

An exciting role is available in the Synergy Shared Services Hub (Hub), a new organisation which will manage shared services on behalf of departments in the Synergy cluster: Ministry of Justice, Department for Work and Pensions, Department for the Environment, Food and Rural Affairs and the Home Office.

Your work will impact Shared Services arrangements and support almost a quarter of a million officials and public servants across the four departments and arm’s length bodies who deliver some of the most vital public services in our country.

The success of the Hub is crucial, as Civil Servants rely on shared services to provide business critical tools in human resources, finance, payroll and procurement. Shared services affect everything we do, from joining a department as a new starter, the way we claim for expenses, how we buy goods and services such as our laptops and canteen provisions, to the way we receive our pensions when we retire.

Most importantly, we’re looking for applications from people who can also demonstrate a passion for our core ambition - delivering a once in a generation, transformed service.

What they’re looking for

  • When giving details in your employment history and personal statement you should highlight your experience in line with essential criteria below:
  • PRACTITIONER: Strong experience of leading the design and delivery of complex data solutions across a team/business area in accordance with agreed organisational standards that ensure services are resilient, scalable and future proof.
  • PRACTITIONER: Advanced experience using SQL, Python, (in a Spark context) to interrogate, transform, analyse and troubleshoot complex datasets, with knowledge of Oracle Fusion reporting technologies, including FDI/AIDP and OTBI, or equivalent reporting platforms.
  • EXPERT: Ability to lead the development of a portfolio of ETL pipelines, across a range of complex and/or large volume data including effective delegation of work.
  • PRACTITIONER: Knowledge of leading the identification, description and isolation of complex technical data, coding, tooling and platform problems; coaching the team in describing and resolving these.
  • PRACTITIONER: Ability to determine, collate and translate complex customer requirements and translate these into delivery design for data processing.
  • PRACTITIONER: Good ability to manage senior stakeholders including the ability to manage a diverse set of stakeholders to translate, prioritise and integrate their technical needs in team workflow.
  • If you would like to learn more about the role, please contact Natalie.Selby1@dwp.gov.uk

Job description

Primarily, this role will involve leading the design and development of reporting data solutions using Oracle Fusion Data Intelligence (FDI/AIDP), OTBI and other modern cloud technologies, ensuring data products are scalable, secure and fit for reporting purposes.

You'll work across the full reporting development lifecycle, designing and developing the data pipelines, integrations, datasets and reporting products that enable reporting and analytics services across the Synergy Shared Services Hub. While the role has a strong focus on data engineering, you'll also contribute to the development and enhancement of report solutions, ensuring they deliver trusted management information and insight to users across multiple government departments.

This role has a strong emphasis on technical leadership. You'll provide direction, guidance and support to Data Engineers, helping to develop technical capability, establish engineering standards and promote best practice across the reporting team.

Working as part of the Hub Reporting Team, you'll help shape and steer the data engineering function within a wider reporting product team. You'll work closely with a variety of stakeholders to design and deliver robust, scalable and reusable reporting solutions.

You'll support the development of data engineering capability across the team, helping the team understand and make effective use of emerging technologies, and supporting colleagues in developing their skills.

You will be accountable for:

  • Leading the implementation of Management Information (MI) / Business Intelligence (BI) reports and dashboards to meet customer requirements. Includes working with experts in other disciplines to implement dashboard and reporting standards.
  • Leading the collection of complex data requirements from a wide range of stakeholders, interpreting the data and shape data sets for Data Analysts to fulfil requirements in their creation of analysis and insight dashboards and other reporting products.
  • Leading the design, build and testing of data products based on feeds from multiple systems, applying expert knowledge of data engineering, storage technologies and access methods, while promoting consistent approaches across the teams.
  • Leading the development and maintenance of ETL processes to clean, transform, and load data into appropriate storage systems, including ensuring consistent application across the team for a wide range of downstream reporting uses.
  • Providing the team with leadership and expertise on how we build, test and maintain data pipelines and products at scale, implementing core standards for code, quality, security, and operational resilience; ensuring and implementing cross-departmental consistency.
  • Leading the development and implementation of data management and tracking policies and procedures across teams, in order to ensure data integrity, security, and access while maintaining compliance to GDPR and other relevant legislation.
  • Providing technical leadership, setting engineering team and community direction to ensure the products that are developed conform to data standards and strategic principles.

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)

Selection process

Stage 1: Application

Your application will consist of three parts:

1. A Personal Details application form.

2. Employment history - this should contain your work experience and any skills, qualifications and accomplishments relevant to the jobs you have completed based on the essential criteria.

3. Personal statement - up to 1250 words. This statement should be used to provide examples of how you meet the essential criteria listed in the Person specification.

Ensure that all examples provided in your statement are taken directly from your own experience and that you describe the examples in your own words. If you choose to use gen-AI to support your statement, you must follow the guidelines outlined in the Artificial intelligence and recruitment guide.

The sift panel will use the information in your employment history and personal statement to assess your experience, skills and knowledge against the essential criteria.

You will be provided with one combined overall assessment score for both your CV and Personal Statement.

For Hints and Tips on completing your application visit Applying for jobs at DWP Digital.

Important Information

  • You will be asked to complete your employment history. Any information that you would customarily share on a CV should therefore be entered onto the application form.
  • Personal details that could be used to identify you including your name, contact details and address must be removed for your application to be considered.
  • If your employment history/personal statement contains any personal details your application will be withdrawn.

Stage 2: Interview

If you’re successful at sift stage you will be invited to a video interview via Microsoft Teams. There, you will be assessed against the experiences listed in the essential criteria.

Interviews will take place from late September 2026. Interview dates to be confirmed.

Further Information

All successful candidates and those placed on reserve will be posted in merit list order by location.

For these vacancies, we strongly recommend that applicants consult with an immigration specialist or qualified advisor to assess their eligibility for Visa Sponsorship before deciding to apply. Please note that while we consider sponsorship requests in accordance with current DWP guidance and Home Office policy, sponsorship cannot be guaranteed.

Security Clearance Requirement

You must meet the security requirements before you can be appointed. The level of security needed is security check.

You must have resided continuously in the UK for at least 3 of the last 5 years, 2 of which must have been the immediately preceding years from the point of applying for this job.

At the Department for Work and Pensions (DWP) we value diversity and inclusion and actively encourage and welcome applications from everyone, including those that are underrepresented in our workforce.

Find out more about working for DWP on the DWP Careers Hub.

Reserve List

A reserve list may be held for a period of 6 months from which further appointments can be made.

If you are placed on a reserve list but we cannot immediately offer you a post, please note:

  • If you are later offered the role you applied for, in a location you have expressed a preference for, and you decline the offer or are unable to take up the post within a reasonable timeframe you will be withdrawn from the campaign and removed from the reserve list, other than in exceptional circumstances (e.g. a contractual Part Time Working Pattern cannot be accommodated in the initial role offered or in cases of serious ill health).
  • If DWP makes an offer of an alternative role or location to that which you originally applied for, and you decline that offer, you will be able to remain on the reserve list.

Disability Confident Scheme

If high application volumes are received, the benchmark for candidates to proceed to the next stage may be raised. In line with our commitment to the Disability Confident Scheme (DCS), we aim to advance all candidates applying under the DCS who meet the minimum standard. However, we may only progress those candidates who best meet the required standards.

Reasonable Adjustments

We consider visible and non-visible disabilities, neurodiversity or learning differences, chronic medical conditions, or mental ill health. Examples include dyslexia, epilepsy, autism, chronic fatigue, or schizophrenia.

If you need a change to be made so that you can make your application, you should contact the Government Recruitment Service via digiralRecruitment.grs@cabinetoffice.gov.uk as soon as possible before the closing date to discuss your needs.

Complete the “Reasonable Adjustments” section in the “Additional requirements” page of your application form to tell us what changes or help you might need further on in the recruitment process. For instance, you may need wheelchair access at interview, or if you’re deaf, a Language Service Professional.

If you are experiencing accessibility problems with any attachments on this advert, please contact the email address in the 'Contact point for applicants' section.

Integrity, plagiarism and Civil Service Principles

The Civil Service values honesty and integrity and expects all candidates to abide by these principles.

Please ensure that all examples provided in your application are taken directly from your own experience and that you describe the examples in your own words.

Examples of plagiarism can include:

  • Presenting the work, ideas and experience of others as your own
  • Copying content or answers from an online or published source that is not your own

Disclosure and Barring Service and Internal Fraud Database Checks

To process applications without delay, we will be sending a Criminal Record Check to Disclosure and Barring Service on your behalf. However, we recognise in exceptional circumstances some candidates will want to send their completed forms direct. If you will be doing this, please advise Government Recruitment Service of your intention by emailing Pre-EmploymentChecks.grs@cabinetoffice.gov.uk stating the job reference number in the subject heading.

Applicants who are successful at interview will be, as part of pre-employment screening, subject to a check on the Internal Fraud Database (IFD). This check will provide information about employees who have been dismissed for fraud or dishonesty offences. This check also applies to employees who resign or otherwise leave before being dismissed for fraud or dishonesty had their employment continued. Any applicant’s details held on the IFD will be refused employment. A candidate is not eligible to apply for a role within the Civil Service if the application is made within a 5 year period following a dismissal for carrying out internal fraud against government.

If successful and transferring from another Government Department, a criminal record check will be carried out.

Important

New entrants are expected to join on the minimum of the pay band.

Before applying for this vacancy, current employees of DWP should check whether a successful application would result in changes to their terms & conditions of employment, e.g. mobility, pay, allowances. If you are a current employee and are successful you must be able to be released from your current post within four weeks.

Those on protected TUPE/ COSoP terms and conditions applying on promotion or voluntary permanent level move will adopt DWP’s Terms and Conditions and this may have a different impact on pay and allowances. Please review this prior to acceptance of a role.

Civil Servants that would transfer into DWP from other government organisations, following successful application, will assume DWP's terms & conditions of employment current on the day they are posted, unless DWP has stated otherwise in writing. Accepting a post will be taken to mean acceptance of revised terms & conditions.

Civil Servants applying on promotion will usually be appointed to the salary minimum or within 10% of existing salary.

Any move to DWP from another employer will mean you can no longer access childcare vouchers. This includes moves between government departments. You may, however, be eligible for other government schemes, including Tax Free Childcare. Determine your eligibility at the Childcare Choices Website.

For further information on National Security Vetting please visit the Demystifying Vetting website.

Feedback

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

Practise before you apply

Civil Service panels score every answer against the Success Profiles behaviours at Grade 7 level. Practise STAR answers and get them marked against the same framework.

Start practising free

3 free questions · No card needed

Similar vacancies

Interview articles for Grade 7 roles

All articles

Browse more like this