Department for Education
Analytics Engineer
Get notified of more jobs like this · No spam, ever
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
Bristol (BS2 0EL), Coventry (CV1 2WT) Darlington (Dl1 5QE), Manchester (M1 2WD), Nottingham (NG2 1AW), Sheffield (S1 2FJ)
Please note– Bristol & Nottingham currently have site controls in place. Therefore, these location options are only available to existing DfE employees already assigned to these office locations.
Job Summary
IMPORTANT - This vacancy is using the Civil Service Numerical and Verbal tests. The deadline for completing the tests is the same as the vacancy closing date. Please ensure you complete the tests with sufficient time to complete the written application.
Our Mission Is To Ensure The Right Amount Of Money Goes To The Right Providers At The Right Time; And Is Spent In The Right Way – Underpinned By Our Three Outcomes
- Certainty. We provide certainty to those we fund so they can plan effectively;
- Assurance. We provide assurance that taxpayers’ money has been used as intended; and
- Support. We provide high quality advice, guidance and financial support to those we fund.
As a Senior Analytical Engineer, you will be part of a team creating, modernising, and improving existing SQL and Power BI data models across pre and post 16 funding, leading on specific strands of work, as well as developing interactive data visualisations using reporting tools.
Job Description
Our analytical engineers innovate to design and deliver data products and services, integrating them into systems and business processes within the department in adherence with data security policies and architecture protocols.
Responsibilities
Responsibilities will include, but not limited to for the roles:
- As a Senior analytical Engineer, you will work with others in finding innovative ways to improve service operations by continuously challenging approaches for optimum delivery of solutions.
- You will be user-focused, understanding the importance of data, data management, data quality. You will support the delivery of products to internal and external stakeholders, using agile or other methods of delivery.
- You will use your technical skills to design and implement data solutions, from conception to go-live. You will work to develop and deliver automated services that are reliable, scalable, and secure. You will work with a variety of stakeholders in your role such as delivery managers, business analysts and data scientists.
- You will be interpreting complex specifications and translating them into efficiently written code and quality assuring complex models and large datasets.
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
We welcome applications from candidates seeking part time or compressed working pattern. However, due to the nature of the work and the shift coverage required, the minimum number of contracted hours for this role is 30 hours per week over a 4 day period.
Person Specification
Essential Criteria
- Significant experience implementing data solutions or data models, using programming languages /software such as SQL, R and Power BI.
- Experience of end-to-end development and implementation of data solutions, including data models.
- Experience in visualising data in an engaging way, adding valuable insights and analysis.
- Can convey technical information to a non-technical audience, including senior leaders.
- Experience of interpreting complex specifications and translating into efficient code.
- Experience of quality assuring complex models and large datasets.
- Experience of analysing large and varied datasets and producing accurate analytical work to a high standard.
- Ability to create and maintain effective relationships with a variety of internal and external stakeholders.
Desirable Criteria (if Required)
- Experience of using advanced analytics platforms such as Databricks.
- Experience of designing and building tools using artificial intelligence technologies.
- A degree in a STEM-related subject (preferably Mathematics or Computing related),or relevant certification.
- Experience of supporting and continuously improving complex enterprise data systems (such as data lakes and data warehouses).
- A good working knowledge of post-16 funding formula, both in theory and implementation.
- A good working knowledge of any or all of the key datasets used for pre 16 and post 16 funding e.g. Individualised Learner Record, School Census, Young Persons Matched Administrative Dataset, Learning Aims Reference Service.
Desirable criteria will only be assessed at interview in the event of a tie break situation to make an informed decision.
Behaviours
We'll assess you against these behaviours during the selection process:
- Making Effective Decisions
- Changing and Improving
- Managing a Quality Service
Get help with your application
Your very own career expert that helps elevate your application to the next level.
Salary and Benefits
- Alongside your salary of £44,305, Department for Education contributes £12,835 towards you being a member of the Civil Service Defined Benefit Pension scheme.
- You will have 25 days leave, increasing by 1 day every year to a maximum of 30 days after five years’ service. In addition, all staff receive the King’s Birthday privilege holiday and 8 days’ bank and public holidays.
- We offer flexible working arrangements, such as job sharing, term-time working, flexi-time and compressed hours.
- Most DfE employees will be working a hybrid pattern, spending at least 60% of their time in an office or work setting.
Selection Process Details
This vacancy is using Success Profiles (opens in a new window), and will assess your Behaviours and Experience.
Application Process
Stage 1: Civil Service Numerical Test (CSNT)
Stage 2: Civil Service Verbal Test (CSVT)
Stage 3: Written Application
Stage 4: Interview
Important Information
- If you fail to complete the tests before the deadline, your application will be withdrawn.
- Guidance will be available when you are invited to take the test.
- The tests are untimed, administered via Civil Service Jobs, and applicant guidance is available during the test and online on GOV.UK Online Tests guidance.
- Applicants must complete the test on their own, without help, and Departments reserve the right to retest applicants under supervised conditions at later stages of the selection process.
Reasonable Adjustments & Test Accessibility
See our reasonable adjustments guide for candidates (online tests), or some example case studies, to act as a guide. You can use these to help you decide whether to ask for help or take the test without help.
Other Information
- In your application, please don’t include personal information that identifies you.
- This role can only be worked in the UK from the location options provided and not from overseas.
- Successful candidates must undergo a basic (or equivalent) criminal record check.
- People working with government assets must complete baseline personnel security standard (opens in new window) checks.
Contact Point for Applicants
Job Contact
- Name: Jessica Headey
- Email: Jessica.Headey@education.gov.uk
Recruitment Team
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London