Business Intelligence Analyst
Job summary
We are looking for a motivated and experienced IUC Business Intelligence Analyst to join the Integrated Urgent Care Business Intelligence team at London Ambulance Service.
The post holder will provide high-quality analytical and reporting support for our Integrated Urgent Care and NHS 111 services. This will include information relating to activity, demand, operational performance, clinical assessment, call handling, staffing and referral outcomes.
The role will involve extracting, validating, manipulating and analysing complex information from a range of internal and external systems. The post holder will identify trends, exceptions, areas of good practice and areas of concern, and turn this analysis into clear and useful insight for operational teams, managers, senior leaders and external stakeholders.
The successful candidate will develop and maintain business intelligence reports, dashboards, databases, spreadsheets and other analytical products using SQL Server, Power BI, Excel and related systems. They will also support managers and other users in understanding and interpreting complex information, particularly where data may be sensitive, conflicting or does not support initial expectations.
This would suit an analyst who enjoys working with complex operational data, solving problems and helping services make better use of their information.
Main duties of the job
The post holder will:
Produce regular and ad hoc statistical and performance information for operational teams, managers, senior leaders and external stakeholders.
Extract, validate, manipulate and analyse complex data from a range of internal and external systems.
Analyse activity, demand, operational performance, clinical assessment, call handling, staffing, telephony and referral outcome information.
Identify trends, exceptions, risks, areas of good practice, data quality concerns and opportunities for service improvement.
Develop and maintain reports, dashboards, databases, spreadsheets, SQL queries and other business intelligence products using SQL Server, Power BI, Excel and related analytical systems.
Present complex information clearly using charts, tables, graphs, maps, written summaries and presentations.
Provide advice and support to managers and other users in the interpretation and use of performance information.
Make recommendations based on detailed analysis to support operational decision-making and service improvement.
Work with internal and external stakeholders to understand their information requirements and deliver accurate, timely and fit-for-purpose outputs.
Continually review reporting requirements and adapt information provision in response to changing operational, organisational and national priorities.
Contribute to the development, testing and improvement of business intelligence systems, databases, spreadsheets and reporting processes.
About us
Our strategy 2023-2028 outlines how we plan to achieve this, and is centred upon three missions focused on:
- Our care- delivering outstanding emergency and urgent care whenever and wherever needed.
- Our organisation- being an increasingly inclusive, well-led and highly skilled organisation people are proud to work for.
- Our London- using our unique pan-London position to contribute to improving the health of the capital.
To achieve these three missions we have set ourselves 50 commitments to deliver over the next five years. In developing these ambitious commitments, we have engaged extensively both inside our organisation, with our partners and with our patients, and we have analysed population trends and horizon scanned the future.
Job description
Job responsibilities
The IUC Business Intelligence Analyst will provide high-quality business intelligence, performance reporting and analytical support for Integrated Urgent Care and NHS 111 services.
Working as part of the IUC Business Intelligence team, the post holder will support the production, development and interpretation of information used by operational teams, managers, senior leaders and external stakeholders.
The role will involve extracting, validating, manipulating and analysing complex and varied datasets from a range of internal and external sources. This will include information relating to activity, demand, operational performance, clinical assessment, call handling, staffing, telephony and referral outcomes.
The post holder will use their analytical knowledge and business intelligence expertise to identify trends, exceptions, problems, risks, areas of good practice and areas of concern. They will investigate issues, solve problems and make evidence-based recommendations to support operational performance, service improvement and strategic decision-making.
The successful candidate will develop and maintain business intelligence reports, dashboards, databases, spreadsheets and other analytical products using SQL Server, Power BI, Excel and related systems. They will create and maintain complex SQL queries, support the development of user-friendly reporting products and contribute to the continuous improvement of information gathering, reporting processes and business intelligence systems.
The post holder will present complex information in a clear and accessible way using charts, tables, graphs, maps, written reports and presentations. They will provide advice and support to managers and other users in the interpretation and analysis of information, particularly where data may be complex, conflicting, sensitive or does not support initial assumptions or expectations.
The role requires close working with operational services, clinical teams, senior managers, other Business Intelligence teams and external stakeholders. The post holder will work with these groups to understand their information requirements and ensure reporting outputs are accurate, timely and fit for purpose.
They will continually review information requirements and adapt reporting in response to changes within the department, the wider organisation and the national NHS environment. The post holder will be expected to manage competing priorities, organise their own workload and meet agreed reporting deadlines.
The post holder will contribute to the development, testing and ongoing improvement of information systems, databases, spreadsheets and reporting processes. They may also provide training and support to colleagues in the use and interpretation of information systems, dashboards, reports and statistics.
The role will include contributing to project work and service improvement initiatives, representing Business Intelligence at meetings and working groups and providing detailed analytical information and professional advice.
All duties must be carried out in accordance with Trust policies and relevant legislation, including requirements relating to information governance, confidentiality, data protection, Freedom of Information, safeguarding, equality and diversity, health and safety and risk management.
The post holder will be expected to demonstrate the Trust values of Caring, Respect and Teamwork in all aspects of their work.
Person Specification
Qualifications, Accreditations, Education
- Graduate level of education or equivalent experience and expertise in business intelligence in a work environment
- GCSE mathematics or equivalent
Experience
- Experience of producing, analysing and interpreting business intelligence in a work environment, including manipulating data sets, analysing data, presenting findings in appropriate formats and making recommendations
- Experience of working with complex, conflicting and contentious information
- Experience of using, creating and developing databases in SQL Server, in a work environment (including creating complex queries using structured query language to interrogate the data, creating procedures and reports)
- Experience of developing applications in Excel (using formulae, functions, complex calculations and other statistical techniques, plus the use of Visual Basic for Applications to automate spreadsheets)
- Experience in using Data Visualization Tools (Tableau, Power BI and Visual Studio Software)
- General knowledge of computer hardware and software and constant updating of that knowledge
Knowledge and Skills
- Ability to analyse complex and sometimes conflicting data sets, with a logical approach
- Ability to develop, maintain and adapt databases and spreadsheets for personal use as well as the use of others in a changing environment
- Ability to tailor business intelligence systems to meet users requirements
- Ability to solve problems and make informed recommendations based on detailed data analysis
- Excellent numeracy skills, with the ability to use statistical techniques
- Ability to concentrate when carrying out detailed analysis over sustained periods
- Excellent written and oral communication skills
- Ability to manage/organise own workload and plan work according to changing priorities and deadlines
- High level of personal motivation with the ability to work independently using own initiative, or as part of a team
- Ability to make own decisions on how issues should be resolved and how results are best achieved, implementing those decisions as appropriate
- Ability to promote and deliver a customer focused service
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.
Certificate of Sponsorship
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.
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.
Employer details
Employer name
London Ambulance Service NHS Trust
Address
London Ambulance Service NHS Trust
220 Waterloo Road
London
SE1 8SD
United Kingdom
Employer's website
https://www.londonambulance.nhs.uk/