Overview

This post is based in the Strategic Modelling team within the Enterprise Data for Funding and Oversight division. We provide an enterprise data modelling service to the department, modelling data for internal analysts, providers, ministers, and the wider education sector across further education, apprenticeships, skills, and schools. The team oversees the running and continuous improvement of the FE Data Lakehouse service, including delivery of the Apprenticeship Accountability Framework and Qualification Achievement Rates data models for internal and external use. We are responsible for analytical data models spanning the School Census, School Workforce Census and Academy Accounts Return data sets. The role involves modernising these models within Azure Databricks, using new tools and technologies, while decommissioning the legacy technology stack.

As an analytics engineer, you will play a key role in shaping the service offering, ensuring that we continue to meet the needs of our diverse user base.

Responsibilities

• Drafting documentation of data models that meets DfE standards.
• Collaborating with stakeholders to resolve issues and risks, ensuring we are user focused throughout all work.
• Providing training and support for users of data sets.
• Working with more experienced analytics engineers to develop your skills.
• Supporting the end-to-end delivery of services to stakeholders that are automated, reliable, scalable, and secure.

Role Alignment

This role aligns to the Analytics Engineer role in the Digital, Data and Technology profession: https://ddat-capability-framework.service.gov.uk/role/analytics-engineer#analytics-engineer. The relevant areas include:

• Communicating between the technical and non-technical.
• Data modelling, cleansing and enrichment.
• Programming and build (data engineering).
• Turning business problems into data design.

Requirements and Assessments

Text in this section reflects essential criteria and assessment details from the person specification. You will be asked to provide a 250-word example demonstrating how you meet the technical skills. Technical skills assessed during the selection process include:

• Understanding of Python, SQL and data modelling.

Additional Information

We will use your CV and statement to assess suitability against the essential criteria. Interviews may be via Microsoft Teams or in person; the vacancy manager will confirm prior to the interview. Further information on security checks, nationality requirements, and civil service terms is provided as part of the recruitment process. Reasonable adjustments can be requested if you need accessibility support. If successful, pre-employment screening may include a Criminal Record Check. A reserve list may be held for 6 months. Location preferences may determine posting; new entrants are expected to join at the minimum of the pay band. Travel to your primary office location will not be paid by DfE. The Civil Service Code and diversity strategies apply. The Department for Education is an equal opportunity employer and supports a Disability Confident Scheme and Redeployment opportunities where applicable.

Benefits

Salary: £36,000 with Civil Service Pension scheme contribution. 25 days’ leave (increasing to 30), the King’s Birthday holiday, 8 bank and public holidays. Flexible working arrangements, hybrid working patterns, and opportunities for professional development.