Data Engineer - Insolvency Service - HEO

Job summary

Are you a Data Engineer looking to utilise best in class cutting edge technologies to deliver data products?

Do you want to use your skills and experience to help deliver excellence for our customers and the economy, collaborating across the organisation, the Civil Service and the private sector?

Are you looking for ongoing professional development, working towards new qualifications while helping build and design modern cloud-based products to support The Insolvency Services data centric ambitions?

The Insolvency Service is a leading Government agency which plays a crucial role in providing essential services to the public and to business. The work we do is important to the proper functioning of markets, the economy in general and support for thousands of people each year who are in financial difficulty.  

Inclusive and diverse teams are important to us. We welcome and encourage applications from everyone, including groups underrepresented in our workforce. The Insolvency Service strives to ensure that the agency is a safe, inclusive and welcoming place for everybody to bring their true self to work and to help the agency to achieve its diversity objectives. We have 10 active employee network groups available to join or become an ally, these include, Carers Network, Disability & Health, FACES Network Group, Grass Roots, LGBT+, Mind Matters, No Limits, Part Time Workers, The Shed, and Women’s Network Group. 

We offer full-time, part-time, job share and flexible ways of working. We value capability, technical skills and experience and we place great emphasis on lifetime development to support our people. We encourage our employees to become more involved in areas they feel strongly about, whether it be for the benefit of the agency, though our Engagement network or in their own local communities via volunteering opportunities.  

The Insolvency Service is a great place to work, learn and grow your career! 

We are looking for enthusiastic, skilled, and adaptable people. We provide comprehensive training, a collaborative, innovative environment that encourages continuous self and professional development.

If you are looking to develop your skills, work on some of the most challenging and rewarding IT projects, shape solutions and contribute to new thinking, all with a great work life balance we would love to speak with you.

Job description

The Data Development team sits within the Analysis and Performance Team in the Strategy, Policy and Analysis Directorate and plays a vital role in the delivery of the Insolvency Service’s operations, by designing and developing modern data products to deliver value from the agency’s data assets.

 As a data engineer, you’ll work at the cutting edge of how people interact and are empowered by digital government services. Government is undergoing a digital transformation, never has the time been better to pursue your career in a sector, in a role, that truly delivers on the promise of innovation. 

Responsibilities

In this role you will:

• Recognise opportunities to re-use existing data flows.
• Contribute to the build of data streaming systems.
• Optimise the code to ensure processes perform optimally.
• Assist work on database management.
• Develop and enhance the utilisation of our Power BI deployment.

You will gain:

• Experience in designing, building and deploying efficient, scalable, automated ETL/ELT pipelines such as traditional data warehousing, modern cloud data warehousing, data lake and delta lake approaches.
• Experience of designing and developing data solutions on public cloud (Azure).
• Experience of one or more Programming Languages – e.g. SQL, Python.
• Understanding of data storage, data modelling and database technologies.
• Exposure to Continuous integration and deployment tools, such as GitHub.
• Experience in collaborating with digital and technology project teams as they design and build new operational systems and data streams.
• Experience in administering enterprise-level data services.
• Experience in working across the Analysis and Performance function to maximise the value of the agency’s data assets.

Person specification

