Data Engineer (Level II) – BI Developer

This role is based in Newcastle.

Please find further information on the Corporate hub locations here.

Please note that for candidates requesting to work in Newcastle, the role will initially be based at Benton Park View. It will then move to 1 Pilgrim Place in Newcastle city centre by the end of 2027.

Job Summary

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

Are you an experienced Data Engineer with strong Analytical skills?

Do you want to utilise best in class technologies to deliver exceptional cloud-based data products for Data Analysts and Scientists?

DWP’s Digital Group is looking for experienced Data Engineers to fill post of BI Developer.

A Fantastic Opportunity To Develop Your Skillset By:

• Working in a high-profile Digital Data Team delivering business critical BAU data and reporting products for the Child Maintenance Service (CMS), which are a key enabler in CMS delivering a quality service to customers and to Ministers.
• Supporting the migration of ChADS to Cloud based technologies.
• Developing your skillset in a range of Big Data and Cloud based technologies.
  
  

Successful candidates will join a fast-paced environment with a wide portfolio of products for analytical use and a challenging delivery roadmap. You’ll focus on a variety of tasks, supporting platform live service and delivering high quality, data transformation products.

Job Description

We’re looking for a motivated Power BI Developer to join our data team, supporting the Child Maintenance Service (CMS). This is a great opportunity for someone who enjoys working with data, building meaningful dashboards, and contributing to services that have a real positive impact on children and families.

This role has been created as part of our continued investment in modern data platforms and reporting capabilities, helping CMS make better, faster, evidence‑based decisions.

You’ll join a cross‑functional team of around 30 people, mainly based in Newcastle upon Tyne, working across data engineering, analytics, and delivery. The team uses SAS technologies alongside a new strategic Big Data stack, including Cloudera, Informatica, Power BI, and machine learning tools.

What You’ll Be Working On

You’ll help design and deliver dashboards and reports used by operational teams, analysts, and senior stakeholders to:

• Monitor service performance.
• Identify trends and risks.
• Improve outcomes and efficiency across CMS.
  
  

Your work will directly support decision‑making in a service that plays a vital role in supporting children and families across the UK.

Your role in the team

Working in an Agile environment, you’ll have the autonomy to:

• Design and develop robust, scalable Power BI solutions.
• Own the stability and performance of the products you build.
• Lead and support other developers within the squad.
• Collaborate with designers, testers, data engineers, and business stakeholders to shape solutions end to end.
  
  

Key Responsibilities

• Develop, design, and maintain interactive dashboards and reports using Power BI.
• Manage and monitor dataset refreshes, resolving issues quickly.
• Publish and maintain reports in Power BI Service, including access management.
• Optimise report performance and data models.
• Implement and maintain coding standards.
• Raise and resolve risks and issues appropriately.
• Communicate clearly with both technical and non‑technical stakeholders.
• Actively participate in sprint ceremonies and prioritisation.
• Coach and mentor junior team members.
  
  

Experience with AWS data services such as S3 and Redshift is desirable but not essential.

We’re looking for a motivated Power BI Developer to join our data team, supporting the Child Maintenance Service (CMS). This is a great opportunity for someone who enjoys working with data, building meaningful dashboards, and contributing to services that have a real positive impact on children and families.

This role has been created as part of our continued investment in modern data platforms and reporting capabilities, helping CMS make better, faster, evidence‑based decisions.

You’ll join a cross‑functional team of around 30 people, mainly based in Newcastle upon Tyne, working across data engineering, analytics, and delivery. The team uses SAS technologies alongside a new strategic Big Data stack, including Cloudera, Informatica, Power BI, and machine learning tools.

Key Responsibilities

• Develop, design, and maintain interactive dashboards and reports using Power BI.
• Manage and monitor dataset refreshes, resolving issues quickly.
• Publish and maintain reports in Power BI Service, including access management.
• Optimise report performance and data models.
• Implement and maintain coding standards.
• Raise and resolve risks and issues appropriately.
• Communicate clearly with both technical and non‑technical stakeholders.
• Actively participate in sprint ceremonies and prioritisation.
• Coach and mentor junior team members.
  
  

Experience with AWS data services such as S3 and Redshift is desirable but not essential.

Person specification

When Giving Details In Your Employment History And Personal Statement You Should Highlight Your Experience In Line With Essential Criteria Below:

• PRACTITIONER: Strong knowledge of using the following tools is required for Engineers engaging in BI or MI development: Power BI.
• PRACTITIONER: Experience of using SQL (i.e. Hive, Postgres, Impala etc.) and Python (PySpark) beyond intermediate level.
• PRACTITIONER: Able to take the right actions to investigate and resolve complex technical and data-related issues.
• WORKING: Experience of managing relationships through active and reactive communication at a working level, being clear concise in explaining issues to non-specialists.
• WORKING: Good understanding of the core technical concepts related to the Data Engineering role and behaviours and apply them across team by mentoring and coaching junior staff.
  
  

