Senior Data Engineers - #1748189

London or East Kilbride - You will be required to work from this location in line with FCDO policies on Hybrid Working (minimum 60% in the office).

Job Summary

The Foreign, Commonwealth & Development Office pursues our national interests and projects the UK’s role in the world. We promote the interests of British citizens, safeguard the UK’s security, defend our values, reduce poverty and tackle global challenges with our international partners. We employ more than 17,000 staff in 179 countries and territories, across our diplomatic and development offices worldwide, which consists of 282 officially designated Posts. Our UK-based staff work in King Charles Street, London, Abercrombie House in East Kilbride and in Milton Keynes.

These roles contribute to FCDOs Data Strategy to improve insights to the business by provisioning it with reliable and trustworthy data sources and improving their delivery in a secure manner in compliance with Data regulations.

The team is primarily Azure focused but other Cloud technologies such as Oracle and Amazon Web Services (AWS) are used in FCDO. The successful candidates will build complex data pipelines (both Extract Transform and Load {ETL} and Extract Load and Transform {ELT}) in the Azure cloud platforms. You will work with structured and unstructured data, data lakes, data warehouses to service operational and analytical business needs.

Job Description

The successful candidates will:

• Work collaboratively with Enterprise Data Colleagues to develop pipelines and data product that aligns with data architecture and engineering best practice.
• Develop data assets and products that assist Power Business Intelligence (BI) colleagues to deliver reporting products to the business.
• Provide data engineering support to other data engineering teams within the FCDO as part of our collaborative and technical consultancy service.
• Provide Engineering Data pipelines in Azure primarily using Azure Data Factory and also, to develop team capability, using Databricks and other tools within the Azure Cloud environment.
• Deliver data products to a range of business domains stakeholders and to teams across the department.
• Implement data design through good Data Engineering practice, in line with data policy and standards, and align with the roadmaps that define our Enterprise Data Architecture vision and underpin our single source of the truth.
• Mentor and develop skills of more junior staff. Build the capability and confidence of individuals in the Enterprise Data Service to deliver data products across the FCDO.
• Develop a deep understanding of FCDO data and systems, working closely with the Lead Data Engineer, who supports the Data Architect to evolve FCDO's data architecture.
• Meet the demand for data products from our customers and deliver performance data products in line with good data engineering and architecture principals.
• Deliver well-designed data products that help the FCDO realise the goals defined in our Data Strategy, to value through correct, trusted and valuable data, information and knowledge to our customers.
  
  

The Successful Candidates Will

• Work collaboratively with Enterprise Data Colleagues to develop pipelines and data product that aligns with data architecture and engineering best practice.
• Develop data assets and products that assist Power Business Intelligence (BI) colleagues to deliver reporting products to the business.
• Provide data engineering support to other data engineering teams within the FCDO as part of our collaborative and technical consultancy service.
• Provide Engineering Data pipelines in Azure primarily using Azure Data Factory and also, to develop team capability, using Databricks and other tools within the Azure Cloud environment.
• Deliver data products to a range of business domains stakeholders and to teams across the department.
• Implement data design through good Data Engineering practice, in line with data policy and standards, and align with the roadmaps that define our Enterprise Data Architecture vision and underpin our single source of the truth.
• Mentor and develop skills of more junior staff. Build the capability and confidence of individuals in the Enterprise Data Service to deliver data products across the FCDO.
• Develop a deep understanding of FCDO data and systems, working closely with the Lead Data Engineer, who supports the Data Architect to evolve FCDO's data architecture.
• Meet the demand for data products from our customers and deliver performance data products in line with good data engineering and architecture principals.
• Deliver well-designed data products that help the FCDO realise the goals defined in our Data Strategy, to value through correct, trusted and valuable data, information and knowledge to our customers.
  
  

Person specification

It is essential in your application that you provide evidence and proven examples in each of the following Minimum Criteria, the Behaviours and the Technical question as far as you are able to do so. These responses will be further developed and discussed with those candidates invited for interview.

You must be a British Citizen at the time of application and, if invited to interview, you will need to bring proof of identity (British Passport/Driving Licence etc.) with you.

This role requires you to attain Developed Vetting (DV) security clearance.

For more information about this process, click here. Attaining DV will require you to have been resident in the UK for five of the last ten years. At least one year of this must have been a consecutive twelve-month period. Serving overseas with HM Forces, in some other official capacity as a representative of His Majesty’s Government or having lived overseas as a result of your parents’ or partner’s Government employment counts as UK residency for the purposes of security clearances.

