Skip to main content

This job has expired

Principal Business Intelligence Developer

Nottinghamshire Healthcare NHS Foundation Trust
£43,742 to £50,056 per annum (pro rata for part time)
Closing date
31 May 2024

View more

Other Health Profession
Band 7
Contract Type
Full Time

Job Details

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. You will also have a leadership and training aspect to your role. 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 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 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

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!


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. To see what we are doing for diversity and inclusion please see

Person Specification



  • Educated to degree level or equivalent (or equivalent work experience)


  • Relevant postgraduate qualification



  • Microsoft certified training in the use of Microsoft BI stack (SQL Server Reporting Services, SQL Server Analysis Services, SQL Server Integration Services)
  • Microsoft certified training in the use of Microsoft Azure Technologies (Azure Analysis Service, Data Factory, Data Lake Storage/Analytics, Databricks, Synapse, Purview, Fabric etc.)
  • SharePoint development and administration



  • 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
  • Experience in design and/or development of cloud based solutions using MS Azure technologies.
  • Evidence of research and expertise in the latest Business Intelligence technologies
  • Highly skilled in collaborating with stakeholders across organisational boundaries.
  • Excellent team working skills.
  • Highly skilled in data warehouse maintenance.


  • Experience of MDX/DAX/M programming
  • Experience in design and/or development of cloud based solutions using MS Fabric
  • Experience of working in an NHS Trust
  • Supervision of junior staff.
  • Writing option appraisals for Business Intelligence solutions.



  • In depth knowledge of latest Microsoft SQL server tools (Reporting Services, Integration Services, Analysis Services, Power BI, Excel data connections, Power Query etc.)
  • In depth knowledge of latest Microsoft Cloud based technologies (Azure Analysis Service, Data Factory, Data Lake Storage/Analytics, Databricks, Synapse, Purview, Fabric 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.


  • Use of MS SharePoint to deliver business intelligence
  • Experience of delivering reporting solutions using MS Office including Power View and Power Pivot



  • Extensive 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


  • 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


  • Required to travel throughout Nottinghamshire. Reasonable adjustments will be made for disabled individuals in line with the Equality Act
  • Willingness to work flexibly as required

Employer details

Employer name

Nottinghamshire Healthcare NHS Foundation Trust


Duncan MacMillan House

Porchester Road



Any attachments will be accessible after you click to apply.



Get job alerts

Create a job alert and receive personalised job recommendations straight to your inbox.

Create alert