Job summary
The Digital Information team is
looking to boost its Business Intelligence Platform by adding a new BI Developer
to a highly successful team.
Each of our Business Intelligence
Developers are lead designers with autonomous responsibility over a variety of
projects. However, if this sounds daunting and youre fresh into this level of role,
dont worry, we will provide support and training to help build your
confidence.
We are primarily an on-premises
Microsoft BI Stack organisation. Therefore, youll need an excellent working
knowledge of SQL Server, our primary development tool. A history of SSIS/SSRS
is advantageous. However, given the current restructure of our Platform, experience
with SSAS (Cubes/Tabular Models) will give a definite edge. You will also be
given opportunities to learn SSIS, PowerBI, PowerShell and integration with
Azure DevOps.
Organisationally, we commit to improving
patient care through all roles. Therefore, Digital BI integrates with Digital
IT to deliver reporting across all new/upgraded applications. This paves the
way for trend analysis and forecasting across over 70 datasets. The largest
project supports Sunrise, our Electronic Patient Record which coalesces patient
data from multiple core systems for consultants.
In terms of location, this role is
a hybrid between office / remote working, with an in-office presence expected
twice a week.
Interviews will be on location, at
Worcester Royal. Previous candidates need not apply.
Main duties of the job
Each developer role splits into
two halves; Projects work and Adhocs. Project work focuses on longer term
projects, involving multiple stakeholders, deploying into an integrated
warehouse platform. Adhocs reflect bite-size pieces of work, created to support
analyst requirements and system upgrades.
As with any BI Developer role,
there exists a certain degree of bug fixing and maintenance.
High Level Overview
- To lead and manage dedicated long term projects,
communicating with appropriate departments/people, utilising a GIRFT approach
- Assist with Data Warehouse upgrades in-line with
Digital IT application upgrades
- Assist with the overarching 3 year BI delivery plan,
affirming and rewriting legacy code into the new platform
- Assist with teaching / education of analytical
staff
- To monitor / maintain viability of SQL Jobs
& Data Flows, bug fixing as required
- Provide suggestions to improve data flow processes
- Review new or upgraded technologies in the BI
industry. Suggest potential applications
- To assist on-call, as required
About us
Our purpose is simple - Putting Patients First. We are looking for exceptional colleagues who can help us achieve this.
Worcestershire Acute Hospitals NHS Trust is a large acute and specialised hospital trust that provides a range of local acute services to the residents of Worcestershire and more specialised services to a larger population in Herefordshire and beyond.
The Trust operates hospital-based services from three sites in Kidderminster, Redditch and Worcester
Our workforce is nearly 6,800 strong, and our caring staff are recognised as providing good and outstanding patient-centred care. You could be one of them.
We are committed to recruiting the best people to work with us to achieve our Vision - working in partnership to provide the best healthcare for our communities, leading and supporting our teams to move 4ward. Our 4ward behaviours, which we ask all staff to demonstrate, underpin our everyday work and remain firmly at the heart of all we do.
Our objectives are simple:
- Best services for local people
- Best experience of care and best outcomes for our patients
- Best use of resources
- Best people
Better never stops, and our Clinical Services Strategy provides a clear future vision for our Trust, our hospitals, our services and our role in the wider health and care system.
We are proud to have achieved Timewise accreditation - this means we are committed to embedding flexible working within our organisation as a flex positive employer.
Job description
Job responsibilities
Post Title: Senior SQL Developer
Pay Band: Band 7
Hours: 37.5
Location/ Department: Information Department
Accountable to: Head of Information
Reports to: Data Warehouse & Intelligence Analytics Manager
Key Working Relationships
Finance Team Managers, Information Team,
Information Governance Manager, Clinical Coding Manager
Liaises with
Finance Team, Clinicians, Divisional Managers,
Information Team, Information Governance Manager, PAS system users, health
records staff, GP surgeries, Coding staff, Operational managers
Risk
assessment
Work on PC for long periods of time.
Job Purpose:
To sit within the wider
BI development team and play a key role in the future of the trust BI strategy
and data warehouse development. To assist with, or lead on, data extraction and
analytical type projects to support the BI team and the Information team.
To provide a highly
specialist technical lead resource developing and supporting business
intelligence and other information systems, and undertaking complex systems
development and re-development projects
using SQL Server, T-SQL and the full BI stack ( SSRS,SSAS,SSIS ). To drive
development of new dashboard solutions using Microsoft PowerBI.
Key Duties
1. Provide ongoing support to information team for all aspects relating to
data management, ETL and BI processes.
2. Develop,
maintain, document and enhance all ETL processes relating to patient data and associated systems.
3. Contributing
to, and assisting in, the development and subsequent implementation of the
departmental strategy for business intelligence and reporting.
4. To help line
manage junior members of the team and to be responsible for their training and
progression within their roles.
5. To act as a
mentor for junior team members as required.
6. Develop, map and document critical business and technical processes
7.
Contribute to the development of internal best
practice development methodologies, solution documentation and standards.
8.
Develop applications and solutions using rapid
agile methods with focus to deliver agreed shippable components to the end user
and subsequent iteration to acceptance.
9.
Conduct full technical testing of developed
solutions at a unit and system level with appropriate scaling, platform,
capacity and load testing
10.
Ensure that adequate security and data
protection protocols are incorporated into solution designs as per trust IG
principles.
11. Provide technical expert capability to pro-actively resolve issues
and assist with support and development issues as required, using high levels
of knowledge and experience.
12. Develop pro-active monitoring and event management procedures to
ensure continuous and reliable information
systems availability.
13. To keep up to date, and have an awareness of, new developments within
the NHS, with a particular focus on BI and Information
14.
Assist in other software development projects
as carried out by the team.
Job description
Job responsibilities
Post Title: Senior SQL Developer
Pay Band: Band 7
Hours: 37.5
Location/ Department: Information Department
Accountable to: Head of Information
Reports to: Data Warehouse & Intelligence Analytics Manager
Key Working Relationships
Finance Team Managers, Information Team,
Information Governance Manager, Clinical Coding Manager
Liaises with
Finance Team, Clinicians, Divisional Managers,
Information Team, Information Governance Manager, PAS system users, health
records staff, GP surgeries, Coding staff, Operational managers
Risk
assessment
Work on PC for long periods of time.
Job Purpose:
To sit within the wider
BI development team and play a key role in the future of the trust BI strategy
and data warehouse development. To assist with, or lead on, data extraction and
analytical type projects to support the BI team and the Information team.
To provide a highly
specialist technical lead resource developing and supporting business
intelligence and other information systems, and undertaking complex systems
development and re-development projects
using SQL Server, T-SQL and the full BI stack ( SSRS,SSAS,SSIS ). To drive
development of new dashboard solutions using Microsoft PowerBI.
Key Duties
1. Provide ongoing support to information team for all aspects relating to
data management, ETL and BI processes.
2. Develop,
maintain, document and enhance all ETL processes relating to patient data and associated systems.
3. Contributing
to, and assisting in, the development and subsequent implementation of the
departmental strategy for business intelligence and reporting.
4. To help line
manage junior members of the team and to be responsible for their training and
progression within their roles.
5. To act as a
mentor for junior team members as required.
6. Develop, map and document critical business and technical processes
7.
Contribute to the development of internal best
practice development methodologies, solution documentation and standards.
8.
Develop applications and solutions using rapid
agile methods with focus to deliver agreed shippable components to the end user
and subsequent iteration to acceptance.
9.
Conduct full technical testing of developed
solutions at a unit and system level with appropriate scaling, platform,
capacity and load testing
10.
Ensure that adequate security and data
protection protocols are incorporated into solution designs as per trust IG
principles.
11. Provide technical expert capability to pro-actively resolve issues
and assist with support and development issues as required, using high levels
of knowledge and experience.
12. Develop pro-active monitoring and event management procedures to
ensure continuous and reliable information
systems availability.
13. To keep up to date, and have an awareness of, new developments within
the NHS, with a particular focus on BI and Information
14.
Assist in other software development projects
as carried out by the team.
Person Specification
Qualifications
Essential
- Degree Level qualification in IT/Informatics or related discipline or working towards the above. Or 5 years relevant experience working at this level in a similar role
Desirable
- Any BI related Microsoft Certifications
Experience
Essential
- - Clear understanding and detailed working knowledge of data structures and data warehousing schemas / techniques
- - Demonstrable substantial experience of writing and using complex T-SQL or SQL code in a practical setting
- - Experience of the full software development life cycle or related methodologies. From specification to testing/deployment/review
- - Knowledge of NHS data and commissioning data sets
Desirable
- - SSRS / SSIS / SSAS
- - PowerShell
- - PowerBI
- - Knowledge of PBR
Person Specification
Qualifications
Essential
- Degree Level qualification in IT/Informatics or related discipline or working towards the above. Or 5 years relevant experience working at this level in a similar role
Desirable
- Any BI related Microsoft Certifications
Experience
Essential
- - Clear understanding and detailed working knowledge of data structures and data warehousing schemas / techniques
- - Demonstrable substantial experience of writing and using complex T-SQL or SQL code in a practical setting
- - Experience of the full software development life cycle or related methodologies. From specification to testing/deployment/review
- - Knowledge of NHS data and commissioning data sets
Desirable
- - SSRS / SSIS / SSAS
- - PowerShell
- - PowerBI
- - Knowledge of PBR
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).
