BI Analyst

East Lancashire Hospitals NHS Trust; United States; Hybrid; USD 56,000 - 72,000; Full time

Benefits offered by this job

Training & certification

Flexible / Agile working

Microsoft Enterprise Skills Initiative

Job summary

East Lancashire Hospitals NHS Trust is seeking a BI Analyst to join a growing analytics team. You will extract data, build reports, and support statutory reporting for internal and external audiences. The role focuses on NHS data, ETL processing, and visualisation using a mature EPR system.

You will access extensive training and development, including Microsoft Enterprise Skills Initiative, and benefit from an agile/home working delivery model across BI services.

Qualifications

• Good general education including at least 3 GCSEs including English & Maths.
• Evidence of ongoing professional development.
• ECDL; ability to derive key messages from complex information and present clearly.
• Experience handling large data sets and using SQL.
• Strong written and verbal communication skills.

Responsibilities

• Provide daily assistance to Senior Analysts; extract data and populate templates for established reports.
• Meet statutory and internal reporting deadlines via daily, weekly, monthly and quarterly cycles.
• Utilise and develop data sources to create standard information for service users.
• Run reports as required by the Senior Analysts and BI team.
• Support data visualisation efforts to present insights to service users.
• Engage with PbR/SLR, BI, Performance and Finance teams to build relationships.

Skills

SQL

ETL

Data viz

Analytical

Communications

Education

GCSEs including English & Maths

ECDL

Tools

SSIS

SSAS

Job description

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 statutory reporting 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 skills in 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 Electronic Patient Record system. What can we offer you - access to extensive opportunities for training and development, career progression with free access to Microsoft Enterprise 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., This is an exciting opportunity for an applicant looking to start their career journey within Business Intelligence. You will develop a thorough understanding of NHS data, how to process data and report to both internal and external audiences. You will be given access to extensive training and development to build you technical skill set including but not limited to SQL, ETL Processing (SSIS and SSAS) and data visualisation tools. You will, over time develop the skills to analyse and report on large, complex data sets and deliver through appropriate tools for data visualisation 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 supports training and skills development to help you achieve your personal and career development objectives and promotes agile/home working opportunities 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 your potential. Together, we have created a supportive, inspirational, innovative, and vibrant workplace.

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

• Good general level of education including a minimum of 3 GCSE's or equivalent including English & Mathematics.
• Evidence of on-going professional development.
• ECDL, 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, 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.

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.

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.

The Trust is an equal opportunities employer, is committed to improving the working lives of its colleagues and operates a 'Zero Tolerance' policy on aggression, violence, bullying and harassment. As a recruitment service, our aim is to help protect children and vulnerable adults by providing a first-class service in recruiting people into positions of trust. It is important to us that we 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 as an employer we are under-representation of BAME employees. Appointments will be made on merit. We recognise that the recruitment process may present barriers for some and you may need personal adjustments to enable you to participate in our recruitment process. Please make contact with the recruitment team at the earliest opportunity to ensure that measures can be put in place to enable you to apply for this post.

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.

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.

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.