Business Intelligence Analyst (Internal Only)

This position is open to staff working at the Trust in the 'ECT Family' this includes current East Cheshire NHS Trust employees, both NHSP and ECT bank staff, ISS staff and volunteers at the Trust. Unfortunately, we cannot accept applications from applicants not listed within these groups.

If you would like to apply for this position please complete the attached Short Application Form and email this to the Recruitment Team at: ecn-tr.recruitment@nhs.net clearly marking for which vacancy you are applying for in the Subject Header of the email. Please note applications received after the closing date and time will not be accepted.

Join our dynamic Data & Analytics team as a Business Intelligence Analyst and play a key role in ensuring timely and accurate submission of critical performance reports. Working closely with colleagues across the Trust, you'll extract, validate, and analyse data to create dashboards and reports that inform clinical and operational decisions. In this role you will work with SQL and Power BI to develop innovative, automated solutions and support the Trust's data warehouse development.

We are committed to supporting your career growth with opportunities for continuous professional development (CPD). Whether it's enhancing your technical skills or broadening your knowledge in business intelligence, you'll be encouraged to reach your full potential in a collaborative and supportive environment.

Hours per week: 37.5

Main duties of the job

As a Business Intelligence Analyst within the Trust's Data & Analytics Department, you will play a pivotal role in delivering high-quality data solutions that support clinical and operational decision-making. Reporting to the Business Intelligence Manager, you will be responsible for managing and submitting key performance reports (e.g., SITREPs) and ensuring their accuracy and timely delivery.

In this role, you will:

1. Extract, validate, and analyse complex datasets from acute and community systems.
2. Develop dashboards, scorecards, and automated reporting tools using SQL, Power BI, and other technologies.
3. Liaise with colleagues across the Trust to improve data quality and ensure compliance with national reporting standards.
4. Respond to ad hoc requests for information from managers, clinicians, and external stakeholders.
5. Support the development of the Trust's data warehouse and other clinical information systems.

This position offers an exciting opportunity to work with large, sensitive datasets and collaborate with multidisciplinary teams to enhance the Trust's business intelligence capabilities. You will also be instrumental in ensuring that data-driven insights contribute to the delivery of exceptional healthcare services.

About us

It is all about the people at East Cheshire NHS Trust. We have a real sense of community, and our values are truly embedded into everything we do, ensuring we are a great and inclusive place to work. You will be supported, developed and empowered throughout your career with us. Come and join us, where you can play your part in helping us deliver outstanding care and improving the health of all the people we serve.

COVID-19 vaccination remains the best way to protect yourself, your family, your colleagues and of course our patients from the virus when working in our healthcare settings. Whilst COVID-19 vaccination is not a condition of employment, we do encourage our staff to get vaccinated. We will be checking the vaccination status of all new starters as part of ongoing monitoring.

Job description

Job responsibilities

Please read the attached Applicant Pack prior to completing your application form to find out more information.

Please download a copy of the Job Description and Person Specification located under the Supporting documents heading to read more about the advertised role.

As part of making your application we encourage you to review the Trusts Careers webpage www.careersateastcheshire.nhs.uk for more information about working for East Cheshire NHS Trust.

We are an equal opportunities employer and welcome all applications irrespective of age, disability, gender, sexual orientation, race or religion. The Trust is a Disability Confident Leader and as such, applicants with disabilities will be offered an interview providing they meet the minimum criteria for the post (outlined in the Person Specification).

Applicants are advised to apply early as we reserve the right to close the advert prior to the advertised closing date should we receive a large number of applications.

We look forward to receiving your application.

Person Specification

Qualifications

Essential

1. Degree or equivalent higher education qualification or minimum 2 years' experience in a specialist IT role

Desirable

1. Evidence of further professional development

Knowledge

Essential

1. Knowledge of relational databases and data warehousing principles
2. Working knowledge of data visualisation and business intelligence tools
3. Understanding of data cleaning and data quality concepts

Desirable

1. In depth practical knowledge of NHS data dictionary, common datasets and NHS central returns
2. Familiar with Acute and Community health services
3. Understanding of NHS Data standards
4. Familiarity with NHS acute and community clinical and administration systems

Skills

Essential

1. Ability to understand and gather requirements from stakeholders in order to develop effective reporting/data solutions
2. Competent in the use of SQL
3. Understanding of database design, creation, tables, permissions, etc.
4. Good interpersonal and communication skills to all levels of staff
5. Good analytical and problems solving skills, effectively using tools available
6. Good presentation skills in all media - verbal, written, visual etc.
7. Ability to analyse and present highly complex information and to communicate complex concepts to staff from non-IT backgrounds.
8. Working knowledge of performance management software such as CHKS iCompare

Desirable

1. Competent in the use of programming languages such as Python or R
2. Competent in the use of the Microsoft BI Stack, including SSIS, SSRS and SSAS
3. Competent in the use of Power BI & DAX

Experience

Essential

1. Use advance features of MS Excel, including functions and pivot tables, to manipulate and present data.
2. Evidence of continual professional development

Specific Job Requirement

Essential

1. Professional image and helpful attitude
2. Team worker with a flexible approach to team and partnership working
3. Evidence of ambition, enthusiasm and eagerness to see a job well done
4. Able to concentrate for significant periods of time on complex issues, and to cope with rapidly changing priorities and urgent requests
5. Able to meet deadlines, balance competing priorities and meet personal and directorate targets within a fluctuating and demanding workload
6. Evidence of working effectively as part of a team.
7. Commitment to self-development and keeping up-to-date with software/course development

Employer details

Employer name

East Cheshire NHS Trust

Address

Macclesfield District
General Hospital
Victoria Road, Macclesfield
SK10 3BL

Any attachments will be accessible after you click to apply.

209-A-24-6811150