Job summary
A fantastic opportunity has arisen for a highly motivated Senior Analyst Developer who is looking to further their career by joining our expanding Database Administration and Integration team. Working in partnership with industry leading Microsoft Gold Partner Azure experts, you'll be responsible for the continuous development of data warehousing and reporting solutions which the Trust relies upon for the benefit of both its patients and staff.
This is a newly created position within a small but enthusiastic team who work closely together to seek out innovative solutions which ultimately support the delivery of the Trust's vision and Digital Strategy. You will be working on a number of exciting developments, including Azure Synapse and the implementation of a full Electronic Patient Record (EPR) across the Trust, alongside business as usual tasks.
You will need to have strong SQL (SSIS, SSRS and query building) skills, logical reasoning skills, analytics development skills and be experienced in optimising data models and queries. You will be required to gather requirements from our customers and design and develop robust and efficient data products for reporting and analytical uses.
Main duties of the job
The role offers the opportunity to lead on the design, monitoring, maintenance and improvement of current data flows and warehousing processes. The job role will include involvement in the planning and implementation of this process and the post holder will also be responsible for investigating and deploying innovative ways to improve systems.
You will be required to analyse and interpret complex data and develop software solutions to present this data to colleagues across the Trust in ways which are easily understood.
You will be a technical specialist, working alongside clinical and non-clinical colleagues, third party suppliers and senior managers, to suggest and implement solutions, monitoring and reporting on activity and maintaining standards of working in accordance with agreed design and project protocols.
About us
We are proud to provide 'Outstanding' care and be a great place to work.
We provide safe, compassionate and high-quality care to half a million people living or visiting East Sussex. We are one of the largest organisations in East Sussex, the only integrated provider of acute and community care in Sussex. Our extensive services are provided by 7000 + members of staff working from acute hospitals in Hastings and Eastbourne, three community hospitals in Bexhill, Rye and Uckfield, over 100 community sites and in people's own homes.
In 2020 the Care Quality Commission rated us as 'Good' overall, and 'Outstanding' for being caring and effective. The Conquest Hospital and our Community Services are rated 'Outstanding'. Eastbourne DGH rated 'Good'.
In 2020, the Trust launched its ambitious 'Building for our Future' programme. This once in a lifetime programme aims to repair, redevelop and expand our hospitals, transforming the environment in which we provide care for generations to come.
Job description
Job responsibilities
Please refer to the attached job description.
If you have any further queries, please do not hesitate to contact us.
Job description
Job responsibilities
Please refer to the attached job description.
If you have any further queries, please do not hesitate to contact us.
Person Specification
Qualifications
Essential
- Bachelor's degree in a computing related field
- Evidence of ongoing learning to postgraduate level
- In depth knowledge of database design, installation and maintenance, data migration techniques and relevant technologies/languages to master's degree level
Desirable
- Microsoft certified
- ITIL Foundation
Experience
Essential
- Significant experience designing and developing highly complex data-centric solutions
- Experience using SSMS, SSRS, SSIS, SSAS and Visual Studio in a commercial environment
- Experiencing of interfacing highly complex datasets between bespoke systems both in real time and as batch processing
- Experience of extracting, manipulating and presenting highly complex datasets to non-technical end users in a clear and concise manner
Desirable
- Use of Visual Studio in a healthcare environment
- Experience of installing and working with SSIS and SSRS
- Experience using Git, DevOps, JIRA or similar
Skills
Essential
- In depth knowledge of the following technologies/languages/constructs: TSQL, ASSL, DAX, Powershell, C#, VB.NET, HTML, XML, JSON, CSS, XSL, XSLT, HL7, ODBC, VBA, Javascript, BASH, R
- In-depth knowledge of database design, installation and maintenance (preferably SQL Server)
- In-depth knowledge of data migration techniques including design, extraction, cleansing, load and verification
- Understanding and practical experience using various development methodologies (Waterfall, Agile etc)
Desirable
- Appreciation and understanding of the development process, including information gathering, specification writing, information architecture, quality assurance, launch, user feedback and maintenance
- Able to use various reporting tools such as Power BI, Power Apps, Crystal Reports, Business Objects, MS Access, SQL Server Reporting Services
Person Specification
Qualifications
Essential
- Bachelor's degree in a computing related field
- Evidence of ongoing learning to postgraduate level
- In depth knowledge of database design, installation and maintenance, data migration techniques and relevant technologies/languages to master's degree level
Desirable
- Microsoft certified
- ITIL Foundation
Experience
Essential
- Significant experience designing and developing highly complex data-centric solutions
- Experience using SSMS, SSRS, SSIS, SSAS and Visual Studio in a commercial environment
- Experiencing of interfacing highly complex datasets between bespoke systems both in real time and as batch processing
- Experience of extracting, manipulating and presenting highly complex datasets to non-technical end users in a clear and concise manner
Desirable
- Use of Visual Studio in a healthcare environment
- Experience of installing and working with SSIS and SSRS
- Experience using Git, DevOps, JIRA or similar
Skills
Essential
- In depth knowledge of the following technologies/languages/constructs: TSQL, ASSL, DAX, Powershell, C#, VB.NET, HTML, XML, JSON, CSS, XSL, XSLT, HL7, ODBC, VBA, Javascript, BASH, R
- In-depth knowledge of database design, installation and maintenance (preferably SQL Server)
- In-depth knowledge of data migration techniques including design, extraction, cleansing, load and verification
- Understanding and practical experience using various development methodologies (Waterfall, Agile etc)
Desirable
- Appreciation and understanding of the development process, including information gathering, specification writing, information architecture, quality assurance, launch, user feedback and maintenance
- Able to use various reporting tools such as Power BI, Power Apps, Crystal Reports, Business Objects, MS Access, SQL Server Reporting Services
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.
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).
Additional information
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).
