Data Analyst

Job description

Job responsibilities

Key Duties and Responsibilities:

• Maintain, develop, and optimise Power BI dashboards to support Integrated Urgent Care (IUC) reporting, NHS performance metrics, and local intelligence.
• Build and troubleshoot Power BI semantic models, ensuring scalability, accuracy, and resilience against common report failures.
• Use Power Query (M), DAX, and SQL (desirable) to create dynamic, reusable, and auditable logic across reports.
• Automate data workflows using Power Automate to streamline cloud-based reporting processes and reduce manual interventions.
• Respond to ad hoc data requests from internal stakeholders, NHS colleagues, and ICB partners with professionalism and speed.
• Collaborate with NHS and ICB teams, supporting regular and scheduled submissions of reports and datasets.
• Ensure high levels of data quality and consistency, reconciling report outputs against expected results and resolving discrepancies.
• Understand NHS terminology and IUC service models, applying healthcare knowledge to design insightful and policy-relevant visualisations.
• Manage and transform datasets in Microsoft Excel, integrating spreadsheet-based workflows into broader reporting systems.
• Identify and resolve issues that lead to report failures, including ambiguous relationships, performance bottlenecks, or data anomalies.
• Document and maintain clear measures, calculations, and visuals to ensure transparency and auditability.
• Communicate complex analytical insights clearly to clinical, operational, and non-technical audiences across the organisation.
• Work independently and collaboratively, using initiative to deliver high-quality solutions while engaging effectively with team members.
• Leverage skills within data warehousing environments to support scalable data architecture and optimise back-end data pipelines (desirable).
• Work closely with IT, Business Partners and Key Stakeholders on various projects as required by the Business.

General

• All employees and teams are expected to:

- Respect each other and be courteous and sensitive to everyone's needs and concerns

- Be accountable for your work

- Be flexible about job and task assignments

- Be willing to help each other instead of displaying an its not my job attitude

- Ask for help when needed

- Work safely together

- Be open to constructive feedback without being defensive or negative

- Be self-motivated and reliable

- Share ideas for improvement

- Be cheerful, positive, and encouraging to other team members

• Actively contribute to the Organisations values and behaviours ensuring that relevant processes are open and transparent and encourage the confidence of staff, patients, partner organisations, the public and other agencies.
• Promote a positive organisational image.
• Promote own personal and others health, safety, and security, taking the appropriate action to report risk in accordance with policy.
• Ensure that equipment and resources are managed effectively to reduce waste and promote cost efficiency.
• Ensure the safe keeping and maintenance of equipment in accordance with policy, reporting defect or loss.
• Maintain personal development to meet the changing demands of the job, participate in an annual appraisal and appropriate training activities.
• Ensure compliance with all Kernow Health CIC statutory and mandatory training requirements, policies and protocols.
• Take appropriate responsibility to ensure that your objectives are aligned with the core team and organisational objectives.
• To demonstrate agility through adapting to the needs of the organisation by working flexibly in response to changing organisational requirements and priorities.
• You will be expected to carry out any other duties that may reasonably be required in line with your main duties, as directed by your line manager.

Person Specification

Skills & Abilities

• Excellent organisation skills
• Able to deal with a wide range of tasks
• Able to meet competing deadlines
• Able to use initiative and prioritise tasks
• Able to work through tasks logically and systematically with attention to detail
• Able to maintain confidentiality

Experience

• Advanced experience with Power BI (including DAX, Power Query, semantic models)
• Strong Microsoft Excel skills (pivot tables, formulas, data modelling)
• Experience identifying and resolving issues causing Power BI failures
• Ability to work independently and manage complex reporting tasks
• Understanding of NHS terminology and data processes
• Excellent written and verbal communication skills
• Experience responding to ad hoc data/reporting requests
• Attention to detail and ability to reconcile data with expected outputs
• Strong analytical and problem-solving skills
• Commitment to maintaining high data quality and governance standards
• Excellent and extensive experience of Microsoft Office, particularly Word and Excel
• Familiar with Outlook or NHS Mail

• Knowledge of Power Automate for cloud automation tasks
• Familiarity with data warehousing concepts and SQL for back-end support
• Experience in Integrated Urgent Care or similar healthcare setting
• Experience collaborating with stakeholders including ICB and NHS teams

Personal Qualities

• Excellent communication skills
• Ability to remain calm and focussed when busy
• Able to work with people at all levels
• Natural collaborator and team contributor
• Honesty and openness
• Taking ownership - a can do attitude
• Reliable and self-motivated
• Flexibility and ability to adapt especially when there are conflicting pressures
• Unrestricted access to a motor vehicle in order to travel if required.
• Willing to undertake training as necessary to the requirements of the role

Disclosure and Barring Service Check

This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions.

Employer details

Employer name

Kernow Health CIC

Address

Cudmore House

Treliske Industrial Estate

Truro

Cornwall

TR1 3LP

Employer's website

https://www.kernowhealthcic.org.uk