Data Engineer

Government Recruitment Service; Sheffield; Hybrid; GBP 40,000 - 55,000; Full time

Job summary

A UK governmental body is seeking a Data Engineer to design and implement data flows to enhance the organisation's analytics capabilities. In this role, you will develop ETL processes, support data quality improvements, and collaborate with various teams to deliver data-driven solutions. The position is available on a full-time basis with options for part-time and compressed hours. Occasional travel to hub locations may be required. Candidates should possess strong analytical skills and experience in data modeling.

Qualifications

• Experience with data modeling and ETL processes.
• Ability to design and implement data flows connecting various systems.
• Strong analytical skills for problem-solving in data analysis.

Responsibilities

• Design and build data products using various storage technologies.
• Apply data modeling concepts to create and maintain data models.
• Undertake data profiling and provide insights to support data usage.
• Support the development cycle from requirements to deployment.
• Improve data quality through methods developed with feedback.

Skills

Data modeling

ETL processes

Data profiling

Collaboration

Job description

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.

The Science, Technology, Research and Analysis (STAR) Group sits at the heart of the Home Office. The group ensures the best evidence and analysis are used to address the strategic issues facing the department. We also provide the science, technology, data, and international insights and collaboration capabilities to drive delivery.

Part of the Home Office Analysis & Insight directorate, the Performance Reporting & Analysis Unit (PRAU) provides reporting and analysis of performance for the Migration & Borders Mission and associated operational Capabilities. We support Ministers, the Executive Committee, Policy and Operational leads and other analytical functions with the management information (MI) that they need, as well as producing data for publication and other forms of external release. The Unit also provides advice and support to others in the Department on how to make best use of performance information and is leading on the transformation of MI systems and capabilities.

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

As a Data Engineer, you will identify and deliver new data sources and develop ETL processes. You will also collaborate with the Data Acquisition, Analytics and Infrastructure teams to deliver the data strategy through the design and implementation of technology systems.

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 that ensure 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

• 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.
• Undertaking data profiling and source system analysis and presenting clear insights to colleagues to support the end use of the data.
• Supporting the development of requirements from full development, test and through to deployment life-cycles, while maintaining the schedule of work.
• Supporting with the development of methods to monitor and improve data quality in source systems using feedback from the Analytics team.
• Undertaking changes to existing routines following change control procedures and then liaising with team members and other teams to communicate delivery and impact of change.
• Working with data privacy and information security staff to assure that security and privacy requirements are identified and addressed in your solutions.
• Working closely with the Data Engineering community to promote challenge from, collaborate with, and ensure an agile approach to working is being adopted.

Working Pattern

This role is available on a full-time basis with the option of compressed hours working. This role is also suitable for part-time working hours, with a minimum requirement to work 4 days per week due to business requirements.

Travel

Occasional travel to other listed hub locations on an approximately quarterly basis. Travel costs incurred for business need, will be reimbursed in line with Home Office travel policy.