Location
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).
About the job
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:
1. Work collaboratively with Enterprise Data Colleagues to develop pipelines and data product that aligns with data architecture and engineering best practice.
2. Develop data assets and products that assist Power Business Intelligence (BI) colleagues to deliver reporting products to the business.
3. Provide data engineering support to other data engineering teams within the FCDO as part of our collaborative and technical consultancy service.
4. 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.
5. Deliver data products to a range of business domains stakeholders and to teams across the department.
6. 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.
7. 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.
8. 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.
9. Meet the demand for data products from our customers and deliver performance data products in line with good data engineering and architecture principals.
10. 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:
11. communicate effectively with technical and non-technical stakeholders
12. support and host discussions within a multidisciplinary team, with potentially difficult dynamics
13. be an advocate for the team externally
14. manage differing stakeholder perspectives
Data development process, Practitioner level - you can:
15. design, build, and test data products that are complex or large scale
16. build teams to complete data integration services
Data innovation, Working level - you can:
17. Understand the impact on the organisation of emerging trends in data tools, analysis techniques and data usage
Data integration design, Practitioner level - you can:
18. Select and implement the appropriate technologies to deliver resilient, scalable and future-proofed data solutions
Data modelling, Practitioner level - you can:
19. Produce relevant data models across multiple subject areas
20. Explain which models to use for which purpose
21. Understand industry-recognised data modelling patterns and standards, and when to apply them
22. Compare and align different data models
23. Knowledge of Microsoft data engineering toolsets specifically Azure Data Factory, however all relevant data experiences is valuable and will be considered.
24. Understanding of relational data models and/ or cloud data warehouses.
Behaviours
We'll assess you against these behaviours during the selection process:
25. Working Together
26. Communicating and Influencing
27. Changing and Improving
We only ask for evidence of these behaviours on your application form:
28. Working Together
Technical skills
We'll assess you against these technical skills during the selection process:
29. Data development process - Practitioner Level
30. Data modelling - Practitioner Level
31. Communicating between the technical and non-technical - Working level
32. Data Innovation -Working level
33. Data integration design -Practitioner level
34. Presentation
We only ask for evidence of these technical skills on your application form:
35. Data development process - Practitioner Level
36. Data modelling - Practitioner Level