NHS
SQL Developer
This job is now closed
Job Description
- Req#: F0014-13987?language=en&page=1364&sort=publicationDateDesc
- We are a modern and progressive council, committed to truly family-friendly, flexible, and agile ways of working
- Generous pension scheme
- Annual leave entitlement of 27.5 days a year (plus public holidays).
- Were committed to staff development and continuous improvement.
- A degree which includes a strong data component (e.g. Computer
- Science, Engineering, Statistics) or equivalent experience.
- In-depth knowledge of Microsoft SQL Server tools including SQL
- Server Integration Services (SSIS).
- Experience of working with various SQL standards (e.g T-SQL,
- PL/SQL)
- Knowledge and awareness of some of the core systems across the
- Council. E.g. Liquidlogic LCS/EHM, Serverlec Synergy/Mosaic, SAP
- ERP, OLM CareFirst.
- A degree which includes a strong data component (e.g. Computer
- Science, Engineering, Statistics) or equivalent experience.
- In-depth knowledge of Microsoft SQL Server tools including SQL
- Server Integration Services (SSIS).
- Experience of working with various SQL standards (e.g T-SQL,
- PL/SQL)
- Knowledge and awareness of some of the core systems across the
- Council. E.g. Liquidlogic LCS/EHM, Serverlec Synergy/Mosaic, SAP
- ERP, OLM CareFirst.
Job summary
About the Role:
This role is one of several exciting new roles weve created to contribute to a successful, efficient, and effective Data and Insight Service. As a SQL Developer in the Council, you will get the opportunity to work with a wide variety and large volume of interesting and high-value datasets, and the work you do will directly contribute to improving health, social, and economic outcomes across Kirklees.
This is an exciting time to join us as we begin to assess and reshape the Councils data engineering and development practice. You will get the opportunity to work directly with high-value, high-impact datasets and support team members in exploring how we can enhance our offering through working with the latest technology (e.g., MS Azure). The role will be an instrumental part of a journey that includes embedding agile ways of working and providing support to key delivery teams across the data and insight service.
You will lead work on database design, development, maintenance, and management; utilizing modern and best practice development standards to seek out opportunities for efficiency, effectiveness, and innovation.
Main duties of the job
Why Join Us?
About You:
We are looking for someone who shares our energy and ambition for how data can be used to make a tangible difference to outcomes for people and places.
You will have proven experience in designing, building, and testing data products and services. You will have a deep understanding of the concepts and principles of data modelling and have experience of producing relevant data models across multiple subject areas with efficient and appropriate structures for business intelligence and analysis.
As a SQL Developer, you will be confident in your ability to develop, implement, and embed best practice standards, tools, and approaches, ensuring quality is central to everything we do. You will be committed to continuous improvement and have a desire to succeed individually and as part of a team.
If you are looking for a role that is challenging and hugely rewarding, and you have the skills and ambition we are looking for, we would love to hear from you.
About us
About Us:
Kirklees is set in the heart of beautiful West Yorkshire and has a growing population of approximately 440,000. With the two major centres of Huddersfield and Dewsbury, it also encompasses several smaller towns. It is well served by both rail and road networks and is in close proximity to Leeds and Manchester.
Other roles you may have experience of could include: Data Engineer, Database Developer, SQL Specialist, Data Solutions Developer, Data Infrastructure Developer.
Rachael Reynoldsis the manager for this role, please contact them on 01484 221000 for an informal discussion, or if you need any more information.Date posted
29 October 2024
Pay scheme
Other
Salary
£46,731 to £48,710 a year
Contract
Permanent
Working pattern
Full-time, Flexible working, Home or remote working
Reference number
F0014-13987
Job locations
Kirklees Metropolitan Council
Albion Street
Huddersfield
HD1 2NW
Job descriptionJob description
Job responsibilities
Job purpose At Kirklees we want to be innovative and creative in the way we work to deliver our services to our communities. We know we have challenging times ahead, so we are always looking for better and smarter ways to work. The role is based within the Councils Data and Insight Service and will design, develop and deliver data products and services that support delivery of business intelligence, analytics and insights to services across the Council. Key areas of responsibility
Contribute to a successful, efficient and effective Data and Insight Service, supporting services and decision-makers to understand how much and how well they are doing and what difference they are making to service users, customers, citizens and communities in Kirklees.
Lead work on database design, development, maintenance and management.
Design, develop and implement automated data flows to extract, transform and link data sources for analytics and business intelligence systems.
Review manual data flows and act on opportunities to develop automated data flows.
Identify and act on opportunities to re-use existing data flows.
Create and implement appropriate testing regimes to monitor the effectiveness and quality of your work and identify and resolve problems at the earliest opportunity.
Apply best practice development standards and seek out opportunities for efficiency, effectiveness, and innovation.
Develop and maintain appropriate metadata repositories.
Build strong relationships and work with technical and non-technical stakeholders to gather, interpret and analyse data requirements.
Support the ongoing improvements in data management and data development across the Data and Insight Service.
Apply agile development practices.
Job responsibilities
Job purpose At Kirklees we want to be innovative and creative in the way we work to deliver our services to our communities. We know we have challenging times ahead, so we are always looking for better and smarter ways to work. The role is based within the Councils Data and Insight Service and will design, develop and deliver data products and services that support delivery of business intelligence, analytics and insights to services across the Council. Key areas of responsibility
Contribute to a successful, efficient and effective Data and Insight Service, supporting services and decision-makers to understand how much and how well they are doing and what difference they are making to service users, customers, citizens and communities in Kirklees.
Lead work on database design, development, maintenance and management.
Design, develop and implement automated data flows to extract, transform and link data sources for analytics and business intelligence systems.
Review manual data flows and act on opportunities to develop automated data flows.
Identify and act on opportunities to re-use existing data flows.
Create and implement appropriate testing regimes to monitor the effectiveness and quality of your work and identify and resolve problems at the earliest opportunity.
Apply best practice development standards and seek out opportunities for efficiency, effectiveness, and innovation.
Develop and maintain appropriate metadata repositories.
Build strong relationships and work with technical and non-technical stakeholders to gather, interpret and analyse data requirements.
Support the ongoing improvements in data management and data development across the Data and Insight Service.
Apply agile development practices.
Person SpecificationPerson Specification
Experience
Essential
Experience
Essential
Additional informationCertificate of Sponsorship
Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab).
From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab).
Certificate of Sponsorship
Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab).
From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab).
Employer details
Employer name
Kirklees Council
Address
Kirklees Metropolitan Council
Albion Street
Huddersfield
HD1 2NW
Employer's website
https://www.kirklees.gov.uk/beta/default.aspx (Opens in a new tab)
Employer details
Employer name
Kirklees Council
Address
Kirklees Metropolitan Council
Albion Street
Huddersfield
HD1 2NW
Employer's website
https://www.kirklees.gov.uk/beta/default.aspx (Opens in a new tab)
About the company
National Health Service (NHS) is the umbrella term for the publicly-funded healthcare systems of the United Kingdom (UK). The founding principles were that services should be comprehensive, universal and free at the point of delivery—a health service based on clinical need, not ability to pay. Each service provides a comprehensive range of health services, free at the point of use for people ordinarily resident in the United Kingdom apart from dental treatment and optical care.