SQL Developer
Department for Education
Apply before 11:55 pm on Sunday 12th May 2024
Details
Reference number
Salary
Job grade
Contract type
Business area
Type of role
Information Technology
Working pattern
Number of jobs available
Contents
Location
About the job
Job summary
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 D&I Strategy
This post is based in the Resource Management Dashboard team, where we build high quality dashboards for use across the whole Department.
As a data engineer you will use your SQL expertise to build the data model and extract, load and transform routines to process corporate data e.g. commercial, finance, HR, etc.
You will be a highly motivated self-starter who will take ownership of the time you spend with us and truly make a difference, inspiring others to achieve great things too.
Job description
The successful candidate will be required to lead the data engineering strand for the Resource Management Dashboard.
You will be expected to work independently, and as a part of a team, to:
- Develop the data engineering in MS SQL Server
- Work closely with our Power BI developers on design and requirements
- Support the testing of any developments
- Optimise data structures, code and processes improve system performance
- Work in an agile, user-oriented way using Azure DevOps
- Share knowledge and seek advice when necessary
- Rapidly respond to short-term problems in your own area and across the wider team
Person specification
Essential Criteria
- Building and managing databases in Azure SQL Server
- Creating and amending powerful stored procedures and functions
- Processing and shaping data into summarised values
- Building for performance at scale
- Data table relationship management best practices
- Getting the most of SQL Server data and structures
Desirable Skills
- Working with Azure Data Factory and Azure Analytical Services.
Desirable criteria will only be assessed 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:
- Changing and Improving
- Delivering at Pace
Technical skills
We'll assess you against these technical skills during the selection process:
- Data engineering in Azure SQL Server
Benefits
Applicants currently holding a permanent post in the Civil Service should note that, if successful, their salary on appointment would be determined by the Department’s transfer / promotion policies.
As a member of the DfE, you will be entitled to join the highly competitive Civil Service Pension Scheme, which many experts agree is one of the most generous in the UK, with an average employer contribution of 27%.
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. Changes to these working arrangements are available in exceptional circumstances but must be agreed with the line manager and in line with the requirements of the role.
Travel to your primary office location will not be paid for by DfE, but costs for travel to an office which is not your main location will be covered.
As an organisation, which exists to support education and lifelong learning, we offer our staff excellent professional development opportunities.
Things you need to know
Selection process details
Application
To apply for this role please provide a CV and personal statement which will be used to select who will be invited to interview.
Your CV must include your job history, qualifications, and relevant experience and skills.
Your personal statement:
- Must not exceed 500 words.
- Has to provide examples from your experience that demonstrate how you’ve applied each of the required SQL skills. The six SQL skills you need to cover are set out in the essential criteria section of the Person Specification.
Interview
Candidates invited to interview will be assessed on the Behaviours listed for this role and on your experience/ technical ability with SQL (set out in the essential criteria under Person Specification above).
Other Information
We reserve the right to raise the minimum pass mark in the event of a high volume or strong field of candidates.
Please be aware that this role can only be worked in the UK from the location options provided and not from overseas.
The government is committed to supporting apprenticeships, enabling people to learn and progress in a role whilst earning. We want to monitor the number of people who have completed apprenticeships who are now applying to progress further in their career and are asking this question to all candidates, on all vacancies. You will be asked a question as part of the application process about any previous apprenticeships you have completed. Your response to this question will not affect your application and it is not a requirement of the role to have completed a previous apprenticeship.
If successful and transferring from another Government Department a criminal record check maybe carried out.
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 circumstance some candidates will want to send their completed forms direct. If you will be doing this, please advise Department of Education of your intention by emailing Pre-Employment.Checks.DFE@education.gov.uk stating the job reference number in the subject heading.
Department for Education do not cover the cost of travel to your interview/assessment unless otherwise stated.
A reserve list may be held for a period of 6 months from which further appointments can be made.
Candidates will be posted in merit order based upon location preference. Where more than one location is advertised you will be asked to state your preferred location.
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.
Terms and conditions of candidates transferring from ALBs and NDPBs
Bodies that are not accredited by the Civil Service Commission and are not able to advertise at Across Government on Civil Service jobs will be treated as external new starters and will come into DfE on modernised terms and conditions with a salary at the band minimum.
Bodies that are accredited by the Civil Service Commission but do not have civil service status will be offered modernised terms and will not have continuous service recognised for leave or sickness benefits. Salaries should be offered at band minimum, but there is some flexibility where this would cause a detriment to the individual.
Bodies that are accredited by the Civil Service Commission and do have Civil Service status will be treated as OGD transfers. Staff appointed on lateral transfer will move on to pre-modernised DfE terms (unless they were on modernised terms in their previous organisation). Staff appointed on promotion will move on to modernised DfE terms. Staff will transfer over on their existing salary (on lateral transfer) and any pay above the DfE pay band maximum will be paid as a mark time allowance. Staff moving on promotion will have their salaries calculated using the principles set out in the attached OGD transfer supplementary information.
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 Department of Education via centralrecruitment.operations@education.gov.uk 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.
Any move to Department for Education (DfE) will mean you will no longer be able to carry on claiming 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/
Feedback will only be provided if you attend an interview or assessment.
Security
Nationality requirements
Working for the Civil Service
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).
Apply and further information
Contact point for applicants
Job contact :
- Name : Andrew Jones
- Email : andrew.jones@education.gov.uk
Recruitment team
- Email : AdvertsRecruitment.DFE@education.gov.uk
Further information
