Data Solutions Designer

Department for Work and Pensions

Apply before 11:55 pm on Sunday 20th June 2021

 

Reference number

117526

Salary

£35,310 - £40,666

Grade

Senior Executive Officer

Contract type

Permanent

Business area

DWP - Digital

Type of role

Digital

Working pattern

Flexible working, Full-time, Job share, Part-time

Number of posts

1

Location

Newcastle-upon-Tyne

About the job

Summary

You will be working as part of the Children Data Tribe within DWP Digital Group function. The team designs, develops and maintains data solutions and products for the Child Maintenance Group (CMG) across multiple technologies, including Big Data, SAS and Oracle. The team consists of 25 people, based mainly in Newcastle, split between Agile delivery squads and cross functional specialisms.

You will specifically be a member of the Agile delivery squad for the Children Analytics Data Service (ChADS); a new strategic data solution in development for CMG that is based on Big Data technologies (Cloudera, Informatica and Qlik Sense) and aligned to the DWP strategic technology vision by using open source and cloud based technologies. The successful delivery of ChADS is seen as a key enabler in CMG delivering a quality service to customers and to Ministers.

Job description

As a Data Engineer (Data Solutions Designer) within the Data Team, you will:

• Be a proactive member of an Agile delivery squad;

• Translate business requirements to ensure they are clear and robust, and can be transformed into reusable production ready code and / or effective data models;

• Shape solutions in a fit for purpose way; following the agreed principles and contribute to the overall Data Engineer Development lifecycle;

• Perform data profiling and quality measurements;

• Support Quality Assurance colleagues and Data Managers responsible for the day to day testing and live running of data products and services;

• Identify, manage and resolve issues preventing the delivery or continuous development of products;

• Collaborate across teams and liaise with Senior Data Engineers and Technical Architects to investigate technical solutions;

• Responsible for maintaining the support and implementation of continuous improvement to Data Engineering standards;

• Supporting the growth of the team, by keeping abreast of market and industry trends, and sharing knowledge and experience with the rest of the team.

Responsibilities

Your responsibilities will include but are not restricted to, the following:

• Design exploitation solutions from multiple sources of structured data;

• Interpreting complex data models and associated metadata to understand what data is available, its meaning and its fit for the product being designed;

• Undertake structured data investigations using data analysis and data visualisation techniques to establish evidence base for best use of available data;

• Develop data solutions that are performant, scalable and production ready;

• Ensure the stability, robustness and resilience of the products you design and build, and are in a position to effect changes to those products where necessary.

ESSENTIAL CRITERIA

The ideal candidate for this role will be able to demonstrate the following essential criteria:

Experience of:

• Developing data solutions on Relational Database Management Systems or Big Data platforms (Hadoop Distributions);

• Utilising modern programming languages and databases to enable analytics including one or more of Hive SQL, SQL, Python;

• Data engineering concepts and tools, covering ingestion, transformation and storage, preferably in a big data environment;

• Principles and design concepts with ETL toolsets.

Behaviours

We'll assess you against these behaviours during the selection process:

  • Making Effective Decisions
  • Managing a Quality Service

Technical skills

We'll assess you against these technical skills during the selection process:

  • Big Data Concepts
  • Creating technical requirements

Benefits

• Learning and development tailored to your role
• An environment with flexible working options
• A culture encouraging inclusion and diversity
• An employer pension contribution of up to 27%
• A generous annual leave allowance

Salary Information

Salary for this role is from £35,310 -£40,666.

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. Only in very few circumstances (where there have been exceptional skills demonstrated which are in limited supply for example) may existing Civil Servants be able to negotiate their starting salary if the role has been advertised externally, prior to accepting the post.

This role will be based in the Newcastle corporate hub location.

The Department is committed to promoting flexible ways of working, whilst enabling the business to operate at maximum efficiency and will expect colleagues to work from a blend of locations, including some time working at home, as required. The corporate hub location will be the designated place of work and any remote or home working arrangement does not constitute a change to your designated place of work or contractual Terms and Conditions.

Things you need to know

Security

Successful candidates must pass a disclosure and barring security check.
Successful candidates must meet the security requirements before they can be appointed. The level of security needed is security check.

See our vetting charter.
People working with government assets must complete basic personnel security standard checks.

Selection process details

This vacancy is using Success Profiles, and will assess your Behaviours, Experience and Technical skills.
Stage 1: Application & Sift

As part of the application process you will be asked to complete a CV & personal statement. Further details around what this will entail are listed in the advert.

All applications will be assessed and sifted based on the essential criteria in the advert, using the information you provide in your completed application form.

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

When giving details of your employment history, you should therefore include details of the work and projects that you have been involved in.

Applications must include:

1. A completed Personal Details application form.

2. A curriculum vitae* including education, professional qualifications and full employment history, giving details of key achievements relevant to the skills and experience outlined in this job description.

3. A personal statement outlining how you meet the essential criteria as detailed in the responsibilities section, in no more than 1250 words.

A NOTE ON ANONYMISATION

*Due to DWP’s use of anonymised recruitment practices it is not possible for applicants to upload/attach a CV; any information that you would customarily share on a CV should therefore be entered onto the application form. Please ensure you provide sufficient information to enable the sift panel to make an informed judgement about your suitability for this role.

IMPORTANT INFORMATION

Please include all other information that you would customarily provide when presenting a CV/Personal statement, as the sift panel use this information to assess your application.

DWP operates an anonymised recruitment process. When entering information relating to your employment history you will be asked to remove any personal details that could be used to identify you. This relates to name and contact details which might usually appear on your CV/Personal statement. Failure to do so will result in your application being withdrawn.

Stage 2 – Video Interview

Unless you are otherwise informed, the final stage of the process will be a video interview via Microsoft Teams where you will be assessed against the Behaviours, Technical Skills and Experience detailed in the advert.

Throughout the whole recruitment process – application and interview – the accuracy and clarity of your communication will be assessed.

Sift and Interview Information

Applications will be sifted at regular intervals from the date the posts are advertised, so please apply as soon as you can, do not wait until the end of the campaign.

Interviews will take place from 28th June.

Other information:

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

Successful candidates must meet the security requirements before they can be appointed. The level of security needed is security check.

For meaningful checks to be carried out individuals 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.

Reasonable adjustment
If a person with disabilities is put at a substantial disadvantage compared to a non-disabled person, we have a duty to make reasonable changes to our processes.

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 “Assistance required” 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 successful and transferring from another Government Department a criminal record check may be carried out.

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.

In order 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 circumstance 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.

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 https://www.childcarechoices.gov.uk.

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

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

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

Nationality requirements

This job is broadly open to the following groups:

  • UK nationals
  • nationals of Commonwealth countries who have the right to work in the UK
  • nationals of the Republic of Ireland
  • nationals from the EU, EEA or Switzerland with (or eligible for) status under the European Union Settlement Scheme (EUSS)
  • relevant EU, EEA, Swiss or Turkish nationals working in the Civil Service
  • relevant EU, EEA, Swiss or Turkish nationals who have built up the right to work in the Civil Service
  • certain family members of the relevant EU, EEA, Swiss or Turkish nationals
Further information on nationality requirements

Working for the Civil Service

The Civil Service Code 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.
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.

Apply and further information

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 :  Caicy Sandford
Email :  caicy.sandford@dwp.gov.uk
 
Recruitment team :
Email :  digitalrecruitment.grs@cabinetoffice.gov.uk

Further information

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 here to visit Civil Service Commission

Share this page