Minimum Criteria

Demonstratable track record of delivering the following Technical skills from the Senior Date Engineer Government Digital Data Professional role:

Communicating between the technical and non-technical, Working level - you can:

• communicate effectively with technical and non-technical stakeholders
• support and host discussions within a multidisciplinary team, with potentially difficult dynamics
• be an advocate for the team externally
• manage differing stakeholder perspectives
  
  

Data Development Process, Practitioner Level - You Can

• design, build, and test data products that are complex or large scale
• build teams to complete data integration services
  
  

Data Innovation, Working Level - You Can

• Understand the impact on the organisation of emerging trends in data tools, analysis techniques and data usage
  
  

Data Integration Design, Practitioner Level - You Can

• Select and implement the appropriate technologies to deliver resilient, scalable and future-proofed data solutions
  
  

Data Modelling, Practitioner Level - You Can

• Produce relevant data models across multiple subject areas
• Explain which models to use for which purpose
• Understand industry-recognised data modelling patterns and standards, and when to apply them
• Compare and align different data models
• Knowledge of Microsoft data engineering toolsets specifically Azure Data Factory, however all relevant data experiences is valuable and will be considered.
• Understanding of relational data models and/or cloud data warehouses.
  
  

Behaviours

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

• Working Together
• Communicating and Influencing
• Changing and Improving
  
  

We only ask for evidence of these behaviours on your application form:

• Working Together
  
  

Technical skills

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

• Data development process - Practitioner Level
• Data modelling - Practitioner Level
• Communicating between the technical and non-technical - Working level
• Data Innovation -Working level
• Data integration design -Practitioner level
• Presentation
  
  

We only ask for evidence of these technical skills on your application form:

• Data development process - Practitioner Level
• Data modelling - Practitioner Level
  
  

Alongside your salary of £44,500, Foreign, Commonwealth & Development Office contributes £12,891 towards you being a member of the Civil Service Defined Benefit Pension scheme. Find out what benefits a Civil Service Pension provides.

• A Civil Service Pension.
• 25 days Annual Leave per annum.
• 9 days Public and Privilege holidays per annum.
• Learning and Development tailored to your role.
  
  

See the attached candidate pack.

Selection process details

This vacancy is using Success Profiles (opens in a new window), and will assess your Behaviours, Experience and Technical skills.

Please see the attached candidate pack for the selection process details.

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 [email protected] 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.

Further Information

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

Any move to FCDO 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

New entrants are expected to join on the minimum of the pay band.

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 you are experiencing accessibility problems reading the Candidate Pack, such as through screen reader software, please contact our Team via [email protected] and we will share a Word version of this.

The Civil Service values honesty and integrity and expects all candidates to abide by these principles. The evidence you provide in your application must relate to your own experiences. If there is any evidence of plagiarism, including presenting the ideas and experience of others as your own, your application will be withdrawn.

If successful and transferring from another Government Department a criminal record check may be carried out.

In order to process applications without delay, we will be sending a Criminal Record Check to Disclosure and Barring Service or Disclosure Scotland 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 [email protected] stating the job reference number in the subject heading.

For further information on the Disclosure Scotland confidential checking service telephone: the Disclosure Scotland Helpline on 0870 609 6006 and ask to speak to the operations manager in confidence, or email [email protected]

This role is full time only. Applicants who wish to work an alternative pattern are welcome to apply however your preferred working pattern may not be available and you should discuss this with the vacancy holder before applying.

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

This vacancy is using Success Profiles (opens in a new window), and will assess your Behaviours, Experience and Technical skills.

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 developed vetting (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 criminal record check.

Successful candidates must meet the security requirements before they can be appointed. The level of security needed is developed vetting (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

Open to UK nationals only.

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 : FCDO Recruitment Team
• Email : [email protected]
  
  

Recruitment team

• Email : [email protected]
  
  

Further information

The FCDO’s recruitment processes are underpinned by the principle of selection for appointment on merit, on the basis of fair and open competition, as outlined in the Civil Service Commission Recruitment Principles. If you feel your application has not been treated in accordance with the Recruitment Principles and you wish to make a complaint, you should, in the first instance, contact [email protected]. If you are not satisfied with the response you receive from the FCDO, you can contact the Office of the Civil Service Commissioners.