Data Engineer (Level II) – BI Developer

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.

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 [email removed]

Benefits

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

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

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 calcu