Lead Data Engineer

Details
Reference number

433704

Salary

£60,300 - £70,730

New entrants to the Civil Service will start their role on the pay range minimum:

National: £60,300 band minimum

London: £64,300 band minimum

You may be eligible for an additional non-pensionable allowance, pending a Capability and Skills Assessment, with a value of up to £20,100 (location dependent).

A Civil Service Pension with an employer contribution of 28.97%

GBP

Job grade

Grade 7

Contract type

Permanent

Business area

HO - Digital Data and Technology

Type of role

Digital

Information Technology

Working pattern

Flexible working, Full-time, Compressed hours

Number of jobs available

1

Contents

• Location
• About the job
• Benefits
• Things you need to know
• Apply and further information

Location

Croydon, Liverpool, Manchester, Sheffield

About the job
Job summary

Oracle EPM sits within the Enablers Portfolio, part of DDaT, which leads the development of integrated data products to support business intelligence, reporting, and data science across the Home Office. The portfolio is growing rapidly, with over 300 colleagues delivering services across multiple functions.

Oracle EPM supports enterprise performance management through robust data pipelines and integrations across modules such as Planning, FCCS, and PCMCS. It plays a key role in enabling strategic decision-making and financial planning, working in close alignment with the Metis Oracle Product and the wider data strategy. The product is delivered in collaboration with Data Acquisition, Analytics, and Infrastructure teams to ensure high-quality, resilient data services.

This role is not suitable for part-time working due to business requirements and the nature of the role this is only available for full-time.

Job description

As a Lead Data Engineer specialising in Oracle EPM, you will bring a passion to deliver the data engineering vision aligned with the enterprise performance management strategy, as set by the EPM Product Manager. Your focus will be on designing and implementing robust data pipelines and integrations that support Oracle EPM modules.

You will lead the development of data flows between Oracle EPM, ERP systems, and analytics platforms, ensuring high-quality, timely, and secure data delivery. This includes identifying and onboarding new data sources, developing ETL/ELT processes, and optimising data models to support planning, forecasting, and reporting needs.

You will collaborate closely with the EPM functional team, Data Acquisition, Analytics, and Infrastructure teams, you will ensure the successful execution of the data strategy. You will also work with Principal Data Engineers, Data Architects, EPM Solution Architects, and Database Administrators to define and enforce data governance, integration standards, and best practices across the Oracle EPM landscape.

What you'll do

As a lead Data Engineer, you will showcase a true passion for data and exhibit expertise in the following areas:

• Managing and integrating data sources across Oracle EPM and connected systems (e.g., ERP, HCM, FDI, data warehouses) to improve data quality, consistency, and readiness for planning, forecasting, and reporting.
• Designing and developing EPM-specific data models and ETL/ELT processes, working closely with the Analytics and Finance teams to map and transform data into structures that support Oracle EPM modules such as Planning, FCCS, and PCMCS.
• Engage with key stakeholders across Finance, IT, and business units to understand performance management needs, manage expectations, communicate progress, and foster a service-oriented approach to data delivery and support.
• Oversee the performance of third-party vendors and internal data teams, enhancing delivery capability, and creating a roadmap that balances immediate EPM reporting needs with long-term data platform investments.
• Optimise data lifecycle processes including data availability, capacity planning, and archiving strategies, while continuously improving the efficiency and reliability of data ingestion into Oracle EPM.
• Line managing and mentoring team members, supporting their professional development and fostering a culture of continuous improvement and technical excellence within the Oracle EPM data engineering function

Watch this video to hear from members of the team talking about the projects they work on and their experience of working here.

Person specification

Essential criteria

As a Lead Data Engineer you'll have a demonstrable passion for Data, with the following skills or some experience in:

• Oracle EPM with at least 5 full project lifecycle deliveries.
• Extensive project experience across EPBCS, EDM, NR, FCCS, PCMCS, ARCS, and Predictive Cash Forecasting, with a proven track record of aligning implementations to HM Treasury guidelines, public sector accounting standards, and regulatory frameworks including Managing Public Money, the HMT Green Book, Cabinet Office spend controls, and departmental data governance policies.
• The ability to lead and influence finance teams by leveraging deep knowledge of planning and financial processes, identifying pain points, and driving continuous improvement through practical, strategic solutions.
• Strong stakeholder engagement skills, with the ability to presenting complex data engineering concepts and recommendations clearly to both technical and non-technical audiences, including senior finance and IT stakeholders.
• Leading the adoption of cloud-based data technologies and strategies, particularly within Oracle Cloud Infrastructure (OCI), including services like Autonomous Data Warehouse, Oracle Data Integration, EPM Automate and be proficient in rest API and coding in MDX, Calc Script and Groovy.
• Effectively manage complex multi-supplier and support environments, ensuring effective coordination, service integration, and accountability across internal teams and external partners.