For the 3 primary technical skills required for the role (as detailed below) candidates’ will be assessed against the DDaT role profile for Data Engineers (https://ddat-capability-framework.service.gov.uk/role/data-engineer)

The technical anchor for this role is in Data Engineering, however the role would also benefit from knowledge or experience in:

• Development of data pipelines using Azure Data Factory or Azure Synapse.
• Maintenance, monitoring and administration of Azure Enterprise Reporting platform and associated data processes.
• Supporting Data Analyst and other data specialists. Understanding their diverse needs and contributing to their work streams and technical development.

Technical skills

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

• Data Development Process
• Data Modelling
• Technical Understanding

Benefits

Alongside your salary of £34,399, Insolvency Service contributes £9,965 towards you being a member of the Civil Service Defined Benefit Pension scheme. Find out what benefits a Civil Service Pension provides.

We want you to have a good work-life balance and want to support you in all that you do, so we offer a great benefits package including: 

• Flexible working arrangements and flexi-time.
• Full time new entrants to the Civil Service and those Civil Servants on modernised terms and conditions will be entitled to 25 days leave increasing on a sliding scale to 30 days after 5 years’ service.
• In addition to this you are entitled to 8 public/bank holidays plus an additional day of privilege leave.
• Competitive maternity, paternity and parental leave.
• 5 days paid leave for learning and development.
• 5 days paid for volunteering.
• A Cycle to work scheme.
• Staff have access to an employee assistance programme, Workplace Wellness, for confidential, independent support and advice during difficult times in either their professional or personal life.
• A Civil Service Pension with an average employer contribution of at least 28.97%.

Your pension is a valuable part of your total reward package where the employer makes a significant contribution to the cost of your pension. Your contributions come out of your salary before any tax is taken. This means, if you pay tax, your take-home pay will not be reduced by the full amount of your contribution; and your pension will continue to provide valuable benefits for you and your family if you are too ill to continue to work or die before you retire. For more information, visit  www.civilservicepensionscheme.org.uk

Things you need to know

Selection process details

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

As part of the application process, you will be asked to complete a CV and technical skills. Further details around what this will entail are listed on the application form. 

Should a large number of applications be received, an initial sift may be conducted using the CV and Technical skills lead Data Development Process. Candidates who pass the initial sift may be progressed to a full sift or progressed straight to assessment/interview. 

We will test your technical skills and experience as part of the sift process, and if successful, you will be invited to a short interview where we will test your technical skills and strengths. Full details of the selection process will be made available to shortlisted candidates once the sift has been completed.

Candidates selected for interview will be requested to provide a 10-minute presentation on one of the 3 primary technical skills of their choosing.  

Expected Timeline (subject to change) 

Sift – w/c 25/11/24

Interview – w/c 9/12/24

Location - MS Teams

Further Information

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

Any move to Insolvency Service 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

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/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 Pre-EmploymentChecks.grs@cabinetoffice.gov.uk 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 Info@disclosurescotland.co.uk

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

Please note this role requires you to pass a Security Check clearance. This requires a minimum of 5 years UK residency as part of the application.

The Insolvency Service does not offer any kind of workplace sponsorship for overseas applicants.

For further information on National Security Vetting please visit the following page https://www.gov.uk/government/publications/demystifying-vetting

Transforming Workplaces

The Insolvency Service is currently delivering an exciting five-year transformation project that started in April 2022 which will define our future direction supporting a gradual migration to a Regional Centre model combined with smarter ways of working. As part of this, transforming our estate will align us with the government modernisation programmes making The Insolvency Service a great place to work.  

We are letting you know about our future plans because if you are joining the Insolvency Service and are recruited into an office over the next five years that is not one of the Regional Centres, you will be expected to move to one of the Regional Centres in the future. This move would not attract financial assistance.   

The 11 Regional Centres are : Birmingham, Cardiff, Croydon, Edinburgh, Exeter, Ipswich, Leeds, Manchester, Newcastle, Nottingham and Stratford.

Hybrid Working

Insolvency Service operates a hybrid working policy subject to business need, giving people the flexibility to choose when and where they work and collaborate with others.

Individuals are expected to work from one of the office locations stated in the advert to connect with their colleagues, as required by their role and business team needs. There is flexibility to split the working week, spending a minimum of 60% in the workplace, which includes the office, site visits, court etc.

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 insolvencyrecruitment.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.

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

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 security check (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

This job is broadly open to the following groups:

• UK nationals
• nationals of the Republic of Ireland
• nationals of Commonwealth countries who have the right to work in the UK
• nationals of the EU, Switzerland, Norway, Iceland or Liechtenstein and family members of those nationalities with settled or pre-settled status under the European Union Settlement Scheme (EUSS) (opens in a new window)
• nationals of the EU, Switzerland, Norway, Iceland or Liechtenstein and family members of those nationalities who have made a valid application for settled or pre-settled status under the European Union Settlement Scheme (EUSS)
• individuals with limited leave to remain or indefinite leave to remain who were eligible to apply for EUSS on or before 31 December 2020
• Turkish nationals, and certain family members of Turkish nationals, who have accrued the right to work in the Civil Service

Further information on nationality requirements (opens in a new window)

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.

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).