Job summary
You will have responsibility for the development and on-going maintenance and monitoring of the Trust Data Warehouse and BI Systems.
Within the team you will be developing a new Cloud hosted Data warehouse and reporting platform.
You will build ETL processes from multiple clinical systems with feeds into Trust Data Warehouse.
Through effective communication with staff at all levels, you will interpret needs into report enabling solutions. Data will be transformed into functional data models (star schema). You will be familiar with Kimball data modelling approach.
Sufficiently skilled across various reporting vehicles including PowerBi and SSRS, you will produce of reports, dashboards and visualisations.
Highly developed specialist knowledge of Microsoft SQL Server and associated tools (SSIS / SSAS).
Support in all areas of data warehouse development. You will be 1st line in support and rectification of impactful database issues. Familiar with Activity Monitor, stored procedures and TSQL coding as well as optimisation via indexes and other DBA and performance considerations and pitfalls.
Monitoring internal IT calls logged to Team and action various requests from our users.
Act as "data expert" in multiple Trust and IM&T projects. An example might include provision of data and associated expertise to enable clinical system upgrades or implementation of new Trust systems.
please refer to Job Description.
Main duties of the job
You will have responsibilities for the development and on-going maintenance and monitoring of the Trust Data Warehouse and BI Systems.
You will be working within a team leading in the specification, development and implementation of a Hybrid on-premise and Azure cloud Data warehouse and reporting platform.
This embodies development of standardised ETL processes from multiple source systems into the Trust Data Warehouse.Data warehouse will present data through conformed stars based on Kimball principals of which you should be conversant.
There will be some needs for Report, Dashboards and Data Visualisations development.
As a developer, you will be highly IT technical and have sufficient specialist knowledge in Microsoft SQL Server to build effective systems and processes. Knowledge of SSIS, SSAS, TSQL, DBA and performance considerations is a minimum for post. Knowledge in the Azure platform and tools such as PowerApps would greatly benefit.
You will support in all areas of data warehouse management and development including but not limited to: new data feeds, data quality, IG considerations, remedy of issues, permissions management, user support and requests.
We would expect team working and a proactive attitude in developing own and team skills with aims on extending services offered to the Trust.
Please refer to full job description for more information.
About us
University Hospitals of North Midlands NHS Trust is one of the largest and most modern in the country. Based across two sites, Royal Stoke in Stoke-on-Trent and County Hospital in Stafford, we are proud to serve around three million people and we're highly regarded for our facilities, teaching and research. We are the specialist centre for major trauma for the North Midlands and North Wales.
All of our employees make a valuable contribution regardless of role here at UHNM and we are proud of our wide range of development packages aimed at ensuring that everyone has the opportunity to fulfil their true potential.
UHNM create and encourage a culture of inclusion, providing equal opportunities for career development that are fair and transparent. We are committed to being a diverse and inclusive employer and foster a culture in which all staff feel valued and respected. In return we ask all of our employees to make a commitment to the values, co-created by or staff, patients and carers, and that unite us as a Trust.
At University Hospitals of North Midlands NHS Trust we know that investing in, supporting and developing our staff has a direct impact on the quality of care that we deliver. Our employees are as important as our patients and the population that we serve.
Job description
Job responsibilities
-
Communications & Relationships
- To receive, provide and process highly complex and sensitive data with understanding and abidance of relevant data protection and governance regulations.
- Regular contact with clinicians, senior managers and third party suppliers in relation to data needs and technical solutions.
- Understand, interpret and disseminate highly complicated and sensitive information to clinicians and senior levels of management.
- Maintains productive relationships with different parties in order to understand needs from reporting, dashboard and software across the Trust.
- Provides a source of expert knowledge to colleagues across the organisation.
- Day-to-day communication and support to all staff groups ensuring BI and reporting systems are utilised effectively within the Trust.
- Be active and engaged when participating in meetings/discussion ensuring productive and effective use of time and a positive contribution to outcomes.
- Deputise or represent IM&T at meetings or events.
Knowledge, Training & Experience
- Highly developed specialist knowledge of Microsoft SQL Server and associated tools (SSIS / SSAS), Reporting Tools, PowerBi and DAX. Understanding and appreciation of application development and integration principals including relevant industry standard methodologies, tools and techniques.
- Sufficiently skilled in Microsoft SQL Server to identify, track and support in rectification of impactful issues using tools such as Activity Monitor, stored procedures and TSQL code. An understanding of indexing and other DBA performance considerations and pitfalls.
- Provides end user support, training and advanced technical expertise of Information Systems and analysis tools to support various technical and analytical teams across the Trust.
- To participate in your own development and personal objectives setting and reviews, including supporting in the creation of your own personal development plan.
Analytical & Judgemental Skills
- Analyses, investigates and interprets highly complex data with aptitude to perform accurate comparisons, trend analysis and statistical reporting.
- Interprets reporting needs from overview of complex (likely clinical) systems and end user engagement. Able to establish requirements and transform raw data into functional data models (star schema) to enable reporting needs.
- Resolves complex issues and where necessary recommends appropriate hardware, software or business practice changes to Trust data and software systems, policies and procedures.
- Performs investigations and recommends / implements changes in order to resolve issues or to comply with data requirements such as confidentiality legislation, operational impact and NHS IT security policies.
- Provides, receives and processes complex information supporting Trust needs and obligations while adhering with all Informational Governance, GDPR and legal requirements.
Planning & Organisational Skills
- Supports in the planning and organisation / implementation of highly complex data related projects that are critical to Trust operational reporting needs which impact both clinical and non-clinical areas. Where identified as a data lead, engages with staff at various levels to accurately identify project milestones, ensuring that they are consistent with the Trusts IM&T strategy.
- Organises and prioritises own work and able to work on own initiative and within the BI development team.
- Work productively alongside other IM&T and non-IM&T teams when projects span multiple teams. For example: End Users, Infrastructure, Integration and Business Change Teams and testing resources.
- Involved in multiple simultaneous projects of work and uses own judgement to identify priorities and set work plans accordingly.
- Monitors the use of data and ETL processes. Provides audit mechanisms that demonstrate system resilience and usage, and escalates issues where required.
Responsibility for Policy/Service Development
-
- Generates documentation in support of developed data/reporting processes to a standard that enables the on-going use and further development of these processes.
- Maintains an awareness of changes being implemented in the Trust and highlights if a change might have an impact in delivery of other services such as BI, Reporting or IT systems.
Responsibility for Financial and Physical Resources
- May be called on to provide specialist advice and technical input into specification of systems to be used in business units throughout the Trust.
- On occasion installs and maintains software solutions (ie APIs, drivers, Apps) on servers and personal computers in use by personnel throughout the Trust.
- Supports in ensuring BI servers and associated hardware and software are proactively maintained to pre-empt issues occurring and having negative impact on Trust operations.
- Takes responsibility for the security of personal physical resources such as laptops and smartcards. Ensures they are used safely and maintained appropriately.
Responsibility for Information Resources
- Contributes to planning, design, development, implementation and the on-going maintenance of key clinical care, business and data/information systems. Example system would include: Data Warehouse, ETL processes, Data Modelling, Reporting Tools, Reports and Dashboards, bespoke data and application solutions, etc.
- Responsible for writing development specifications which deliver to business needs and ensure quality, governance, performance, security and safety for tasked projects.
- Able to conduct effective and timely analysis of organisational, departmental and third party data and data system requirements when creating appropriate systems to meet needs.
- In maintaining systems and implementing changes, ensure that changes are implemented with minimal negative impact to Trust, promoting and training users on changes where appropriate.
- To interpret and manipulate highly complex and often sensitive data, producing appropriate reporting vehicles to support role needs, team needs or wider teams and Trust needs.
- You will deal with a large volume of patient identifiable data on a regular basis and should take account of relevant government legislation, UK Law and NHS policies such as the Caldicott guidelines.
- Support in management and maintenance of Trust report delivery systems.
- Manages permissions and accesses to Data and Reporting Systems.
- Responsible or key in supporting the timely creation of various data submissions and processes to enable national and regional data returns including: SUS CDS; ECDS; SLAM; National and Region Sit Reps and more.
- Undertakes daily monitoring of Trust Data Warehouse and other BI/IM&T responsible systems acting when issues are encountered. Potential interventions include Problem identification and resolve, performance tuning, on-going development and enhancements.
- Support and/or lead on the development of new data feeds including all stages of ETL and the generation of conformed dimensional modelled reporting data sets (Kimball star design).
- Supports or leads on development and maintenance of tabular and multidimensional SSAS/OLAP cubes
- Undertakes dashboard and report development utilising multiple IM&T supported reporting and data visualisation tools such as SSRS Reporting Services, Power BI and others.
- Provides support in application development opportunities with scope to grow this area within BI delivery specifically through tools such as Microsoft Power Apps and MS Forms.
- Daily review of service desk calls for BI action and collective working within BI and wider teams in provision of timely resolves and responses.
- Uses judgement and your understanding of data and systems to appreciate specific Trust problems or issues with view to implementing, recommending or assisting in potential solutions.
for Further Narrative, please see Job Description.
Job description
Job responsibilities
-
Communications & Relationships
- To receive, provide and process highly complex and sensitive data with understanding and abidance of relevant data protection and governance regulations.
- Regular contact with clinicians, senior managers and third party suppliers in relation to data needs and technical solutions.
- Understand, interpret and disseminate highly complicated and sensitive information to clinicians and senior levels of management.
- Maintains productive relationships with different parties in order to understand needs from reporting, dashboard and software across the Trust.
- Provides a source of expert knowledge to colleagues across the organisation.
- Day-to-day communication and support to all staff groups ensuring BI and reporting systems are utilised effectively within the Trust.
- Be active and engaged when participating in meetings/discussion ensuring productive and effective use of time and a positive contribution to outcomes.
- Deputise or represent IM&T at meetings or events.
Knowledge, Training & Experience
- Highly developed specialist knowledge of Microsoft SQL Server and associated tools (SSIS / SSAS), Reporting Tools, PowerBi and DAX. Understanding and appreciation of application development and integration principals including relevant industry standard methodologies, tools and techniques.
- Sufficiently skilled in Microsoft SQL Server to identify, track and support in rectification of impactful issues using tools such as Activity Monitor, stored procedures and TSQL code. An understanding of indexing and other DBA performance considerations and pitfalls.
- Provides end user support, training and advanced technical expertise of Information Systems and analysis tools to support various technical and analytical teams across the Trust.
- To participate in your own development and personal objectives setting and reviews, including supporting in the creation of your own personal development plan.
Analytical & Judgemental Skills
- Analyses, investigates and interprets highly complex data with aptitude to perform accurate comparisons, trend analysis and statistical reporting.
- Interprets reporting needs from overview of complex (likely clinical) systems and end user engagement. Able to establish requirements and transform raw data into functional data models (star schema) to enable reporting needs.
- Resolves complex issues and where necessary recommends appropriate hardware, software or business practice changes to Trust data and software systems, policies and procedures.
- Performs investigations and recommends / implements changes in order to resolve issues or to comply with data requirements such as confidentiality legislation, operational impact and NHS IT security policies.
- Provides, receives and processes complex information supporting Trust needs and obligations while adhering with all Informational Governance, GDPR and legal requirements.
Planning & Organisational Skills
- Supports in the planning and organisation / implementation of highly complex data related projects that are critical to Trust operational reporting needs which impact both clinical and non-clinical areas. Where identified as a data lead, engages with staff at various levels to accurately identify project milestones, ensuring that they are consistent with the Trusts IM&T strategy.
- Organises and prioritises own work and able to work on own initiative and within the BI development team.
- Work productively alongside other IM&T and non-IM&T teams when projects span multiple teams. For example: End Users, Infrastructure, Integration and Business Change Teams and testing resources.
- Involved in multiple simultaneous projects of work and uses own judgement to identify priorities and set work plans accordingly.
- Monitors the use of data and ETL processes. Provides audit mechanisms that demonstrate system resilience and usage, and escalates issues where required.
Responsibility for Policy/Service Development
-
- Generates documentation in support of developed data/reporting processes to a standard that enables the on-going use and further development of these processes.
- Maintains an awareness of changes being implemented in the Trust and highlights if a change might have an impact in delivery of other services such as BI, Reporting or IT systems.
Responsibility for Financial and Physical Resources
- May be called on to provide specialist advice and technical input into specification of systems to be used in business units throughout the Trust.
- On occasion installs and maintains software solutions (ie APIs, drivers, Apps) on servers and personal computers in use by personnel throughout the Trust.
- Supports in ensuring BI servers and associated hardware and software are proactively maintained to pre-empt issues occurring and having negative impact on Trust operations.
- Takes responsibility for the security of personal physical resources such as laptops and smartcards. Ensures they are used safely and maintained appropriately.
Responsibility for Information Resources
- Contributes to planning, design, development, implementation and the on-going maintenance of key clinical care, business and data/information systems. Example system would include: Data Warehouse, ETL processes, Data Modelling, Reporting Tools, Reports and Dashboards, bespoke data and application solutions, etc.
- Responsible for writing development specifications which deliver to business needs and ensure quality, governance, performance, security and safety for tasked projects.
- Able to conduct effective and timely analysis of organisational, departmental and third party data and data system requirements when creating appropriate systems to meet needs.
- In maintaining systems and implementing changes, ensure that changes are implemented with minimal negative impact to Trust, promoting and training users on changes where appropriate.
- To interpret and manipulate highly complex and often sensitive data, producing appropriate reporting vehicles to support role needs, team needs or wider teams and Trust needs.
- You will deal with a large volume of patient identifiable data on a regular basis and should take account of relevant government legislation, UK Law and NHS policies such as the Caldicott guidelines.
- Support in management and maintenance of Trust report delivery systems.
- Manages permissions and accesses to Data and Reporting Systems.
- Responsible or key in supporting the timely creation of various data submissions and processes to enable national and regional data returns including: SUS CDS; ECDS; SLAM; National and Region Sit Reps and more.
- Undertakes daily monitoring of Trust Data Warehouse and other BI/IM&T responsible systems acting when issues are encountered. Potential interventions include Problem identification and resolve, performance tuning, on-going development and enhancements.
- Support and/or lead on the development of new data feeds including all stages of ETL and the generation of conformed dimensional modelled reporting data sets (Kimball star design).
- Supports or leads on development and maintenance of tabular and multidimensional SSAS/OLAP cubes
- Undertakes dashboard and report development utilising multiple IM&T supported reporting and data visualisation tools such as SSRS Reporting Services, Power BI and others.
- Provides support in application development opportunities with scope to grow this area within BI delivery specifically through tools such as Microsoft Power Apps and MS Forms.
- Daily review of service desk calls for BI action and collective working within BI and wider teams in provision of timely resolves and responses.
- Uses judgement and your understanding of data and systems to appreciate specific Trust problems or issues with view to implementing, recommending or assisting in potential solutions.
for Further Narrative, please see Job Description.
Person Specification
Qualifications
Essential
- oEducated to degree level or working IM&T knowledge and experience at an equivalent level
- oProficient in the use of Microsoft office suite / o365: Word, Excel, PowerPoint
- ooExperience and / or qualifications attained specific in Database, Business Intelligence, Reporting or other Analytics fields
Knowledge, Skills, Training and Experience
Essential
- oSound understanding of Data Warehouse concepts and approaches to data modelling and techniques
- oFamiliarity in management of SQL-Server databases on-premise and/or Azure cloud
- oAbility to understand, interpret and critically analyse data and information
- oExperience in development of ETL processes from source through staging to final presented Data Warehouse reporting layer
- oConversant with SSIS or similar
- oGood and demonstrable knowledge of Kimball Star dimensional modelling.
- oSignificant technical skills in latest versions of SQL Server
- oExperience with various data types such as XML, JSON, CSV, HL7/FHIR
- oKnowledge and familiarity with PowerBi, SSRS and other reporting tools.
- oExperience in developing Tabular OLAP Cubes using SSAS
- oExpertise in the use of analytical and statistical tools, including advanced MS Excel skills.
- oExperience working within a broad and complex corporate IT operational environment.
- oHigh standard of TSQL coding skills
- oMore advanced elements of SQL Server akin to DBA level of knowledge (i.e. Activity Monitor/Indexes)
Desirable
- oExperience with CDS / ECDS and other National / Regional datasets or returns
- oNHS or private healthcare experience
- oKnowledge of hospital information systems, particularly patient administration and clinical management systems.
- oSoftware Development skills.
- oFamiliarity with NHS Data Dictionary
- oFamiliarity with PowerApps, Microsoft Forms and Azure developer tools.
- oUnderstanding or experience with NHS HRG processes
Personal Qualities
Essential
- oExcellent written and verbal communication skills, capable of communicating with staff at all levels within the organisation.
- oDemonstrates effective team working
- oDemonstrates motivation and drive
- oHighly numerate and attention to detail (reporting and document accuracy)
- oPositive mind-set in support of organisational change
- oAble to utilise initiative to solve problems and develop services
Person Specification
Qualifications
Essential
- oEducated to degree level or working IM&T knowledge and experience at an equivalent level
- oProficient in the use of Microsoft office suite / o365: Word, Excel, PowerPoint
- ooExperience and / or qualifications attained specific in Database, Business Intelligence, Reporting or other Analytics fields
Knowledge, Skills, Training and Experience
Essential
- oSound understanding of Data Warehouse concepts and approaches to data modelling and techniques
- oFamiliarity in management of SQL-Server databases on-premise and/or Azure cloud
- oAbility to understand, interpret and critically analyse data and information
- oExperience in development of ETL processes from source through staging to final presented Data Warehouse reporting layer
- oConversant with SSIS or similar
- oGood and demonstrable knowledge of Kimball Star dimensional modelling.
- oSignificant technical skills in latest versions of SQL Server
- oExperience with various data types such as XML, JSON, CSV, HL7/FHIR
- oKnowledge and familiarity with PowerBi, SSRS and other reporting tools.
- oExperience in developing Tabular OLAP Cubes using SSAS
- oExpertise in the use of analytical and statistical tools, including advanced MS Excel skills.
- oExperience working within a broad and complex corporate IT operational environment.
- oHigh standard of TSQL coding skills
- oMore advanced elements of SQL Server akin to DBA level of knowledge (i.e. Activity Monitor/Indexes)
Desirable
- oExperience with CDS / ECDS and other National / Regional datasets or returns
- oNHS or private healthcare experience
- oKnowledge of hospital information systems, particularly patient administration and clinical management systems.
- oSoftware Development skills.
- oFamiliarity with NHS Data Dictionary
- oFamiliarity with PowerApps, Microsoft Forms and Azure developer tools.
- oUnderstanding or experience with NHS HRG processes
Personal Qualities
Essential
- oExcellent written and verbal communication skills, capable of communicating with staff at all levels within the organisation.
- oDemonstrates effective team working
- oDemonstrates motivation and drive
- oHighly numerate and attention to detail (reporting and document accuracy)
- oPositive mind-set in support of organisational change
- oAble to utilise initiative to solve problems and develop 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
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).
