Business Intelligence Analyst

Elht; Preston; Hybrid; GBP 28,000 - 36,000; Full time

Benefits offered by this job

Training and development

Flexible working

Microsoft Enterprise Skills Initiative

Job summary

East Lancashire Hospitals NHS Trust, hosting One LSC, is seeking a BI Analyst to join a growing team of about 20 analysts and engineers. You will extract data, build reports, and enable decision makers with analytics across up to 40 clinical specialties.

You will gain extensive training, development opportunities, and flexible working options within our mature Electronic Patient Record environment.

Qualifications

• This role requires experience deriving messages from complex data and presenting insights.
• Experience managing multiple tasks and delivering timely reports.
• Proficiency in SQL and data visualisation tools is essential.

Responsibilities

• Provide daily assistance to Senior Analysts, extracting data and populating reports for managers and external bodies.
• Support statutory and internal reporting deadlines with daily, weekly, monthly, and quarterly processes.
• Develop standard information from existing data sources for service users.

Skills

SQL

ETL processing

Data visualisation

Communication

Education

GCSEs English and Maths

ECDL

Tools

SSIS

SSAS

Job description

Information aboutwork experience and work shadowing canbe found by clicking here .

One LSC is a new collaborative partnership shared service formed by the five NHS Trusts serving the Lancashire and South Cumbria population of 1.8 million people. We are a shared service run by the NHS, for the NHS and are hosted by East Lancashire Hospitals NHS Trust on behalf of the partner Trusts of the Lancashire and South Cumbria system.

One LSC stands for 'One Lancashire and South Cumbria' and reflects the Lancashire and South Cumbria System ambition to have one team serving Lancashire and South Cumbria in a joined-up way. It is jointly run by the five Trusts as a collaborative partnership.

The Trusts that make up One LSC are:

Blackpool Teaching Hospitals NHS Foundation Trust

East Lancashire Hospitals NHS Trust

Lancashire and South Cumbria NHS Foundation Trust

Lancashire Teaching Hospitals NHS Foundation Trust

University Hospitals of Morecambe Bay NHS Foundation Trust

One LSC brings together the Digital, Data and Technology, Estates and Facilities, Finance, People Services and Procurement and Logistics services from each of the provider Trusts to create one central community of professionals. Under one leadership team, they will provide services for and on behalf of all Trusts.

The aim is to bring services more closely together so that we can deliver the best service possible to each of our partner organisations. At the core of One LSC delivery is eliminating duplication, removing unwarranted variation, realisation of the benefits of sharing common systems and processes and ensuring we deliver value for money for our partners, our system and, ultimately, for the communities we serve.

Job overview

Do you want to be part of talented and expanding Business Intelligence team building innovative analytics products that help to inform and empower our decision makers? As a BI Analyst you will support the team to extract knowledge for our clinical and operational teams, hungry for analytics to optimise clinical care and performance and for our vibrant research community. You will support our organisation to meet its statutoryreporting responsibilities, delivering key areas of reporting to external partners and national bodies.

You will join a group of approximately 20 Business Intelligence Analysts and engineers and you will have options to increase and hone your skillsin multiple BI related areas covering up to 40 clinical specialties. You will be given the opportunity to develop skills to analyse and report on large,complex data sets and deliver through appropriate visualisation tools; utilising a range of complex data sources derived from our mature ElectronicPatient Record system.

What can we offer you – access to extensive opportunities for training and development, career progression with free access to MicrosoftEnterprise Skills Initiative which includes include training, exams and certifications. Access to an agile/home working model of delivery across all our Business Intelligence services that maximises flexible working for all our staff.

Main duties of the job

This is an exciting opportunity for an applicant looking to start their career journey within Business Intelligence. You will develop a thoroughunderstanding of NHS data, how to process data and report to both internal and external audiences. You will be given access to extensivetraining and development to build you technical skill set including but not limited to SQL, ETL Processing (SSIS and SSAS) and data visualisationtools. You will, over time develop the skills to analyse and report on large, complex data sets and deliver through appropriate tools for datavisualisation and reporting that provide you with an extensive skill set to continue your career journey.

