SQL Developer - Band 5
Job summary
The Suffolk and North East Essex Integrated Care Board (SNEE ICB) is an ambitious and innovative clinically led organisation. The business intelligence department are looking for a 1 year, fixed term associate SQL developer to assist the existing information team to deliver on its existing core responsibilities.
The associate SQL developer post is a key role supporting the delivery of reliable, accurate and timely data to the ICB. An important element of this is the assistance provided to the wider business intelligence team, helping them to source and access new and existing datasets within the data warehouse. The successful candidate will have great technical abilities, tenacity and be innovative to compliment an exceptional and highly skilled team.
The post would ideally suit someone with experience in SQL or a similar language, and understanding of data structures and an interest in how technological innovation can bring about improvements to ways of working.
Please note, due to the ongoing cost reduction programme and restructure underway at SNEE ICB (due to end in Summer 2024), prior consideration for this role may be given to existing staff who are affected by this programme and this role may be removed from the recruitment process at any time.
Main duties of the job
Communication & relationship skills
Communicate the state and readiness of business critical, sensitive, and complex information across the wider team.
Liaise with analytical team around setting up new data flows.
Liaise with external providers around any issues or delays that may arise.
Attend and contribute to regular meetings within the department.
Analytical and judgemental skills
Highlight areas of concern to the wider team around data quality, completeness, timeliness.
Analyse data imports and historic data to identify potential issues or missing data.
Analyse new data to ensure correct data types are used to support relational fields.
Monitor performance of warehouse and server, and recommend potential solutions where required.
Make decisions around the order of daily tasks to best utilise the time.
Planning and organisation skills
Manage and plan own workload and priorities which at times can be complex and need to be responsive to wider organisational needs.
Co-ordinate with other team members to ensure all daily tasks are covered.
About us
The NHS Suffolk and North East Essex ICB plan and buy healthcare services for over one million people. Working within a total budget of £1.5bn per year, we serve some of the poorest and wealthiest communities in the UK.
In addition to consolidating our own resources and expertise, we are also building powerful alliances with our partners in the local government, healthcare, community and voluntary sectors. Because we know that together, we can achieve the best possible health outcomes.
We are committed to providing a supportive work environment where employees are able to work to the best their abilities. We value professional development and care about health and wellbeing of our staff with many initiatives in place to make us an employer of choice and an organisation that employees are proud to be part of.
Job description
Job responsibilities
The primary purpose of the associate SQL developer is to play a full and active role within the ICB information team to deliver high quality information services to the ICB.
The post holder will support the work of the information and modelling manager, and the SQL developer team, to ensure that analytical datasets are properly maintained within the ICB data warehouse, ensure its successful operation and also take on additional duties to support the wider work of the Business Intelligence department.
The postholder will be required to utilise their skills and knowledge to process daily, weekly, and monthly datasets and communicate effectively to the wider team around progress or issues.
The post holder will be a member of a small, highly skilled, team and will be required to work closely with the analytical team and external partner organisations.
The post holder
Will provide high quality project, service, initiative and administrative support including information and analysis.
Will undertake reporting and analysis of information to support delivery.
Is a key member of the team whose overarching goal is to enable, promote and support the effective use of data, information, knowledge and technology to improve, inform and support a portfolio of projects, services, and initiatives.
Person Specification
Analytical
- Problem solving skills and ability to respond to sudden unexpected demands.
- Understanding of healthcare data and related data quality issues
- Excellent time management skills with the ability to re-prioritise.
Autonomy
- Ability to manage own time, be self-motivated and adaptable to changes in working requirements.
Knowledge, Training & Experience
- Knowledge of administrative procedures, range of computerised software, own directorate specialised terminology, managerial knowledge, project monitoring, acquired through degree or equivalent experience or equivalent training and experience
- Educated in relevant subject or equivalent level / experience of working at a similar level in specialist area.
- Capable of writing and interpreting SQL code.
- Previously worked in similar position
- Experience of working with confidential and/or sensitive information.
- Competent user of SQL Server Management Studio.
Communication Skills
- Competent communication skills to translate complex information to a range of audiences.
- Able to communicate with team members to ensure all team tasks are understood and covered
- Able to write and maintain clear process documentation
Personal Attributes
- Be a team player.
- Possess a professional attitude.
- Have a willingness to learn
- Commitment to continuous development of skills and knowledge
- Able to concentrate on specific and detailed matters whilst dealing with unplanned interruptions.
Disclosure and Barring Service Check
This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions.
Employer details
Employer name
NHS Suffolk and North East Essex ICB
Address
Endeavour House
8 Russell Road
Ipswich
Suffolk
IP1 2BX
https://suffolkandnortheastessex.icb.nhs.uk/
- Company
- NHS Suffolk and North East Essex ICB
- Location
- Ipswich, United Kingdom IP1 2BX
- Employment Type
- Fixed-Term
- Salary
- £28407.00 - £34581.00 a year
- Posted
- Company
- NHS Suffolk and North East Essex ICB
- Location
- Ipswich, United Kingdom IP1 2BX
- Employment Type
- Fixed-Term
- Salary
- £28407.00 - £34581.00 a year
- Posted