Senior business intelligence analyst

Medway Community Healthcare NHS Foundation Trust; Gillingham; On-site; GBP 40,000 - 55,000; Full time

Job summary

Une opportunité passionnante se présente pour un Senior Business Intelligence Analyst au sein d'une entreprise sociale dynamique. Le candidat idéal doit posséder une expérience en SQL et en Power BI, ainsi qu'une solide capacité d'analyse de données. Ce rôle critique implique de soutenir des décisions basées sur des données pour améliorer les services de soins aux patients à Medway Community Healthcare.

Benefits

Two pension scheme options

In-house training

Flexible working arrangements

Qualifications

• Grade en informatique ou expérience pertinente exigée.
• Compétences avancées en SQL et Power BI.

Responsibilities

• Coordonner le travail quotidien de l'équipe d'intelligence d'affaires.
• Produire des données de performance précises et opportunes.

Skills

SQL

Power BI

Data Analysis

Communication

Attention to Detail

Education

Degree or relevant experience

Tools

Microsoft Excel

Job description

This job is brought to you by Jobs/Redefined, the UK's leading over-50s age inclusive jobs board.

Do you want to be part of an award winning and dynamic social enterprise that:

• is renowned for providing high quality care and is ranked 'Good' by the CQC;
• is a for-better-profit organisation, reinvesting any surplus back into our health and care services and our local community;
• is friendly, ambitious, welcomes innovation and rewards excellence;
• offers superior benefits; everything you get in the NHS and more;
• and whose achievements reflect the passion, dedication and commitment demonstrated by our staff across all services?

Our vision is to be a successful, vibrant, community interest company that benefits the communities we serve. So if you want be a part of this, we would love to hear from you.

Job overview

Job overview

• Are you a highly motivated and efficient team player, who can also work on your own initiative?

If you answered yes, we've got the perfect role for you!

An exciting opportunity has arisen for a self-starting and enthusiastic individual to join our innovative and fast paced business intelligence team.

We are looking to appoint a pro-active and dynamic individual with the confidence to engage with others across all levels of the organisation and wider health economy.

Main duties of the job

To support the organisation with analysis and reporting on a wide range of topics and service areas, and to contribute to improving quality in respect of patient activity data that is captured by community services.

To use SQL and other Microsoft tools, to extract data from source systems to produce analytic reports, visualisations and outline findings on a range of topics.

The post-holder will provide high quality, timely and accurate information to enable Medway Community Healthcare to provide effective patient services.

Working for our organisation

So what else?

• This is your chance to join a progressive and innovative service in a social enterprise that is patient and staff focused - you'll even have the opportunity to become an MCH shareholder.
• We encourage staff to get involved in exploring new ways of working and service development.
• We'll provide well established, in-service training, one to one supervision, and appraisals with regular support.
• You'll be able to develop your skills in a friendly and supportive team.

Would you like to work flexibly? In the NHS, we are reminded every day of how important work life balance is. As a flexible working friendly organisation, we want to be sure that you can work in a way that is best for us, for our patients and for you. Speak to us about how we might be able to accommodate a flexible working arrangement.

The small print

• We will offer you the choice of two pension schemes; the NHS Pension scheme and the scottish widows group pension scheme.
• MCH encourages all staff to be double COVID vaccinated to protect themselves, their colleagues, their family and their patients.

Detailed job description and main responsibilities

The Senior Business Intelligence Analyst is responsible for:
• Co-ordinating the day-to-day work of the business intelligence team to ensure it meets its deadlines and delivers high quality business support to its customers.
• Providing the Business Intelligence Analyst with support and guidance to develop their technical SQL skills.
• Provide advice on data reporting for mobilisation of new services and support the development of current and future reporting requirements.
• Developing a culture that improves quality in respect of patient activity data.
• Support and assist in yearly contract refresh for activity and capacity planning.
• To develop national minimum data set reporting and provide assurance against timescales for delivery and reporting requirements.
• To produce accurate and timely performance data by:

o Ensuring collation of patient activity data from a variety of systems for internal management and for contract performance meetings

o Monitoring the processing of data and information

o Assurance on data quality addressing issues with services where required
• Advise and support service leads to help improve the accuracy and consistency of their activity recording and reporting to minimise data and information gaps.
• Develop and implement effective models of interrogating and presenting monthly and quarterly performance data across multiple services, highlighting areas for change /investigation.
• Build good working relationships with various stakeholders (internal and external).
• Ensure the Business Intelligence team can produce, interrogate and report on the portfolio of performance data via Power BI.

Full JD can be found in the attachments

Person specification

Qualifications & Experience

Essential criteria

• Educated to degree level or relevant experience
• Excellent IT skills with intermediate level knowledge of excel and Power BI
• Knowledge of SQL and coding

Desirable criteria

• Previous role as an analyst
• Experience of SQL coding at intermediate level
• Experience using SSRS/SSMS/SSAS

Knowledge

Essential criteria

• Knowledge of NHS data sources and information
• Knowledge of NHS data protection and information governance

Desirable criteria

• Experience working in the public sector, particularly healthcare
• Clear understanding of NHS data sources and information flows

Experience

Essential criteria

• Experience of data analysis and manipulation
• Experience of use of various IT systems
• Experience of improving processed and/or reporting solutions

Desirable criteria

• Experience using EPR systems
• Experience using Power BI

Practical and Intellectual skills

Essential criteria

• Excellent communication and skills and a strong communicator
• Ability to manage and prioritise conflicting and demanding workloads and deadlines
• Excellent attention to details

Desirable criteria

• Proactive and solution focused
• Flexibility and willingness to perform adhoc duties as and when required to support the wider team
• Understand expectations of stakeholders and recognise when issues/events may effect delivery

MCH values

Essential criteria

• Good understanding of MCH values

We reserve the right to close this advert earlier than the published closing date if we receive a sufficient number of applications. Shortlisted candidates will be contacted within 1 week of the closing date; no discourtesy is intended in not contacting you if your application is rejected.

When completing your application, please include the email addresses and contact telephone numbers for your referees; your referees should be your line managers / course tutors for the last 3 years.

MCH is an equal opportunity employer that is committed to a compassionate and inclusive workplace and values diversity of all people. We prohibit unlawful discrimination and harassment of any kind and wish to provide our employees with a work environment free of discrimination and harassment. At the heart of our values, we seek to treat people fairly and with dignity and respect and provide a workplace where people feel they belong.

We aspire to have a diverse and inclusive workforce and strongly encourage suitably qualified applicants from a wide range of backgrounds to apply and join MCH. We are positive about disability and we guarantee interviews to applicants with a disability who meet the minimum criteria as specified in the job description. We are committed to offering support and making reasonable adjustments to allow full participation in the interview and selection process and through their employee journey.

We are committed to the safeguarding and welfare of children and vulnerable adults.

Employer certification / accreditation badges

Application numbers

There is an applicant cap set on this vacancy, once the capped application number has been received, applications will close.
Documents to download

• Senior Business Analyst (PDF, 496.3KB)
• Working with us v2.6 2023 - 2024 (PDF, 1.5MB)
• Social Value Report 2022-2023 (PDF, 2.0MB)
• Our flexible working commitment (PDF, 672.2KB)