Your main duties will include:

• Provide daily assistance to the Senior Analysts, extracting data and populating templates for specified established reports for service managers, corporate managers, external organisations and statutory bodies
• Provide informatics support to meet all statutory and internal reporting deadlines utilising processes for daily, weekly, monthly and quarterly reporting within the trust and to external organisations
• Utilise and further develop existing data sources to support the development of standard information for users of the service

Working for our organisation

Our commitment to our staff is to create the best place for them to work so you will be joining a Business Intelligence team that actively supportstraining and skills development to help you achieve your personal and career development objectives and promotes agile/home workingopportunities for all. We are a dedicated, extremely busy, hard-working, and friendly team who will help you to flourish in your new role.

As a member of the OneLSC, you will be working as part of a collaborative, friendly and caring team of incredible people who are committed to providing excellent care with compassion. We celebrate diversity, encourage everyone to contribute, and you are valued for who you are.

Together, we can create your future. You will be supported to achieve your personal goals and build the career you want. You will have access to our world-class education facilities and award-winning leadership and learning programmes - so this is the perfect place for you to achieve yourpotential. Together, we have created a supportive, inspirational, innovative, and vibrant workplace.

Detailed job description and main responsibilities

Further details are available in the detailed Job Description and person specification. The main responsibilities of the post are:

• Provide daily assistance to the Senior Analysts, extracting data and populating templates for specified established reports for service managers, corporate managers, external organisations and statutory bodies
• Liaise with relevant individuals to ensure that any data is collected in an accurate and timely manner
• Ensure all deadlines for information provision are met by planning and organising work in response to continually changing priorities
• Run reports as specified and required by the senior analysts
• Provide informatics support to meet all statutory and internal reporting deadlines utilising processes for daily, weekly, monthly and quarterly reporting within the trust and to external organisations
• Work within the BI team in providing information as per agreed timescales
• Establish effective working relationships with key personnel in the PbR/SLR, Business Intelligence, Performance, Finance and Divisional Teams relevant to the role
• Report effectively, in written, verbal or electronic format as required
• Utilise departmental operational procedures to run reports, updating procedures as processes are refined
• Provide analysis support to respond to activity queries and requests
• Quality assure relevant procedures and process documents ensuring changes are reflected into documentation
• Become proficient in the interpretation of user requirements into ad hoc reports
• Utilise and further develop existing data sources to support the development of standard information for users of the service
• Work independently with Trust staff, but with support and guidance from the Senior Business Intelligence team members
• Become proficient in the use of the Trusts data visualisation tools to analyse and present data to service users

Person specification

Qualifications & Education

• Good general level of education including a minimum of 3 GCSE’s or equivalent including English & Mathematics
• Evidence of on-going professional development
• ECDL

Knowledge & Experience

• Experience of deriving key messages from complex information and large data sets and presenting in a user friendly format
• Experience of managing a varied range of tasks and activities
• Experience of analysing large data sets
• SQL Skills

Skills & Abilities

• Good written and verbal communication skills and the ability to present information logically and concisely
• Good all round numeracy skills, problem solving abilities and logic
• Good interpersonal skills in order to liaise with health professionals at all levels across the organisation

• Please note that the salary advertised is for full time hours. If this post is less than 37.5 hours per week, the salary will be pro-rata. For posts on Agenda for Change pay-scales, new entrants to the NHS will normally commence on the first pay point of the relevant band.
• This vacancy may close before the closing date if the recruiting manager deems sufficient applications have been received. Therefore it is advised to complete your application as early as possible to avoid disappointment.
• Please ensure you check the email account from which you apply regularly as we will use this to contact you regarding your application.
• Please note that shortlisting is completed anonymously with candidates being assessed against the essential criteria for the post. Therefore only applicants, who can clearly demonstrate how they meet our person specification criteria in their application, will be short-listed.

Disclosure and Barring Scheme (DBS)

If the role you are applying for is identified as either controlled or regulated activity as defined in in the Safeguarding vulnerable Groups Act (2006) any offer of employment is provisional upon a satisfactory DBS check being obtained.