If you would like to learn more about the role, please contact Mark.Harbottle@dwp.gov.uk

Alongside your salary of £44,447, Department for Work and Pensions contributes £12,876 towards you being a member of the Civil Service Defined Benefit Pension scheme. Find out what benefits a Civil Service Pension provides (opens in a new window).

We also have a broad benefits package built around your work-life balance which includes:

• Working patterns to support work/life balance such as job sharing, term-time working, flexi-time and compressed hours.

Generous annual leave – at least 25 days on entry, increasing up to 30 days over time (pro–rata for part time employees), plus 9 days public and privilege leave.

Support for financial wellbeing, including interest-free season ticket loans for travel, a cycle to work scheme and an employee discount scheme.

Health and wellbeing support including our Employee Assistance Programme for specialist advice and counselling and the opportunity to join HASSRA a first-class programme of competitions, activities and benefits for its members (subscription payable monthly).

Family friendly policies including enhanced maternity and shared parental leave pay after 1 year’s continuous service.

Funded learning and development to support progress in your role and career. This includes industry recognised qualifications and accreditations, coaching, mentoring and talent development programmes.

An inclusive and diverse environment with opportunities to join professional and interpersonal networks including Women’s Network, National Race Network, National Disability Network (THRIVE) and many more.

Hybrid Working

This role may be suitable for hybrid working, which is where an employee works part of the week in their DWP office and part of the week from home. This is a voluntary, non-contractual arrangement and your office will be your contractual place of work.

If a hybrid working arrangement is suitable for the role and for you, you will normally be required to spend a minimum of 60% of your contracted working hours from your DWP office.

If you have a disability, caring responsibilities, or other circumstances that may affect your ability to meet the minimum office attendance requirement, please discuss this with us using the contact details in this advert.

Salary Information

Pay for this role is from £44,447 to £54,813.

The maximum salary for the grade is £46,547, however a Digital Allowance of up to £8,266 per annum is available for exceptional candidates. Digital Allowance is non-salary, and non-pensionable, and is classed as a temporary allowance. It is reviewed annually where it could be retained, amended, or removed.

Our offer to successful candidates will be based on an assessment of your skills and experience as demonstrated at interview.

Existing Civil Servants who secure a new role on lateral transfer will maintain their current substantive salary.

See selection process for further details Civil Servants who gain promotion will move to the bottom of the grade pay scale or receive a 10% increase applied to their current substantive salary, whichever is greater.

Any temporary allowances that you are currently in receipt of will not form part of the calculation to determine your pay. Any allowances that are in payment will cease when you move into your new role.

Artificial intelligence

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 (opens in a new window) for more information on appropriate and inappropriate use.

Selection process details

Stage 1: Application

Your Application Will Consist Of Three Parts:

• A Personal Details application form.
• 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.
• Personal statement - up to 750 words. This statement should be used to provide examples of how you meet the essential criteria listed in the Person specification.
  
  

Further details around what this will entail are listed on the application form.

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 early September 2026. Interview dates to be confirmed.

Further Information

Find out more about Working for DWP

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.

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

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.

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

Further Information

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 DWPRecruitment.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 reasonable adjustments, terms and conditions and how we recruit visit the How we recruit page.

Feedback

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

Security

Successful candidates must undergo a basic (or equivalent) criminal record check.

Successful candidates must meet the security requirements before they can be appointed. The level of security needed is security check (opens in a new window).See our vetting charter (opens in a new window).

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

Successful candidates must undergo a basic (or equivalent) criminal record check.

Successful candidates must meet the security requirements before they can be appointed. The level of security needed is security check (opens in a new window).See our vetting charter (opens in a new window).

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) (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)

Working for the Civil Service

The Civil Service Code (opens in a new window) 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 (opens in a new window).

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.

The Civil Service Code (opens in a new window) 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 (opens in a new window).

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 (opens in a new window) and the Civil Service Diversity and Inclusion Strategy (opens in a new window).

This vacancy is part of the Great Place to Work for Veterans (opens in a new window) initiative.

The Civil Service welcomes applications from people who have recently left prison or have an unspent conviction. Read more about prison leaver recruitment (opens in new window).

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

Job Contact :

• Name : Mark Harbottle
• Email : Mark.Harbottle@dwp.gov.uk
  
  

Recruitment team

• Email : digitalrecruitment.grs@cabinetoffice.gov.uk
  
  

Further information

Appointment to the Civil Service is governed by the Civil Service Commission’s Recruitment Principles. If you feel your application has not been treated in accordance with these principles and you wish to make a complaint, you should in the first instance contact DWP by email: HR.BUSINESSASSURANCE@DWP.GOV.UK.

If you are not satisfied with the response you receive from the Department, you can contact the Civil Service Commission. Click here to visit the Civil Service Commission.