SFIA capability framework

Skills for the Information Age (SFIA) is the technical framework that sets the standard capability and development of all Data Engineering levels in the Home Office. This is a link to the capability framework: All skills A - Z English (sfia-)

We use set SFIA technical skills to form our interview questions and we will assess you against these technical skills during the selection process.

SFIA levels of responsibility – Use the SFIA Levels of responsibility to understand what would be expected for each Technical Skill listed below.

SFIA Technical Skills

The essential technical skills listed above are reflective of the Home Office Government Digital and Data Profession Career Framework. Please see below for the relevant skills required for your role.

Technical skills

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

• Strategy and Architecture Strategy and Planning Innovation (INOV) – Level 3
• Advice and Guidance Methods and Tools (METL) – Level 4
• Development and Implementation Data and Analytics Data Management (DATM) – Level 4
• Data Modelling and Design (DTAN) – Level 4
• Database Design (DBDS) – Level 3
• Data Engineering (DENG) – Level 4

Benefits

Alongside your salary of £60,300, Home Office contributes £17,468 towards you being a member of the Civil Service Defined Benefit Pension scheme. Find out what benefits a Civil Service Pension provides.

You will also have access to the same benefits available to all civil servants in the Home Office:

• A highly competitive pension with an employer contribution of 28.97%.
• 25 days annual leave on appointment rising 1 day per year up to 30 days, plus 8 days public holidays and 1 day for the King's Birthday.
• Flexible working options to enable you to achieve the work life balance that is right for you including; Full time, part-time, flexi time, compressed hours and job sharing.
• A hybrid working model of a minimum 60% of your contracted hours in the workplace and 40% remote.
• Training and development opportunities tailored to your role, including access to technical and professional accreditations.
• Access to funded qualifications (subject to approval).
• A capability allowance reviewed annually.
• A culture encouraging inclusion and diversity.
• Enhanced parental leave schemes.
• Annual performance-based bonus and recognition awards.

This link is to a short guide to employee benefits: Benefits - Home Office Careers

Things you need to know
Selection process details

This vacancy is using Success Profiles , and will assess your Experience and Technical skills.

As part of the application process, you will be asked to complete:

• A CV, detailing job history, relevant qualifications and skills.
• A Personal Statement of suitability (Max 1000 word limit).

Further details around what this will entail are listed on the application form.

Please note your CV and personal statement should include all relevant experience that relates to our essential skills criteria listed in the advert and role description and Use STAR format in your examples.

Remove information that identifies you (for example your name, age or place of education) so that you will be judged on merit alone and not your personal background, circumstances, race or gender.

(Do NOT include e-mail addresses or links to online profiles, resumés, or prior work, either personal or business. Active links or e-mail addresses will result in your application being rejected).

Please ensure that all examples provided in your application are taken directly from your own experience and that you describe the examples in your own words. All applications are screened for plagiarism, copying, and generating of examples/ answers from internet sources including Artificial intelligence. If detected, the application may be withdrawn from the process.

Further action, including disciplinary action, may be considered in such cases involving civil servants. Providing false or misleading information would be contrary to the core values of honesty and integrity expected of all civil servants.

Sift Stage

The sift will be held on the CV and Personal Statement. Please read the Essential skills for this position carefully. We will only consider those who meet the listed requirements.

If there is a high volume of applications, a sift may be conducted based on the Personal Statement alone.

Interview Stage

Candidates reaching the required standard will then be invited to attend a final interview. The interview will assess your Technical Skills (SFIA Framework) and experience using technical and experience-based questions.

We often have similar roles available at different grades. If a candidate is suitable for a similar role, we may offer the candidate that role without the need to go through a further selection process providing the role has the same technical and essential skills.

Sift and interview dates

Sifts will be conducted – from 14th November 2025.

The sift will be held on the CV and the Personal Statement of suitability.

