SQL Developer

Job Summary
Salary:
£37,336 - £41,418
Vacancy ID:
102387
Contract Type:
Permanent
Working Pattern:
Full time
Number of hours per week:
37 hours per week
Job Share:
No
Employment Location:
Leicester, Leicestershire and Rutland
Closing date:
22 Nov
Further Information
Leicestershire Fire and Rescue Service is looking for a SQL Developer to join our Application Support Group. If you are driven to help other people get the most from technology and have some experience with T-SQL and associated skills, you could be the person we are looking for.

Benefits you will receive: 
Competitive salary
Flexible working
Generous leave entitlement plus public holidays
Public sector pension (subject to pension scheme rules)
Full support for ongoing professional development
On-site gym facilities
Free onsite parking
Access to an emergency services discount card
Use of our occupational health unitYou will automatically be enrolled into the Local Government Pension Scheme (LGPS), which is a tax-approved, defined-benefit occupational pension scheme. Your contributions are based on your earnings, and you can choose from different income options when you retire.

About the SQL Developer Role:
This position brings a fantastic opportunity to work within our ICT team where you will be a key member of our Data Team responsible for building and maintaining our Data Warehouse and our Data Hub. 
 
Key Duties and Responsibilities as a SQL Developer:

Support ingress and egress of critical data, in a real-time environment, to support primary business functions.
Identify data elements using SSMS and an in-house Entity-Relationship tool, and use T-SQL, Stored Procedures, CTE etc to perform data engineering.
Identifying measures and producing calculated values to support the creation of Tabular Models used for Reporting.
Identify data relationships that might add value.
Support the reporting requirements of external stakeholders, for example, Annual Home Office data returns
Understand how tabular models are used to support PowerBI users.
Maintaining and developing current SQL and related skills

Closing date:  22nd November 2023
Test date: week commencing 27 November 2023
Presentation and Interview date: week commencing 11 December.


Leicestershire Fire and Rescue Service is committed to promoting workplace equality, diversity and inclusion. Furthermore, we want to create a work environment where everyone feels safe, can be themselves and can perform their roles to the best of their abilities. We have signed up with a number of nationally recognised organisations that promote equality, diversity and inclusion and we are working with them to help us achieve our objectives. These organisations include:
• Employers Network for Equality and Inclusion (ENEI)
• Department of Works and Pension’s Disability Confident scheme
• British Sign Language Charter
• Asians in the Fire Service Association (AFSA)

Pension Considerations
Annual Allowance- Please note that it is your personal responsibility to check whether by applying/accepting this position it would result in any Annual Allowance implications. A breach in the Annual Allowance threshold could result in a Tax charge. Further information on Annual Allowance can be obtained from our Pensions team.
Lifetime Allowance - Please note that it is your personal responsibility to check whether by applying/accepting this position it would result in any Lifetime Allowance implications. A breach in the Lifetime Allowance threshold will result in a Tax charge. Further information on Lifetime Allowance can be obtained from our Pensions team.
 
Please note
This job is closed for applications.