Apply Now
Details
Reference number
Salary
Job grade
Contract type
Business area
Type of role
Digital
Engineering
Working pattern
Number of jobs available
Contents
Location
About the job
Job summary
The Home Office is the lead government Department for immigration and passports, crime, police, fire, and counter terrorism significant issues which are at the heart of the agenda of HM Government. The challenges and opportunities the Department faces are significant and rapidly changing in the global environment in which we operate. Strong analytical advice is needed to navigate these challenges, and the Home Office has a reputation for putting analysis at the heart of decision-making.
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.
PRAU is geographically spread across four primary locations (London, Liverpool, and Sheffield and Croydon), with most staff working in line with the Departments hybrid working arrangements which would see the post holder spend 40% of their week in the office, with the remainder working from home. Candidates will need to agree a base location of either Croydon, Sheffield or Liverpool with a requirement for periodic attendance at other Home Office locations.
Job description
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.
Responsibilities
Your main day-to-day responsibilities will be:
Assisting in the development of new data models and ETL processes.
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 Engineers and Data Scientists, putting in place remedies and troubleshooting when required and assisting in the development of new data load programmes.
Supporting the development of requirements from full development, test and through to deployment life-cycles, while maintaining the schedule of work.
Designing, coding, testing, correcting and documenting simple programs or scripts under the direction of others.
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. You will also mentor new Data Engineers and Associate Data Engineers.
Person specification
Essential criteria
Youll have a demonstrable passion for Data, with the following skills or some experience in:
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 Cloud Data technologies, solutions and future Cloud Data Strategies.
Applying data development / engineering techniques both in theory and practice or a strong aptitude to learn.
A numerate degree or equivalent experience.
Desirable criteria
Ideally, you will also have the following skills or some experience in:
Working with Big Data tools and data stores.
Using modern / open-source programming languages and tools including to deliver data development/engineering products.
Some experience of existing Home Office and OGD data sets (e.g. CID, CRS, API etc.).
Experience with T-SQL based development will be an advantage.
Experience of working with Azure Synapse will be an advantage.
An Agile Foundation.
ITIL v3 or v4 Foundation.
Recruitment and Retention Allowance (RRA)
This post is eligible for a DDaT RRA. Successful candidates with exceptional skills and experience may apply for a RRA between £2,500 – £4,000. This allowance is subject to an initial review within six months of taking up the post and thereafter an annual review in-line with departmental priorities and could be reduced or withdrawn at any time.
Behaviours
We’ll assess you against these behaviours during the selection process:
We only ask for evidence of these behaviours on your application form:
- Changing and Improving
Technical skills
We’ll assess you against these technical skills during the selection process:
- Delivery and Operation – Service Operation o Database Administration DBAD Level 2
- Development and Implementation – Systems Development o Data Modelling and Design DTAN Level 3 o Database design DBDS Level 2
- Strategy and Architecture – Business Strategy and Planning – Innovation INOV Level 3 Technical Strategy and Planning – Data Management DATM Level 2 – Methods and Tools METL Level 2
Benefits
- Learning and development tailored to your role
- An environment with flexible working options
- A culture encouraging inclusion and diversity
- A Civil Service pension with an average employer contribution of 27%
Things you need to know
Selection process details
After submission of the first stage of your application you will be invited to complete a Civil Service Numerical Test. If you successfully pass the test, you will be invited to complete the final stage of the application.
Please complete the online tests as soon as possible (within 24-48 hours is recommended), the closing date for the tests is 23:55 on 20th November 2023. If you fail to complete the online test before the deadline your application will be withdrawn.
Guidance for the test will be available when you are invited to take the test. The tests are administered online and accessed via the Civil Service Jobs website.
This gives us the best possible chance of finding the right person for the job, drives up performance and improves diversity and inclusivity.
As part of the application process, you will be asked to complete:
A CV detailing job history/qualifications/skills
A statement of suitability (personal statement) (maximum 500 words)
Provide evidence of the lead behaviour Changing and Improving (250 words maximum)
Further details around what this will entail are listed on the application form.
The statement of suitability should be aligned to demonstrate your skills and experience for the role and how you meet the essential criteria as detailed in the job description.
The sift will be held on the CV, behaviour and the statement of suitability (personal statement).
However, if a large number of applications are received, the initial sift will be conducted on the statement of suitability. Candidates who pass the initial sift will then be progressed to a full sift where the CV and behaviour will be scored.
If you are successful at sift stage, you will be invited to an interview which will be a blended approach of technical and behaviour-based questions on all those listed in the advert. The technical element will assess your Technical Skills as per SFIA Framework (SFIA 7 Framework (sfia-online.org))
Sift and Interview dates
Sift is expected to take place week commencing 20th November 2023.
Interviews are expected to take place week commencing 11th December 2023.
We will try to meet the dates set out in the advert, however on occasions these dates may change.
Interviews will be carried out via video. Candidates will be required to have access to:
A laptop (personal or work) with a working webcam
Good internet connection
Microsoft Teams
PLEASE NOTE: Due to time constraints we may not be able to offer alternative interview date(s). It is therefore expected that candidates who are successful at sift stage will make themselves available during the above time frame given.
A reserve list of successful candidates will be kept for 12 months. Should another role or similar role become available within that period you may be offered this position.
Further information
For meaningful checks to be carried out, individuals 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. You should normally have been resident in the United Kingdom for the last 3 years if the role requires CTC clearance, 5 years for SC clearance and 10 years for DV. A lack of UK residency in itself is not necessarily a bar to a security clearance and applicants should contact the Vacancy Holder/Recruiting Manager listed in the advert for further advice.
Every day, Home Office civil servants do brilliant work to develop and deliver policies and services that affect the lives of people across the country and beyond. To do this effectively and fairly, the Home Office is committed to representing modern Britain in all its diversity, and creating a welcoming, inclusive workplace where all our people are able to bring their whole selves to work and perform at their best.
We are flexible, skilled, professional and diverse. We work to recruit and retain disabled staff and area Disability Confident Leader. We are proud to be one of the most ethnically diverse departments in the civil service. We are a Social Mobility Foundation top 75 employer.
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.
For further information please see the attached notes for candidates which must be read before making an application.
Existing Civil Servants should note that some of the Home Office terms and conditions of employment have changed. It is the candidates responsibility to ensure they are aware of the Terms and Conditions they will adopt should they be successful in application and should refer to the notes for candidates for further details.
Transfer Terms: Voluntary.
If you are invited to an interview you will be required to bring a range of documentation for the purposes of establishing identity and to aid any pre-employment checks.
Please see the attached list of Home Office acceptable ID documents.
Any move to the Home Office 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
Reasonable Adjustments
If a person with disabilities is 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 HOrecruitment.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 you are experiencing accessibility problems with any attachments on this advert, please contact the email address in the Contact point for applicants section.
Feedback
Feedback will only be provided if you attend an interview or assessment.
Security
Nationality requirements
Working for the Civil Service
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).
Apply and further information
You may want to save a copy for your records.
Contact point for applicants
Job contact :
- Name : Home Office Resourcing Centre
- Email : HORCCampaignTeamCorporateEnablers@homeoffice.gov.uk
Recruitment team
- Email : HOrecruitment.grs@cabinetoffice.gov.uk
Further information
