Department for Work and Pensions
Data Engineer
Job Location
Manchester, United Kingdom
Job Description
Youll join the Integrated Risk and Intelligence Service (IRIS) team which is a collaboration between DWP Digital, Counter Fraud, Compliance and Debt and Cyber Resilience Centre. IRIS is central to DWPs Fraud and Error Strategy and is radically transforming how we detect and prevent fraud and error in the welfare system.
Youll play a vital role in delivering innovative and insightful data products via Agile ways of working in a hybrid cloud environment. Integrating a variety of source data, youll use sound judgement and available guidance to understand the best approach, ensuring that appropriate data quality, integrity and alerting is built into all solutions. This will involve conducting proof of concept and discovery work and evaluating proposed changes that might impact data performance, models or reports.
The successful candidate will also manage, coach and mentor more junior colleagues, helping to build data engineering knowledge and capability within the team.
Working closely with stakeholders to develop and maintain robust data products and services, our team support the continuous improvement of data engineering standards and engage with stakeholders at all stages of the data engineering lifecycle. Your main responsibilities will include:
DWP Digital is a great place to work, learn and grow your career. We provide comprehensive training and a collaborative environment that encourages continuous professional development.
We care about our employees and can offer you an environment that is family-friendly, supportive and inclusive in an organisation with real social purpose.
Person specification
When giving details in your employment history you should highlight your experience in line with essential criteria below:
If you would like to learn more about the role, please contact felicity.smith@dwp.gov.uk
Technical skills
We'll assess you against these technical skills during the selection process:
Benefits
Alongside your salary, the Department for Work and Pensions contributes 28.97% towards you being a member of the Civil Service Defined Benefit Pension scheme. Find out what benefits a Civil Service Pension provides.
We also have a broad benefits package built around your work-life balance which includes:
This job 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. The number of days that anyone will be able to work at home will be determined primarily by business need but personal circumstances and other relevant circumstances will also be taken into account. If you are successful, any opportunities for hybrid working, including whether a hybrid working arrangement is suitable for you, will be discussed with you prior to you taking up your post.
Salary Information
National Pay for this role is from 40,201 to 43,347.
The maximum salary for the grade is 43,347, however a Digital Allowance of up to 15,000 per annum is available for exceptional candidates, based on our assessment of your skills and experience.
London Pay for this role is from 45,724 to 47,986.
The maximum salary for the grade is 47,986, however a Digital Allowance of up to 10,371 per annum is available for exceptional candidates, based on our assessment of your skills and experience.
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 should maintain their current salary.
Existing Civil Servants who gain promotion may move to the bottom of the next grade pay scale or 10% increase in salary whichever would be the greater.
Things you need to know
Selection process details
This vacancy is using Success Profiles (opens in a new window) , and will assess your Experience and Technical skills.
Stage 1: Application
Your application will consist of three parts:
1. A Personal Details application form.
2. Your employment history detailing your responsibilities, skills, accomplishments, plus your qualifications and relevant training. Please copy this information into the box field provided. When giving details in your employment history you should highlight your experience in line with essential criteria listed in the Person Specification.
3. Technical statement (up to 250 words):
An initial sift will be conducted using the technical statement (Technical Breadth). Candidates who pass the initial sift will be progressed to a full sift. The sift panel will use the information in your employment history to assess your experience, skills and knowledge against the essential criteria above.
Important Information
Stage 2: Interview
If youre 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.
To help you prepare and settle into the interview you will be sent the interview questions in advance of the interview, at least 5 days prior to your interview. These questions should be treated as confidential and should not be shared. The interview panel may ask you other questions which will not be shared in advance, including follow-up questions, and those about your experience and abilities. Candidates may be asked further probing questions if their response is deemed to require further information to determine suitability for the role.
Candidates are strongly encouraged to secure their interview slot promptly to ensure fairness in preparation time with the questions provided in advance.
Sift and interview dates to be confirmed.
Further information
Find out more about Working for DWP
For Hints and Tips on completing your application visit Applying for jobs at DWP Digital.
A reserve list may be held for a period of 6 months from which further appointments can be made.
Reserve list candidates will be posted in merit order by location.
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. Applications will be screened and if evidence of plagiarism or copying examples/answers from other sources is found, your application will be withdrawn. Internal DWP candidates may also face disciplinary action.
Security Clearance Requirement
You must meet the security requirements before you can be appointed. The level of security needed is security check.
For meaningful checks to be carried out, you will need to have lived in the UK for a sufficient period of time, to enable appropriate checks to be carried out and produce a result which provides the required level of assurance. Whilst a lack of UK residency in itself is not necessarily a bar to a security clearance, and expectation of UK residency may range from 3 to 5 years. Failure to meet the residency requirements needed for the role may result in the withdrawal of provisional jobs offers.
NSV
For further information on National Security Vetting please visit the following page https://www.gov.uk/government/publications/demystifying-vetting
Reasonable Adjustment
At DWP we value diversity and inclusion and actively encourage and welcome applications from everyone, including those that are underrepresented in our workforce.
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 Government Recruitment Service via DigitalRecruitment.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 youre deaf, a Language Service Professional.
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 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:
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) .
Location: Manchester, GB
Posted Date: 9/23/2024
Youll play a vital role in delivering innovative and insightful data products via Agile ways of working in a hybrid cloud environment. Integrating a variety of source data, youll use sound judgement and available guidance to understand the best approach, ensuring that appropriate data quality, integrity and alerting is built into all solutions. This will involve conducting proof of concept and discovery work and evaluating proposed changes that might impact data performance, models or reports.
The successful candidate will also manage, coach and mentor more junior colleagues, helping to build data engineering knowledge and capability within the team.
Working closely with stakeholders to develop and maintain robust data products and services, our team support the continuous improvement of data engineering standards and engage with stakeholders at all stages of the data engineering lifecycle. Your main responsibilities will include:
- Reviewing and transforming business requirements into reusable, production-ready code
- Integrating a variety of source data, using judgement and guidance to determine the appropriate approach
- Conducting proof of concept and discovery work to provide information and advice
- Playing an active role in code development activities for delivery of data transformation products
- Developing automated data ingest routines, workflows and mappings for structured and unstructured data
- Completing design specifications and technical documentation
DWP Digital is a great place to work, learn and grow your career. We provide comprehensive training and a collaborative environment that encourages continuous professional development.
We care about our employees and can offer you an environment that is family-friendly, supportive and inclusive in an organisation with real social purpose.
Person specification
When giving details in your employment history you should highlight your experience in line with essential criteria below:
- Enterprise-level experience of SQL, Shell/BASH, Linux and command line
- Enterprise-level experience in developing and enhancing efficient, scalable, automated ETL/ELT pipelines including error handling, re-start and data quality
- Experience of translating technical concepts into non-technical language
- You understand how to communicate with internal and external stakeholders and can change your style of communication to suit technical and non-technical audiences
If you would like to learn more about the role, please contact felicity.smith@dwp.gov.uk
Technical skills
We'll assess you against these technical skills during the selection process:
- Technical Breadth
Benefits
Alongside your salary, the Department for Work and Pensions contributes 28.97% towards you being a member of the Civil Service Defined Benefit Pension scheme. Find out what benefits a Civil Service Pension provides.
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.
This job 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. The number of days that anyone will be able to work at home will be determined primarily by business need but personal circumstances and other relevant circumstances will also be taken into account. If you are successful, any opportunities for hybrid working, including whether a hybrid working arrangement is suitable for you, will be discussed with you prior to you taking up your post.
Salary Information
National Pay for this role is from 40,201 to 43,347.
The maximum salary for the grade is 43,347, however a Digital Allowance of up to 15,000 per annum is available for exceptional candidates, based on our assessment of your skills and experience.
London Pay for this role is from 45,724 to 47,986.
The maximum salary for the grade is 47,986, however a Digital Allowance of up to 10,371 per annum is available for exceptional candidates, based on our assessment of your skills and experience.
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 should maintain their current salary.
Existing Civil Servants who gain promotion may move to the bottom of the next grade pay scale or 10% increase in salary whichever would be the greater.
Things you need to know
Selection process details
This vacancy is using Success Profiles (opens in a new window) , and will assess your Experience and Technical skills.
Stage 1: Application
Your application will consist of three parts:
1. A Personal Details application form.
2. Your employment history detailing your responsibilities, skills, accomplishments, plus your qualifications and relevant training. Please copy this information into the box field provided. When giving details in your employment history you should highlight your experience in line with essential criteria listed in the Person Specification.
3. Technical statement (up to 250 words):
- Technical Breadth - Please describe the most complex data engineering project you've worked on using SQL, Shell/BASH, and Linux with GitLab. What made the project complex? How did you contribute? Did you implement or consider any Entity Relationship Diagrams? Please use the STAR (Situation, Task, Action, Result) approach to structure your answer.
An initial sift will be conducted using the technical statement (Technical Breadth). Candidates who pass the initial sift will be progressed to a full sift. The sift panel will use the information in your employment history to assess your experience, skills and knowledge against the essential criteria above.
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 or technical statement contains any personal details your application will be withdrawn.
Stage 2: Interview
If youre 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.
To help you prepare and settle into the interview you will be sent the interview questions in advance of the interview, at least 5 days prior to your interview. These questions should be treated as confidential and should not be shared. The interview panel may ask you other questions which will not be shared in advance, including follow-up questions, and those about your experience and abilities. Candidates may be asked further probing questions if their response is deemed to require further information to determine suitability for the role.
Candidates are strongly encouraged to secure their interview slot promptly to ensure fairness in preparation time with the questions provided in advance.
Sift and interview dates to be confirmed.
Further information
Find out more about Working for DWP
For Hints and Tips on completing your application visit Applying for jobs at DWP Digital.
A reserve list may be held for a period of 6 months from which further appointments can be made.
Reserve list candidates will be posted in merit order by location.
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. Applications will be screened and if evidence of plagiarism or copying examples/answers from other sources is found, your application will be withdrawn. Internal DWP candidates may also face disciplinary action.
Security Clearance Requirement
You must meet the security requirements before you can be appointed. The level of security needed is security check.
For meaningful checks to be carried out, you will need to have lived in the UK for a sufficient period of time, to enable appropriate checks to be carried out and produce a result which provides the required level of assurance. Whilst a lack of UK residency in itself is not necessarily a bar to a security clearance, and expectation of UK residency may range from 3 to 5 years. Failure to meet the residency requirements needed for the role may result in the withdrawal of provisional jobs offers.
NSV
For further information on National Security Vetting please visit the following page https://www.gov.uk/government/publications/demystifying-vetting
Reasonable Adjustment
At DWP we value diversity and inclusion and actively encourage and welcome applications from everyone, including those that are underrepresented in our workforce.
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 Government Recruitment Service via DigitalRecruitment.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 youre deaf, a Language Service Professional.
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 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
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) .
Location: Manchester, GB
Posted Date: 9/23/2024
Contact Information
| Contact | Human Resources Department for Work and Pensions |
|---|