The healthcare sector is exempted from the Rehabilitation of Offenders Act 1974.

In line with other NHS organisations in the North West Region, the Trust is now passing the charge for undertaking a DBS check on to candidates in the event they are successfully appointed into the post for which they have applied. Candidates can choose whether to pay this over 1-3 months as a deduction from the monthly salary. However, if you are applying for a post as a BANK worker, the payment must be made in full at the time of employment checks. By applying for this vacancy you are agreeing to this undertaking in the event you are successfully appointed.

The cost for an Enhanced DBS, is £45.90 and for a Basic & Standard, this is £24.90 this cost includes a £4.90 admin fee.

This cost is not applicable for a Volunteer post

The Trust is an equal opportunities employer, committed to improving the working lives of our staff and operates a 'Zero Tolerance' policy to aggression, violence, bullying and harassment. In addition, our aim is to help protect children and vulnerable adults by providing a first-class service to the recruitment of people into positions of trust.

We aim to employ a workforce that reflects the diverse communities we serve.

We welcome applications from everyone irrespective of ethnic origin, gender, age, gender identity, sexual orientation, religion, marital status, disability or social background.

We especially welcome applications from members of our black, Asian and minority ethnic (BAME) communities, as we have identified that ELHT has an under-representation of BAME employees. Appointments will be made on merit.

Applicants who have a disability and meet the essential criteria for the job will be interviewed if you indicate you wish to be considered under the Guaranteed Interview Scheme.

If you require a reasonable adjustment at any stage of the recruitment process please make the recruitment services team aware as soon as possible. By telephone [phone] or email [e-mail] write to Employment Services, Parkview Offices, Haslingden Road, Blackburn, BB2 3HH

If you choose to use AI or other tools to assist in writing your application, it's essential to personalise this information, particularly your supporting information section. While AI can help streamline the writing process, these tools cannot fully grasp the context or requirements of the job you’re applying for. There is also a risk that it can generate false or misleading information.

AI-generated job applications can often be generic, impersonal and may not accurately reflect your qualifications, knowledge, skills, and experiences. It is crucial that you personalise your supporting statement by articulating these in your unique voice. Relying solely on AI to write your application or supporting information section is not advocated by East Lancashire Hospitals NHS Trust and could negatively impact on your chances of success in the application process.

The supporting information section is an opportunity for you to showcase how your qualifications, knowledge, skills and experience align with the requirements and criteria outlined in the job description and person specification.

Recruiting managers score applications based on the criteria listed in the person specification. They will be looking for evidence of how you meet these criteria. To increase your chances of securing an interview, please provide examples of how you have applied your skills and knowledge in real-life situations. Share work-related successes and challenges you have navigated that align with the criteria. These could be from various aspects of your life, including work, education, and personal experiences.

Consider structuring your supporting information section with clear headings or bullet points. This approach will help both you and the recruiting manager navigate through your application more effectively.

Please note: a young person must be in part-time education or training until they’re 18. If you are under 18 we are unable to employ you on a full time basis, unless it is in an apprenticeship role.

Disclosure and Barring Service checks If the role you’ve applied for requires a Disclosure and Barring Services (DBS) check we will administer this on your behalf and the cost will be recovered from your salary, either as a one-off payment, or over 3 months. The level of check required depends on the role that you have been offered. Currently the charges are - Basic DBS check £26.40, Standard DBS check £26.40, Enhanced DBS check £54.40 and Enhanced DBS check with Barred List(s) £54.40. You should be aware that if you are successful in obtaining a position that requires a DBS check but later withdraw your application, you may be required to reimburse the cost of the DBS check. DBS checks remain free of charge for volunteer positions. The DBS Code of Practice can be accessed here .

In line with guidance from United Kingdom Health Security Agency, all staff and volunteers are required to comply with Trust Infection Prevention and Control processes in relation to safe working.

NO UNSOLICITED ADVERTISING COMPANY APPROACHES

Employer certification / accreditation badges

Click on the headings below to see which roles you'll find in eachcategory: