Job summary
An exciting opportunity has arisen for an experienced business intelligence professional to hold a crucial role in the Trust.
The Trust has made a significant investment in business intelligence because it recognises the impact that the intelligent use of data can make to the delivery of high quality and efficient health services. Having developed most of the infrastructure, the focus now turns to using specialised skills and knowledge to maximise benefits to clinicians and patients.
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 Excel.
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. You will also have a leadership and training aspect to your role. The Business Intelligence 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 work with the Trust's 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 Business Intelligence 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.
You will have applied knowledge of core DBA functions (configuration, security, monitoring & tuning, backup & recovery) to ensure optimal performance of team deliverables to our customers and stakeholders.
You will also keep abreast with the latest thinking in Business Intelligence 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 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.
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. To see what we are doing for diversity and inclusion please see https://www.nottinghamshirehealthcare.nhs.uk/equality-and-diversity
About us
Nottinghamshire Healthcare employs over 10,000 colleagues who help #MakeADifference every day. We provide intellectual disability, mental health, community health, forensic and offender healthcare services across Nottinghamshire, Leicestershire, Lincolnshire and South Yorkshire. Care is delivered from over 120 sites within the community from acute settings and across low, medium and high secure environments including prisons.
As one of the largest mental health and community trusts in the East Midlands and one of the biggest employers in Nottinghamshire. We are also home to national and regional services such as the National High Secure Deaf Service and the Nottingham Centre for Transgender Health.
We are committed to flexible and agile working, including the opportunity to join our bank.
Your health and wellbeing is our priority and as such we invest significantly in this via our in-house Occupational Health Service, Staff Counselling Service and Health and Wellbeing Team.
We offer a number of employee-led staff networks, including Equality, Diversity and Inclusion (EDI) groups, our Green Champions Network, Freedom to Speak Up Network. Health and Wellbeing Champions Network and Menopause Champions. We provide care to a diverse range of communities and are passionate about supporting diversity and inclusion in the Trust.
If you believe in our values of Trust, Honesty, Respect, Compassion and Teamwork, then we would love to hear from you!
#TeamNottsHC
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.
Our Trust Values are Trust, Honesty, Respect, Compassion and Teamwork
We would love you to join us.
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.
Our Trust Values are Trust, Honesty, Respect, Compassion and Teamwork
We would love you to join us.
Person Specification
Qualifications
Essential
- Educated to degree level or equivalent (or equivalent work experience)
Desirable
- Degree in a relevant subject such as mathematics or statistics.
Training
Desirable
- Microsoft certified training in the use of Microsoft BI stack (SQL Server Reporting Services, SQL Server Analysis Services, SQL Server Integration Services)
- SharePoint development and administration
Experience
Essential
- Significant experience of developing and leading business intelligence solutions within NHS organisations
- Leading the strategic development of BI projects, from requirements gathering to implantation, that lead to tangible organisational benefit
- Evidence of research and expertise in the latest Business Intelligence technologies
- Highly skilled in collaborating with stakeholders across organisational boundaries
Desirable
- Experience of MDX/DAX/M programming
- Writing option appraisals for Business Intelligence solutions
- Experience of working in an NHS Trust
Knowledge
Essential
- In depth knowledge of latest Microsoft SQL server tools (Reporting Services, Integration Services, Analysis Services, Power BI, Excel data connections, Power Query etc.)
- Knowledge and application of Information Governance and principles of safe data management
- Specialist knowledge of the principles of data warehouse architecture
- Detailed specialised technical knowledge of application of Business Intelligence to an organisation
Desirable
- Use of MS SharePoint to deliver business intelligence
- Experience of delivering reporting solutions using MS Office including Power View and Power Pivot
Skills
Essential
- Practical applied knowledge of using SQL/T-SQL
- Proven ability to train and mentor staff in highly technical areas
- 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
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
Contractual Requirements
Essential
- A full UK driving licence and vehicle for business use is required for this post; however reasonable adjustments will be
- Willingness to work flexibly as required
Person Specification
Qualifications
Essential
- Educated to degree level or equivalent (or equivalent work experience)
Desirable
- Degree in a relevant subject such as mathematics or statistics.
Training
Desirable
- Microsoft certified training in the use of Microsoft BI stack (SQL Server Reporting Services, SQL Server Analysis Services, SQL Server Integration Services)
- SharePoint development and administration
Experience
Essential
- Significant experience of developing and leading business intelligence solutions within NHS organisations
- Leading the strategic development of BI projects, from requirements gathering to implantation, that lead to tangible organisational benefit
- Evidence of research and expertise in the latest Business Intelligence technologies
- Highly skilled in collaborating with stakeholders across organisational boundaries
Desirable
- Experience of MDX/DAX/M programming
- Writing option appraisals for Business Intelligence solutions
- Experience of working in an NHS Trust
Knowledge
Essential
- In depth knowledge of latest Microsoft SQL server tools (Reporting Services, Integration Services, Analysis Services, Power BI, Excel data connections, Power Query etc.)
- Knowledge and application of Information Governance and principles of safe data management
- Specialist knowledge of the principles of data warehouse architecture
- Detailed specialised technical knowledge of application of Business Intelligence to an organisation
Desirable
- Use of MS SharePoint to deliver business intelligence
- Experience of delivering reporting solutions using MS Office including Power View and Power Pivot
Skills
Essential
- Practical applied knowledge of using SQL/T-SQL
- Proven ability to train and mentor staff in highly technical areas
- 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
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
Contractual Requirements
Essential
- A full UK driving licence and vehicle for business use is required for this post; however reasonable adjustments will be
- 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).
