Data Engineer Level I

As a Data Engineer, you will be responsible for development and maintenance activities for the delivery of data products and services that meet customer needs to agreed timescales. You will work within the overall product development lifecycle, learning and applying agreed data architecture and data engineering principles and standards to ensure systems are fit for purpose.

You will design, build, and operate repeatable ETL data pipelines within distributed processing and cloud environments, implementing data flows that connect operational systems to analytics and business intelligence platforms. Working with senior team members, you will integrate a variety of source data, apply data modelling techniques, and contribute to metadata management and technical documentation to ensure data assets are well understood and properly governed.

You will apply your knowledge of SQL and related tooling to deliver production-ready code and data transformation processes that meet organisational standards. You will use Git and related version control tools to manage and collaborate on code effectively across the team. A key part of this role involves developing user-facing dashboards and analytical reports, working with senior colleagues to ensure these meet customer requirements and are kept up to date.

You will work as part of a multidisciplinary agile team, collaborating with data analysts, data scientists, and other technical and non-technical colleagues to understand requirements and deliver high-quality data products. You will support the growth of the team by sharing knowledge and experience, and contribute to a culture of continuous improvement across the data engineering community.

Occasional line management of apprentices or placement students may be required., * Design, build, and operate simple, repeatable ETL data pipelines within distributed processing environments and cloud platforms.

• Implement data flows to connect operational systems, supporting analytics and business intelligence and management information systems, working with senior team members.
• Review business requirements to ensure they are clear and robust, and transform requirements into reusable, production-ready code and effective data models.
• Undertake data analysis for data profiling, quality assurance, and problem resolution, communicating findings clearly to colleagues of different specialisms.
• Conduct proof of concept and discovery work to provide information, advice, and recommended courses of action within your own work area.
• Integrate a variety of source data, using judgement and guidance to determine the appropriate approach, and contribute to metadata management and documentation.
• Support the growth of the team by keeping abreast of market and industry trends and sharing knowledge and experience with colleagues., Existing Civil Servants who secure a new role on lateral transfer willmaintaintheir current substantive salary.

Existing 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 todetermineyour pay. Any allowances that are in payment will cease when you move into your new role.

Things you need to know

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., 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 .

For further information on reasonable adjustments, terms and conditions and how we recruit visit the How we recruit page.

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.

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.

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

Apply and further information

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

Are you a Data Engineer with experience in SQL-based data transformation, ETL pipeline development, and building user-facing dashboards and reports?, As a Data Engineer it would be beneficial to have experience in the following areas, however this is not essential to the role.

• Experience of data profiling and source system analysis, applying a range of profiling techniques, and communicating findings clearly to support data use across the team.
• Familiarity with Power BI for dashboard development and MI/BI reporting, including experience of Power BI development practices., * Programming And Build (Data Engineering) (WORKING) Ability to design and operate basic ETL pipelines and data transformation processes to an agreed standard.
• Data Integration Design (WORKING) Ability to support the delivery of basic data solutions in accordance with agreed organisational standards.
• Data Development Process (WORKING) Ability to create and implement simple, repeatable and reusable data or code products, including structured documentation of coding flows and processes.
• Technical (WORKING) Experience using SQL at intermediate level, with working knowledge of database principles and experience using MI/BI tooling to develop user-facing dashboards and reports.
• Data Modelling (WORKING) Ability to produce and maintain data models to meet organisational needs using industry-recognised modelling patterns.
• Metadata Management (WORKING) Experience using Git for version control to pull, push, and review merge requests across team and own code.

1. Technical statement (up to 250 words). The following statement is aligned to the required technical skill of Programming And Build (Data Engineering) (WORKING) . This statement should be used to provide example(s) of how you meet the criterion below: * Ability to design and operate basic ETL pipelines and data transformation processes to an agreed standard.

Ensure that all examples provided in your statements 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 statements, you must follow the guidelines outlined in the Artificial intelligence and recruitment guide., 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.

Alongside your salary of 38,772, Department for Work and Pensions contributes 11,232 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 23 days on entry, increasing up to 30 days over time (prorata 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 years 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 Womens 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 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.

At DWP Digital, we design and build services that make a real difference to people’s lives. As part of the UK’s largest government department, we support over 22 million people each day, from helping them find work to supporting them through some of life’s most difficult moments. Our work is central to delivering the Government’s “Get Britain Working” vision. Few organisations in the world offer the same opportunity to use technology and design thinking at this scale, with real impact.

Debt Solutions is responsible for DWP’s Debt Management, Compensation Recovery and Management Information systems. Thousands of agents and citizens use these systems to recover approximately 3 billion of debt per annum while protecting the most vulnerable in our society.

Step into a role at the cutting edge of data transformation. This is your chance to help shape the future of MI and data services as we modernise long-standing processes and build innovative solutions on our new, cloud powered MI and data platform.