SQL Developer
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?
- 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.
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.Job 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.
Person Specification
Experience
- 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.
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.
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.
Employer details
Employer name
Kirklees Council
Address
Kirklees Metropolitan Council
Albion Street
Huddersfield
HD1 2NW
https://www.kirklees.gov.uk/beta/default.aspx
- Company
- Kirklees Council
- Location
- Huddersfield, United Kingdom HD1 2NW
- Employment Type
- Permanent
- Salary
- £46731.00 - £48710.00 a year
- Posted
- Company
- Kirklees Council
- Location
- Huddersfield, United Kingdom HD1 2NW
- Employment Type
- Permanent
- Salary
- £46731.00 - £48710.00 a year
- Posted