Data Analyst

Job description

Job responsibilities

Data quality & integrity

• Ensure data across all systems is accurate, complete, and consistent, supporting reliable reporting and analysis.
• Monitor, identify, and resolve data quality issues in collaboration with colleagues and Data Stewards and Owners for individual systems.
• Implement and refine data validation processes that safeguard integrity throughout the data lifecycle.
• Contribute to the development of organisation-wide data quality frameworks, standards, and best practices.
• Maintain compliance with internal governance processes as well as external regulatory requirements.

Data analysis & reporting

• Develop, maintain, and optimise PowerBI reports, dashboards, and datasets to support operational teams, senior management, and Trustee-level oversight.
• Deliver analysis at descriptive, diagnostic, predictive, and prescriptive levels using PowerBI, MS SQL, and statistical techniques.
• Apply statistical and modelling techniques that go beyond traditional reporting, providing forecasts and recommended actions to inform decision-making.
• Provide actionable insights by identifying trends, patterns, and drivers that inform decision-making.
• Conduct ad-hoc and deep-dive analyses in response to immediate business questions, making clear recommendations based on findings.
• Collaborate with stakeholders to translate business questions into robust analytical outputs.
• Identify opportunities to improve and standardise reporting processes, enhancing efficiency and value.
• Apply innovation, including the use of AI and automation, to strengthen reporting and analytics.

Stakeholder engagement and collaboration

• Communicate complex findings clearly and accessibly to stakeholders across clinical, financial, HR, income generation, and executive areas.
• Support colleagues in interpreting and using data effectively to inform their own work and decision-making.
• Promote best practice in BI solution design, demonstrating the art of the possible in reporting and analytics.
• Work closely with the Data Engineering Resource to ensure seamless integration of data sources into the Microsoft Fabric Data Platform.
• Collaborate with colleagues using Azure DevOps to design realistic delivery plans for reporting and analytics projects, balancing ambition with practical delivery.
• Collaborate with the other Data Analyst to ensure knowledge is shared, silos are avoided and take joint responsibility for managing the workload through the department
• Provide training, guidance, and knowledge sharing to build capability and resilience in the use of BI tools across the organisation.
• Represent the organisation externally, contributing to forums such as the Hospice UK Data Analyst network to share expertise and bring back learning.

Platform management & technical contribution

• Take shared responsibility for administering and managing elements of the Microsoft Fabric Data Platform and PowerBI tenant.
• Work with the Data Engineering Resource to ensure reliability, scalability, and cost-effectiveness of data infrastructure.
• Contribute to the design and development of data models that support strategic and operational priorities.
• Ensure the BI environment is well-documented, secure, and optimised for performance.

Miscellaneous

• Stay up to date with emerging tools, technologies, and practices in BI, analytics, and data governance.
• Engage actively in continuous personal and professional development, building both technical and soft skills.
• Document processes, methodologies, and outputs to support knowledge sharing, transparency, and continuity within the team.
• Contribute flexibly to wider cross-functional projects within the Data & IT Services team.

Person Specification

Education and Qualifications

• Experience with data visualisation tools, particularly PowerBI.
• Detailed knowledge of customer requirements and internal processes is required
• A minimum of 2 years' experience working with Clinical Data Sets

• Certification in PowerBI, MS Fabric or similar
• Formal training in statistics, data modelling, or data science.

Self Awareness

• Understanding of personal bias
• Communication skill that are effective across all levels

• Experience presenting at cross-organisational or sector forums.

Working with others

• Willingness to learn and adapt.
• Able to form strong partnerships with internal and external stakeholders.
• Strong communication skills, capable of explaining technical concepts to non-technical stakeholders.

• Experience working collaboratively through platforms such as Azure DevOps or similar project management tools.

Outcome and Results

• Ability to manage conflicting priorities to provide good customer service.
• Strong organisational skills with the ability to document activities and processes clearly.
• Proven ability to deliver to agreed timescales and adjust plans when required.

• Evidence of improving processes or introducing innovation in a previous role.

Leading in your area

• Desire to learn and develop skills in Business Intelligence
• Experience working with PowerBI
• Experience working with Microsoft SQL Server and writing SQL queries
• Experience in effective Data visualisation

• Experience with Microsoft Fabric
• Experience or knowledge of data modelling techniques and Data Warehousing concepts

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

St Margaret's Somerset Hospice

Address

Heron Drive

Bishops Hull

Taunton

Somerset

TA1 5HA

Employer's website

https://www.st-margarets-hospice.org.uk/home-page