Lead Data Engineer

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., 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., 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, 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 https://www.childcarechoices.gov.uk

In order to process applications without delay, we will be sending a Criminal Record Check to Disclosure and Barring Service 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.

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., * 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

Do you have experience in REST?, 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-online.org)

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

£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, 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, 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., 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 HOrecruitment.grs@cabinetoffice.gov.uk. If you are not satisfied with the response that you receive, then you can contact the Civil Service Commission