Website uk-home-office-careers Home Office
About the role
The Home Office works to build a safe, fair and prosperous UK. We achieve this through our work on counter-terrorism, policing, crime, drugs policy, immigration and passports.
Home Office Digital designs, builds and develops services for the rest of the department and for government. Every year our systems support up to 3 million visa applications, checks on 100 million border crossings, up to 8 million passport applications and deliver 140 million police checks on people, vehicles and property.
Data Engineers deliver on the data analytics vision for the organisation as set by the Principal Data Engineer. You will focus on the design and implementation of numerous data flows to connect operational systems, data for analytics and Business Intelligence (BI) systems. You will identify and deliver new data sources and develop Extract, Transform, Load (ETL) processes.
You will have the opportunity to collaborate with the Data Acquisition, Analytics and Infrastructure teams to deliver the data strategy. Working alongside Senior Data Engineers and the Data Services Science community, you will support the development and delivery of resilient, scalable and future-proof data solutions.
Job description
You will support Senior Data Engineers in analysing problems and data analysis issues, looking for underlying causes and assisting in developing solutions. You will also be responsible for delivering data solutions in accordance with agreed organisational standards, ensuring services are resilient, scalable and future-proof.
You will work closely with the Data Services Science community, who will set the scope of your data engineering work through their research of user and business needs and by their designing data pipelines through writing user stories.
Key Responsibilities
Your main day to day responsibilities will include:
- Assisting in the development of new data models and ETL processes, working collaboratively with the Analytics team to build data streaming systems.
- Designing, building and testing data products based on feeds from multiple systems using a range of different storage technologies and/or access methods.
- Applying the concepts and principles of data modelling to produce, maintain and update relevant data models for specific business needs, including reverse engineering data models from a live system.
- Assisting in designing, writing, iterating and optimising code from prototype to production-ready.
- Undertaking data profiling and source system analysis and presenting clear insights to colleagues to support the end use of the data.
- Assisting in the successful delivery of completed data loads for customers, Data Analysts and Data Scientists, putting in place remedies and troubleshooting when required and assisting in the development of new data load programmes.
Working Pattern
Due to the business requirements of this role, it is only available on a full-time basis. However, compressed hours are available.
Person specification
Essential criteria
You’ll have a demonstrable passion for Data, with the following skills or some experience in:
- A numerate degree or equivalent relevant experience.
- IT programming.
- Using tools such as industry standard ETL tools, network databases and scheduling and orchestration tools.
- Effectively managing and communicating with a variety of stakeholders by translating technical concepts into non-technical language.
- Managing the development and delivery of technical products.
- Understanding of Cloud Data technologies, solutions and future Cloud Data Strategies.
- Applying data development and engineering techniques, both in theory and practice or demonstrating an aptitude to learn and apply these techniques.
The essential skills listed above are reflective of the Home Office Government Digital and Data Profession Career Framework (based on the industry standard SFIA framework).
The six technical skills for this role align to Data Engineer. Use the SFIA levels of responsibility to understand what would be expected for each technical skill listed.
Please see below the relevant six technical skills for Data Engineer:
Strategy and Architecture
• Strategy and Planning
o Innovation (INOV) – Level 2
- Advice and Guidance
o Methods and Tools (METL) – Level 2
Development and Implementation
- Data and Analytics
o Data Management (DATM) – Level 2
o Data Modelling and Design (DTAN) – Level 3
o Database Design (DBDS) – Level 2
o Data Engineering (DENG) – Level 3
Desirable criteria
Ideally, you will also have the following skills or some experience in:
- Working with Big Data tools and data stores, for example AWS or Databricks.
- Using modern / open source programming languages and tools to deliver data development and engineering products, such as SQL or Python or PySpark.
- Agile Foundation and/or ITIL v3 or v4 Foundation qualifications.
To apply for this job please visit www.civilservicejobs.service.gov.uk.