Interviews will be held – week commencing 24th November 2025.

Interviews will be conducted remotely. Candidates will be required to have access to:

• A laptop (personal or work) with a working webcam.
• Good internet connection
• Microsoft Teams

We will try to meet the dates set out in the advert. There may be occasions when these dates will change. You will be provided with sufficient notice of the confirmed dates.

Further Information

We value diversity and inclusion and welcome applications from the widest diversity of backgrounds, cultures, and experiences. We particularly encourage applications from women, people with disabilities and LGBT+ as they are currently under-represented in the Home Office at this grade level. Appointments will be made on merit on the basis of fair and open competition.

Where business needs allow, some roles may be suitable for a combination of office and home-based working. Where this is the case, employees will be expected to spend a minimum of 60% of their working time in the office. Applicants can raise any queries to the email address at the bottom of the advert.

Please read the Essential skills for this position carefully. We will only consider those who meet the listed requirement.

If you have previously made an unsuccessful application for a role with the same essential skills and are not able to demonstrate how you have developed these skills since your last application please reconsider applying as your application is unlikely to be successful.

Reserve list

A reserve list of successful candidates will be kept for 12 months. Should another role become available within that period you may be offered this position.

UK residency and security requirements

You need to have lived in the UK for the past 5 years. This is because this post requires the successful candidate to have Security Check (SC) clearance and 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. These checks will only take place after the job offer has been accepted.

You should normally have been resident in the United Kingdom for the last 5 years for SC clearance.

Visa Sponsorship

We are unable to sponsor any individuals via Skilled Worker Sponsorship / Tier 2 (General) work visas as we do not hold a UK Visa & Immigration (UKVI) Skilled Worker License.

Capability Allowance

The advertised role is part of the Home Office Government Digital and Data Profession. This role has access to a Digital Capability-Based Allowance. Applicants who are successful at interview will be invited to complete a Capability and Skills Assessment post-interview. Any allowance awarded will be based on the assessment of your capability against the six skills advertised for this role. Please see the attached candidate pack for more information.

The allowance values are set by the Home Office, subject to remaining in a qualifying role, and are non-pensionable. This allowance is non-contractual, subject to an annual review and could be withdrawn at any time.

For both new entrants and existing civil servants, the total compensation offer is a combination of base salary and, if applicable, a capability-based allowance. New entrants to the Civil Service will start on the pay range minimum. For existing civil servants, our policies on level transfer and promotion will apply.

The advertised role is part of the Home Office Government Digital and Data Profession. This role has access to a Digital Capability-Based Allowance. Applicants who are successful at interview will be invited to complete a Capability and Skills Assessment post-interview. Any allowance awarded will be based on the assessment of your capability against the six skills advertised for this role. Please see the Home Office Pay Framework Allowance Careers page for more information.

The allowance values are set by the Home Office, subject to remaining in a qualifying role, and are non-pensionable. This allowance is non-contractual, subject to an annual review and could be withdrawn at any time.

For both new entrants and existing civil servants, the total compensation offer is a combination of base salary and, if applicable, a capability-based allowance. The pay ranges for this role are National: £60,300 - £66,330 and London: £64,300 - £70,730. New entrants to the Civil Service will start on the pay range minimum. For existing civil servants, our policies on level transfer and promotion will apply.

Job offers to this post are made on the basis of merit. We often have similar roles available at different grades. If a candidate is suitable for a similar role or a lower grade than they have applied for, we may offer the candidate that role without the need to go through a further selection process providing the role has the same competencies and essential skills.

Working at the Home Office

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 candidate's 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

In order to process applications without delay, we will be sending a Criminal Record Check to Disclosure and Barring Serviceon 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- stating the job reference number in the subject heading.

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

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 .

See our vetting charter .

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

Working for the Civil Service

The Civil Service Code 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 .

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 and the Civil Service Diversity and Inclusion Strategy .

Apply and further information

This vacancy is part of the Great Place to Work for Veterans initiative.

Once this job has closed, the job advert will no longer be available. You may want to save a copy for your records.

Contact point for applicants
Job contact :

• Name :
• Email :

Recruitment team

• Email :

Further information

If you feel that your application has not been treated in accordance with the Civil Service recruitment principles and you wish to make a complaint, then contact the Government Recruitment Service via If you are not satisfied with the response that you receive, then you can contact the Civil Service Commission

---