Job summary
An exciting opportunity for an experienced business intelligence professional to hold a crucial role in the Trust.The Trust has made a significant investment in BI because it recognises the impact that the intelligent use of data makes to the delivery of high quality and efficient health services. Having developed most of the infrastructure, our focus is now two-fold. Not only to utilise specialised skills and knowledge to maximise the benefits of our on-prem service to clinicians and patients, but also to move forward and embrace cloud technologies and solutions to further enhance our utilisation and delivery of the Trust's information services. This is a challenging but exciting time to help shape the infrastructure, platform, and applications that enhances our service to provide a progressive, comprehensive, insightful, and accessible use of the vast amount of information we collect. This will support the Trust, its services, our managers and staff, empowering them to make intelligence led decisions that will ultimately improve our patients lives.This role will report to the Trust's Business Intelligence and Data Warehouse Manager and is part of the Health Informatics Service. The department provides a great opportunity to learn and use the latest information technologies in a supportive and learning environment. The team utilises the current technology of SQL Server, Power BI, SharePoint, and will be shortly expand into MS Azure technologies including PaaS and SaaS.
Main duties of the job
You will have a hands-on technical role in the team. You will design and implement new solutions and architecture. You will work closely with wider teams in the Trust or external resources when required to overcome technical issues and/or improve current environments and solutions. The BI function is part of the Trust's Applied Information service, supporting them in their responsibility for the maintenance and ongoing development of the data warehouses, and coordinating the delivery of reporting solutions that meet the Trust's changing needs and providing intelligence on business problems.You will also keep abreast with the latest thinking in BI technologies and consider how our information infrastructure and insight delivery tools may continue to evolve.To be successful in this role you'll need more than just strong technical skills (although in-depth knowledge of the full Microsoft BI stack, Microsoft Azure services and experience of developing and managing BI solutions is essential). Strong interpersonal skills and the ability to understand business requirements and translate these into meaningful reporting solutions, working with multiple stakeholders across the Trust, will also be vital.
About us
#TeamNottsHC comprises over 11,000 dedicated colleagues who #MakeADifference every day. We deliver intellectual disability, mental health, community health, forensic, and offender healthcare services across Nottinghamshire, Leicestershire, Lincolnshire, and South Yorkshire. Our care is provided from over 200 sites, spanning community locations, acute settings, and secure environments, including prisons.
We are one of the largest mental health and community Trusts in the East Midlands and one of Nottinghamshire's biggest employers. We also host national and regional services, such as the National High Secure Deaf Service and the Nottingham Centre for Transgender Health.
We offer a variety of employee-led staff networks, including Equality, Diversity, and Inclusion (EDI) groups, the Green Champions network, the Freedom to Speak Up network, the Health and Wellbeing Champions network, and the Menopause Champions network. These networks play a vital role in supporting our diverse workforce and promoting a culture of inclusivity.
The health and wellbeing of our colleagues is a top priority. We invest significantly in this through our in-house occupational health and staff counselling services, supported by a dedicated Health and Wellbeing team.
The Trust is committed to reducing its carbon emissions, with a specialised Energy and Environmental team working to ensure compliance with environmental legislation, enhance our environmental performance, and achieve our net-zero commitment
Job description
Job responsibilities
You will be educated to degree level or have equivalent experience. You will have worked in previous analytics roles, collaborating on data extraction, analysis and information reporting. You are familiar with using SQL/T-SQL. You will also have knowledge of Power BI. These technical abilities will be combined with an attention to detail and a confidence to prioritise your own workload whilst remaining calm under pressure. Act as an advocate for professional values and standards and promote well-being amongst your colleagues.
You will work with the Trusts clinicians and managers to roll out the solutions to stakeholders to derive the benefits of the data warehouse infrastructure as well as pursuing the on-going development of this solution, including integrating new data sources, delivering new dashboard and report solutions and visualisations to support performance monitoring, improving clinical outcomes and ensuring the Trust can meet its business objectives.
You will have a strong level of knowledge across the range of BI areas including ETL, data warehouse structure and delivering meaningful dashboards and other ways of connecting users to data, whilst having the experience to judge what is the appropriate solution to implement from a strategic Trust position.
Our Trust Values are Trust, Honesty, Respect, Compassion and Teamwork
We would love you to join us.
We welcome part-time applications and are supportive of team members working in flexible, family-friendly ways. Other benefits include an excellent pensions offer, up to 38 days annual leave per year, lease car / cycle to work schemes and other health and wellbeing benefits. We value diversity and welcome applications from all backgrounds, including non-male genders, black and minority ethnic groups and people with health conditions or impairments.
Job description
Job responsibilities
You will be educated to degree level or have equivalent experience. You will have worked in previous analytics roles, collaborating on data extraction, analysis and information reporting. You are familiar with using SQL/T-SQL. You will also have knowledge of Power BI. These technical abilities will be combined with an attention to detail and a confidence to prioritise your own workload whilst remaining calm under pressure. Act as an advocate for professional values and standards and promote well-being amongst your colleagues.
You will work with the Trusts clinicians and managers to roll out the solutions to stakeholders to derive the benefits of the data warehouse infrastructure as well as pursuing the on-going development of this solution, including integrating new data sources, delivering new dashboard and report solutions and visualisations to support performance monitoring, improving clinical outcomes and ensuring the Trust can meet its business objectives.
You will have a strong level of knowledge across the range of BI areas including ETL, data warehouse structure and delivering meaningful dashboards and other ways of connecting users to data, whilst having the experience to judge what is the appropriate solution to implement from a strategic Trust position.
Our Trust Values are Trust, Honesty, Respect, Compassion and Teamwork
We would love you to join us.
We welcome part-time applications and are supportive of team members working in flexible, family-friendly ways. Other benefits include an excellent pensions offer, up to 38 days annual leave per year, lease car / cycle to work schemes and other health and wellbeing benefits. We value diversity and welcome applications from all backgrounds, including non-male genders, black and minority ethnic groups and people with health conditions or impairments.
Person Specification
Qualifications
Essential
- Any of a) experience in a BI role or other discipline focussed around using the Microsoft data platform b) Five years' experience working in any numerate or technical role c) Degree level or higher qualification with a significant component of work requiring data processing, database administration, statistics or data science
Desirable
- Relevant graduate\postgraduate qualification.
Training
Essential
- Evidence of continuous personal\professional development through any mix of formal training, personal study and attendance at relevant conferences and other events.
Desirable
- Relevant training in the use of elements of the Microsoft BI stack.
- SharePoint development and administration.
- Evidence of relevant personal projects, blogging or active involvement in community events.
- Relevant training in the use of elements of Microsoft Azure Technologies (Azure Analysis Service, Data Factory, Data Lake Storage/Analytics, Databricks, Synapse, Purview, Fabric etc.)
Experience
Essential
- Significant experience in two or more of the following: Designing and Building Data Warehousing Solutions, SQL Server Integration Services, SQL Server Analysis Services (Multidimensional or Tabular), Microsoft Power BI, Database Administration, Producing and optimising complex SQL queries, Data Science or the use of R language, Production of complex reports and design of dashboards, Using continuous deployment/DevOps/agile methodologies in database related projects
- Leading on projects and providing regular information/reports/datasets to stakeholders.
- Demonstrable experience of developing technical solutions that meet customer requirements.
- Supervision and/or mentoring of junior staff.
Desirable
- Experience of any of the following: Working with NHS, healthcare or social care data sets, Use of BIML to produce SSIS packages, Documentation of large BI projects, Advanced MDX or DAX programming, Use of PowerShell, Building Complex SSRS reports, Use and configuration of Microsoft SharePoint, Configuration and installation of SQL Server software and hardware
- Delivering Training to others
- Experience in design and/or development of cloud based solutions
Knowledge
Essential
- Knowledge of Information Governance and principles of safe data management.
- Knowledge of core BI and data warehouse design principles.
- Knowledge of latest Microsoft Cloud based technologies (Azure Analysis Service, Data Factory, Data Lake Storage/Analytics, Databricks, Synapse, Purview, Fabric etc.)
Desirable
- Knowledge of cloud technologies and concepts
- Knowledge of NHS Information requirements, datasets, data dictionary.
- Knowledge of visualisation & dashboard design best practices.
- Knowledge of data architecture in a healthcare environment.
- An excellent knowledge of the principles of data warehousing design and architecture.
- Understanding of relational database theory and normal forms.
- Understanding of GDPR and its implications on BI.
Skills
Essential
- Practical applied knowledge of using SQL.
- Ability to select and apply appropriate methods and tools for supporting all aspects of data and information management and use during the entire lifecycle.
- Able to manage multiple competing projects and effectively manage the resources at their disposal.
- Problem solving, analytical and judgmental capabilities to resolve complex data issues and reporting issues where a number of alternative solutions are present
- Able to present information clearly and communicate technical concepts to a varied audience.
- Ability to research new technical subjects and rapidly make use of the gained knowledge.
Desirable
- Practical applied knowledge of using T-SQL on Microsoft SQL Server.
Values and Behaviours
Essential
- All colleagues are expected to demonstrate that they act in line with Nottinghamshire Healthcare NHS Foundation Trust Values: Trust Honesty Respect Compassion Teamwork
- All colleagues are expected to demonstrate an understanding of and commitment to Equality, Diversity and Inclusion (EDI) and how it applies to their role. The Trust's expectations are highlighted within our EDI Policy, and associated EDI and Human Rights legislation
Physical Requirements
Essential
- Able to work predominately desk based, which may require sitting/standing in a restricted position.
Contractual Requirements
Essential
- Required to travel throughout Nottinghamshire
- Willingness to work flexibly as required
Person Specification
Qualifications
Essential
- Any of a) experience in a BI role or other discipline focussed around using the Microsoft data platform b) Five years' experience working in any numerate or technical role c) Degree level or higher qualification with a significant component of work requiring data processing, database administration, statistics or data science
Desirable
- Relevant graduate\postgraduate qualification.
Training
Essential
- Evidence of continuous personal\professional development through any mix of formal training, personal study and attendance at relevant conferences and other events.
Desirable
- Relevant training in the use of elements of the Microsoft BI stack.
- SharePoint development and administration.
- Evidence of relevant personal projects, blogging or active involvement in community events.
- Relevant training in the use of elements of Microsoft Azure Technologies (Azure Analysis Service, Data Factory, Data Lake Storage/Analytics, Databricks, Synapse, Purview, Fabric etc.)
Experience
Essential
- Significant experience in two or more of the following: Designing and Building Data Warehousing Solutions, SQL Server Integration Services, SQL Server Analysis Services (Multidimensional or Tabular), Microsoft Power BI, Database Administration, Producing and optimising complex SQL queries, Data Science or the use of R language, Production of complex reports and design of dashboards, Using continuous deployment/DevOps/agile methodologies in database related projects
- Leading on projects and providing regular information/reports/datasets to stakeholders.
- Demonstrable experience of developing technical solutions that meet customer requirements.
- Supervision and/or mentoring of junior staff.
Desirable
- Experience of any of the following: Working with NHS, healthcare or social care data sets, Use of BIML to produce SSIS packages, Documentation of large BI projects, Advanced MDX or DAX programming, Use of PowerShell, Building Complex SSRS reports, Use and configuration of Microsoft SharePoint, Configuration and installation of SQL Server software and hardware
- Delivering Training to others
- Experience in design and/or development of cloud based solutions
Knowledge
Essential
- Knowledge of Information Governance and principles of safe data management.
- Knowledge of core BI and data warehouse design principles.
- Knowledge of latest Microsoft Cloud based technologies (Azure Analysis Service, Data Factory, Data Lake Storage/Analytics, Databricks, Synapse, Purview, Fabric etc.)
Desirable
- Knowledge of cloud technologies and concepts
- Knowledge of NHS Information requirements, datasets, data dictionary.
- Knowledge of visualisation & dashboard design best practices.
- Knowledge of data architecture in a healthcare environment.
- An excellent knowledge of the principles of data warehousing design and architecture.
- Understanding of relational database theory and normal forms.
- Understanding of GDPR and its implications on BI.
Skills
Essential
- Practical applied knowledge of using SQL.
- Ability to select and apply appropriate methods and tools for supporting all aspects of data and information management and use during the entire lifecycle.
- Able to manage multiple competing projects and effectively manage the resources at their disposal.
- Problem solving, analytical and judgmental capabilities to resolve complex data issues and reporting issues where a number of alternative solutions are present
- Able to present information clearly and communicate technical concepts to a varied audience.
- Ability to research new technical subjects and rapidly make use of the gained knowledge.
Desirable
- Practical applied knowledge of using T-SQL on Microsoft SQL Server.
Values and Behaviours
Essential
- All colleagues are expected to demonstrate that they act in line with Nottinghamshire Healthcare NHS Foundation Trust Values: Trust Honesty Respect Compassion Teamwork
- All colleagues are expected to demonstrate an understanding of and commitment to Equality, Diversity and Inclusion (EDI) and how it applies to their role. The Trust's expectations are highlighted within our EDI Policy, and associated EDI and Human Rights legislation
Physical Requirements
Essential
- Able to work predominately desk based, which may require sitting/standing in a restricted position.
Contractual Requirements
Essential
- Required to travel throughout Nottinghamshire
- Willingness to work flexibly as required
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).
