Business Intelligence Analyst | North Middlesex University Hospital NHS Trust

As Business Intelligence Analyst, you will be responsible for the provision of information, analytics and predictive modelling services to support business needs. The role requires advanced analytical skills and the ability to guide and advice on business intelligence and information management.

You will use your knowledge of core business processes together with your technical acumen to be an authoritative source for all business intelligence needs; leading on data acquisition, data transformation, data quality, data analysis, data presentation and technical implementation.

Specifically we are looking for someone who is:

• Highly numerate,


• A good communicator with people from across the organisation


• A confident user of pivot tables in MS Excel,


• Able to use complex excel formulas,


• Can draw charts and graphs,


• Aware of the processes that occur within the hospital,


• And Ideally able to use SQL to query relational databases


The post holder will be responsible for statutory returns, internal performance reporting, ad-hoc requests and providing informatics support to organisational projects. You will be required to work with colleagues form right across the trust.

A Business Intelligence Analyst is accountable for the submission of statutory, routine and ad-hoc returns. They provide authoritative information, guidance and advice on analytical solutions and implementation and ensure compliance with information policies, standards, and strategy. The role will require you to undertaking data analysis, data modelling and data transformation based upon identified business needs and carry our demand and capacity analysis to support divisional planning. You will need to be able to construct SQL queries to analyse patient activity information.

North Mid is part of North Central London integrated care system - consisting of the NHS and Local authority organisations in Camden, Islington, Barnet, Enfield and Haringey. As with other ICS's, we are working increasingly closely with partners and indeed many of our financial and performance objectives are measured at this system level. Whilst all organisations remain as standalone, statutory bodies we have an ICS infrastructure for making shared decisions and agreeing shared approaches.

We are proud of our staff and want to ensure their training allows them to provide excellent clinical care. We are also a training unit for medical students from UCL and St George's University Grenada, and for nursing and midwifery students from Middlesex and City Universities.

Take a tour of our hospitalhere

Work as part of a team to ensure all the reporting requirements placed on the department are delivered

Able to use Business Intelligence Systems and supporting languages such as SQL to extract, query analyse and present data and be able to carry our advanced skills in using and understanding large databases and complex spreadsheets. This includes use of excellent analytical skills and the ability to manipulate complex datasets.

The post holder will be responsible for planning, designing, developing, testing, implementing and maintaining

maintenance of business intelligence solutions. This includes changes resulting from business process changes, updated data requirements, and business rules.