Senior Business Intelligence Analyst
- Senior Business Intelligence Analyst
- Band 7
- Fixed term: 12 months (or Secondment - 12 months)
- Full time - 37.5 hours per week
- Waterloo HQ
- £45,780 - £51,393 per annum inclusive of HCAS
- 27/07/2021 23:59
London Ambulance Service covers an area of 620 sq. miles, serves one of the world’s most dynamic and diverse cities and is the busiest ambulance service in the UK. We handle over 1.9 million emergency calls from across the capital and attend more than 1.2 million incidents every single year as well as delivering a 24 hour NHS 111 Integrated Urgent Care Service in South East and North East London that we estimate will respond to around 1.4million urgent care calls by the end of the year.
We employ over 8,000 people who work or volunteer across London to respond to the health needs of over eight million people who live, work and travel in the capital. We work closely with our NHS partners and are commissioned by 32 clinical commissioning groups spread across 5 sustainability and transformation partnerships (STPs) and NHS England for our specialist services. We work alongside London’s hospital, mental health and specialist trusts, as well as the five STPs across Greater London.
In addition we work in partnership with the other emergency services, London’s Air Ambulance and London’s Resilience Forums to make sure we are ready and prepared to respond to major incidents and ensure we keep Londoners safe. As the only pan-London NHS provider we have a unique opportunity to play a leading role in integrating access to emergency and urgent care right across London.
By 2023 we will improve outcomes and experiences for all our patients by providing the right care to patients at the right time, and in the most cost effective way. This will mean up to 122,000 fewer patients being taken to emergency departments when their needs could be better met in a different way, and we will deliver significant efficiencies in avoided costs to the urgent and emergency care sector.
LAS Senior Business Intelligence Analysts are instrumental in providing and communicating statistical information about the Trust, including activity and performance data, generating insight, and developing interactive visualisation tools, driving forward our ambition of making the LAS a world-class service. Working on a variety of diverse projects across the organisation, the role will include many aspects of business intelligence, from supporting Operational and Corporate services, providing evidence for business and strategic decision making, to Corporate Reporting delivery, allowing the production and distribution of the Chief Finance Officer’s Integrated Performance Report and Chief Executive Officer’s performance packs for all management levels, external stakeholders and Trust Board. Recommendations derived from your work will shape the delivery of an evolving service in a challenging healthcare environment.
Main duties of the job
An exciting opportunity has arisen for a twelve month secondment as a Senior Business Intelligence Analyst within the Corporate Reporting team. This is an exciting and challenging role for an individual who enjoys working in a fast paced, demanding and evolving healthcare environment. You will join a technically minded team as part of a high profile and influential organisation. This is a great opportunity for someone interested in using their analytical and technical skillset to tackle Trust challenges helping to drive transformational change. The role will also involve communication with colleagues from across the strategic, operational and executive teams, and so confidence in presenting sensitive and complex findings to non-technical audiences is essential. The ideal candidate will have knowledge of areas such as:
- Microsoft Office
- Coding (SQL)
- Advanced analytics & data visualisation/reporting
- Supervised and unsupervised learning
- Effective communication and presentation
Working for our organisation
London Ambulance Service NHS Trust is the busiest ambulance Trust in the UK. We are seeking someone who will fit with the Trust values of being respectful, professional, innovative and collaborative. The team is well established in the organisation and central to strategic and operational planning. We are part of the wider Performance and Analytics directorate who together cover corporate reporting, data quality, business intelligence, and forecasting and planning for urgent and emergency healthcare services. The directorate is key to ensuring that LAS is a data driven organisation, with decisions being informed by timely and high quality analysis.
Annual leave starts at 27 days rising to 33 days, plus bank holidays, in line with Agenda for Change. Employees can access Blue Light (emergency services) discounts as well as NHS discount schemes.
Detailed job description and main responsibilities
Extract and manipulate complex and extremely varied data from different databases, for all levels of management
Provide support for managers and other users in the interpretation and analysis of complex information, particularly where data is controversial or where different components of that data may conflict
To influence data collection procedures outside the department which affect information provision, including the design of operational forms within the service
Develop existing and new databases (using SQL Server or MS Access) and complex spreadsheets (using Excel) to improve information gathering and analysis
Produce statistical information packs for all management levels including the Executive Board and external organisations, collating and analysing complex information from a number of different areas of the service, including highlighting trends and comparing data on demand, performance, vehicle and control room staffing and vehicle utilisation
Analyse and manipulate data from a variety of internal sources (including activity, manning, staffing and call taking data) whilst supplementing this with information from a variety of external sources (including Census data, weather data etc) to aid in the interpretation of patterns in activity, performance and geographic trends
Present, interpret and explain complicated statistical information to large groups at meetings, to influence operational decisions
Applicants are advised to read all the information enclosed in the advert and the supporting information before completing and submitting an application. As you complete your application please ensure you clearly demonstrate how you meet the criteria in the person specification for this post by adequately completing the supporting information section of the application form.
Priority will be given to staff at risk candidates.
We reserve the right to close the application window early if we receive a high volume of suitable applications.
Qualifications, Accreditations, Education
- Graduate level of education or equivalent experience and expertise of providing business intelligence in a work environment
- GCSE mathematics or equivalent
- Extensive 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
- Extensive experience of working with complex, conflicting and contentious information
- Extensive experience of using, creating and developing databases in SQL Server or MS Access in a work environment (including creating complex queries using structured query language to interrogate the data, creating procedures and reports)
- Extensive 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)
- General knowledge of computer hardware and software and constant updating of that knowledge
- Experience of supervising staff
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
- Accurate with attention to detail
- Ability to concentrate when carrying out detailed analysis over sustained periods
- Excellent written and oral communication skills
- Excellent interpersonal skills, including ability to negotiate and persuade
- Ability to use different influencing skills appropriate to the outcomes of findings, especially when findings do not support initial assumptions or expectations
- Diplomatic and tactful
- 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 delegate and supervise the work of others within the department
- Ability to promote and deliver a customer focused service
- Adhere to the Trust values and behaviours
- Commitment to and understanding of Equal Opportunities and Diversity both as an employee and a provider of services to the public
- Evidence of reliability
- Positive attitude towards learning and development demonstrated by a record of continuing professional development
- No current or pending disciplinary sanctions
Applications from job seekers who require sponsorship to work in the United Kingdom (UK) are welcome and will be considered alongside all other applications. Please note that from January 2021, to work in the UK all candidates who are not UK or Republic of Ireland (RoI) nationals require sponsorship unless you have permission to work via another route. Non UK / RoI candidates wishing to apply can self-assess the likelihood of obtaining a Certificate of Sponsorship here. It is vital that you provide full and accurate details of your current immigration status on the application form. Overseas applicants applying for entry clearance into the UK must present a criminal record certificate from each country they have resided in continuously or cumulatively for 12 months or more in the past 10 years. Guidance can be found here. Not everyone needs a ‘Skilled Worker’ visa. If you are applying for a vacancy in health or adult social care, check if you’re eligible to apply for the Health and Care Worker visa instead. It’s cheaper to apply for and you do not need to pay the annual immigration health surcharge
Documents to download
Further details / informal visits contact
- Rommel Casaclang
- Job title
- Business Manager
- Email address