Job summary
As an evolving, future-focused and agile business, we are now looking for a motivated and detail-driven Business Analyst to be part of our success story and join our supportive, progressive and diverse company. This will be a key role in understanding business needs, analysing processes, and delivering data-driven insights that support strategic decision-making and operational improvements. If you are driven by wanting to make a difference, this is an exciting opportunity to work closely with stakeholders across the business and contribute to meaningful change initiatives.
The successful candidate will lead on the extraction, integration, and analysis of data from multiple interdependent systems to create high-quality datasets, management information, and interactive dashboards that support evidence-based decision-making across SWFT Clinical Services. They will provide actionable insight to inform operational, workforce, and strategic planning, driving performance improvement and supporting the company's growth. The requirement is for a proactive, professionally curious, and experienced analyst who can establish robust reporting processes, maintain data quality and governance, and work collaboratively across the company and with partner organisations to embed a culture of data-driven improvement.
Main duties of the job
The post holder will lead on the extraction, integration, and analysis of data from multiple interdependent systems to create high-quality datasets, management information, and interactive dashboards that support evidence-based decision-making across SWFT Clinical Services (SWFT CS). They will provide actionable insight to inform operational, workforce, and strategic planning, driving performance improvement and supporting the company's growth.
The role requires a proactive and experienced analyst who can establish robust reporting processes, maintain data quality and governance, and work collaboratively across the company and with partner organisations to embed a culture of data-driven improvement.
About us
SWFT Clinical Services is a wholly owned subsidiary of the South Warwickshire University NHS Foundation Trust (SWFT). The company provides a number of services such as outpatient pharmacy facilities at Warwick, Stratford upon Avon, George Eliot, University Hospital of Coventry and Warwickshire and St Cross (Rugby) hospitals; estates and facilities management at Warwick, Stratford upon Avon and Ellen Badger hospitals, Acorn House and Lillington Health Hub; private patient service and consultancy services to NHS Trusts.
Subject to the Company and individual's performance, an annual discretionary bonus will be awarded.
There is automatic enrolment to the Company pension scheme, with the Company contributing 5%.
A benefits package is available to the appointed candidate upon successful completion of the six month probationary period. This gives access to benefits such as a car lease scheme; Home & Electronics scheme; discounted leisure and travel; retail discounts and a cycle to work scheme.
There is also access to a 24/7, 365 days a year Employee Assistance Programme to support colleagues who may be facing some tough times or they need extra support with their mental well-being.
Job description
Job responsibilities
Data Acquisition and Integration:
Lead on identifying, accessing, and interrogating multiple, interdependent data systems across SWFT CS and partner organisations.
Extract, validate and cleanse, and integrate data from diverse sources to create reliable, consistent, and comprehensive data sets that underpin organisational reporting and analysis.
Develop and maintain robust data pipelines and processes to ensure the availability of high-quality data for analysis and reporting.
Management Information and Reporting:
Lead on the design, development, and delivery of management information (MI) reports and analytical outputs to support operational, workforce, and strategic decision-making.
Produce clear, accurate, and timely reports and dashboards that monitor key performance indicators, workforce trends, and service outcomes.
Dashboard and Data Visualisation Development:
Develop, implement, and maintain automated dashboards that bring data to life through clear visualisation and analysis.
Continuously improve reporting tools and visualisations to enhance accessibility, usability, and strategic impact.
Ensure dashboards are accurate, dynamic, and aligned with company objectives and performance frameworks.
Lead analytical projects that translate data into meaningful insight to inform planning, service improvement, and resource allocation.
Identify trends, risks, and opportunities through detailed data analysis, providing evidence-based recommendations for action.
Work closely with senior stakeholders to understand business challenges and develop analytical solutions that support strategic objectives.
Data Quality and Governance:
Champion high standards of data quality, integrity, and governance across all reporting and analysis activities.
Establish and maintain clear data definitions, documentation, and quality assurance processes.
Collaborate with internal and external system owners to resolve data issues and strengthen data reliability.
Collaboration and Continuous Improvement:
Work in partnership with teams across SWFT CS and external partners to embed data-driven approaches and enhance analytical maturity.
Provide specialist advice, guidance, and support to colleagues on interpreting data and using insight effectively.
Contribute to the development of a company data strategy and capability, promoting innovation, efficiency, and continuous improvement.
Systems and Tools:
The postholder will be expected to use a range of systems and tools including, but not limited to:
Microsoft
- Excel
- Word
- PowerPoint
- Teams
- SharePoint / OneDrive
- Visio (or Lucidchart)
Reporting & BI
- Power BI
- SSRS (SQL Server Reporting Services)
- Power Query / DAX (within Excel or Power BI)
Databases
- SQL (SQL Server / T-SQL)
- SSMS (SQL Server Management Studio)
NHS data platforms & datasets
- NHS England / NHS Digital dashboards & publications
- Data Warehouse / reporting cubes (local Trust systems)
- ESR (Electronic Staff Record) reporting
- EPR / PAS reporting
Job description
Job responsibilities
Data Acquisition and Integration:
Lead on identifying, accessing, and interrogating multiple, interdependent data systems across SWFT CS and partner organisations.
Extract, validate and cleanse, and integrate data from diverse sources to create reliable, consistent, and comprehensive data sets that underpin organisational reporting and analysis.
Develop and maintain robust data pipelines and processes to ensure the availability of high-quality data for analysis and reporting.
Management Information and Reporting:
Lead on the design, development, and delivery of management information (MI) reports and analytical outputs to support operational, workforce, and strategic decision-making.
Produce clear, accurate, and timely reports and dashboards that monitor key performance indicators, workforce trends, and service outcomes.
Dashboard and Data Visualisation Development:
Develop, implement, and maintain automated dashboards that bring data to life through clear visualisation and analysis.
Continuously improve reporting tools and visualisations to enhance accessibility, usability, and strategic impact.
Ensure dashboards are accurate, dynamic, and aligned with company objectives and performance frameworks.
Lead analytical projects that translate data into meaningful insight to inform planning, service improvement, and resource allocation.
Identify trends, risks, and opportunities through detailed data analysis, providing evidence-based recommendations for action.
Work closely with senior stakeholders to understand business challenges and develop analytical solutions that support strategic objectives.
Data Quality and Governance:
Champion high standards of data quality, integrity, and governance across all reporting and analysis activities.
Establish and maintain clear data definitions, documentation, and quality assurance processes.
Collaborate with internal and external system owners to resolve data issues and strengthen data reliability.
Collaboration and Continuous Improvement:
Work in partnership with teams across SWFT CS and external partners to embed data-driven approaches and enhance analytical maturity.
Provide specialist advice, guidance, and support to colleagues on interpreting data and using insight effectively.
Contribute to the development of a company data strategy and capability, promoting innovation, efficiency, and continuous improvement.
Systems and Tools:
The postholder will be expected to use a range of systems and tools including, but not limited to:
Microsoft
- Excel
- Word
- PowerPoint
- Teams
- SharePoint / OneDrive
- Visio (or Lucidchart)
Reporting & BI
- Power BI
- SSRS (SQL Server Reporting Services)
- Power Query / DAX (within Excel or Power BI)
Databases
- SQL (SQL Server / T-SQL)
- SSMS (SQL Server Management Studio)
NHS data platforms & datasets
- NHS England / NHS Digital dashboards & publications
- Data Warehouse / reporting cubes (local Trust systems)
- ESR (Electronic Staff Record) reporting
- EPR / PAS reporting
Person Specification
Qualifications
Essential
- Educated to degree level in a relevant subject (e.g. Mathematics, Statistics, Computer Science, Data Analytics, Information Management, or a related discipline), or able to demonstrate equivalent level of experience and expertise.
- Evidence of continuing professional development in data analysis, business intelligence, or related analytical fields.
- Demonstrable experience in the use of analytical and data visualisation tools, such as Microsoft Power BI, SQL, Excel (advanced), or similar platforms.
- Proven experience in extracting, transforming, and analysing data from multiple and interdependent systems.
Desirable
- Understanding of NHS data systems and reporting standards (e.g. ESR, Health Roster, TRAC, or similar workforce/operational systems).
- Knowledge of data governance, information standards, and GDPR requirements in a healthcare setting.
- Experience in developing and maintaining dashboards and management information reports to support organisational decisionmaking and performance monitoring.
Experience
Essential
- Significant experience of working in a data analysis, business intelligence, or information management role, ideally within a complex or multi-system organisation.
- Proven experience in extracting, manipulating, and integrating data from multiple, interdependent systems and databases
- Demonstrable experience in the design, development, and delivery of dashboards, reports, and analytical outputs that inform decision-making at operational and strategic levels.
- Experience in translating complex data into clear, meaningful insight for a range of audiences, including non-technical stakeholders and senior leaders.
- Experience of ensuring data quality, consistency, and governance across multiple data sources and reporting systems.
- Proven track record of working collaboratively with operational, workforce, and corporate teams to understand requirements and deliver datadriven solutions.
- Experience of using data visualisation and analytical tools such as Power BI, SQL, Excel (advanced), or similar software.
- Comfortable operating as the sole analytical resource, prioritising workload independently and shaping the role over time.
Desirable
- Experience of working within the NHS or wider public sector, with understanding of NHS data flows, reporting processes, and workforce or operational systems (e.g. ESR, Health Roster, TRAC).
- Experience in developing automated reporting processes and performance dashboards to support continuous improvement
- Involvement in data migration, system integration, or transformation projects
- Knowledge of project methodologies
Skills
Essential
- Advanced ability to analyse, interpret, and present complex data clearly and accurately.
- Strong working knowledge of data extraction, transformation, and integration across multiple systems
- Skilled in developing and maintaining interactive dashboards and management information reports (e.g. Power BI, Excel)
- Excellent understanding of data quality, governance, and information security standards (including GDPR).
- Strong problem-solving, critical-thinking, and data visualisation skills to support decisionmaking.
- Ability to communicate technical information effectively to non-technical audiences.
- Excellent attention to detail, accuracy, and data validation.
- Strong organisational and prioritisation skills, with the ability to manage multiple analytical projects.
- Ability to work collaboratively across teams and influence a data-driven culture.
Desirable
- Knowledge of NHS data systems and reporting frameworks (e.g. ESR, Health Roster, TRAC).
- Understanding of performance, workforce, and operational metrics within healthcare.
- Familiarity with data automation, process improvement, or data science tools (e.g. SQL, Python, R).
Personal Qualities
Essential
- Highly analytical, curious, and detail-oriented approach to problem-solving and data interpretation.
- Ability to work independently, exercising sound judgement and managing competing priorities with minimal supervision.
- Strong commitment to data accuracy, integrity, and ethical use of information.
- Excellent interpersonal and communication skills, with the ability to build effective working relationships across multidisciplinary teams.
- Resilient and adaptable, with a proactive approach to managing change and ambiguity in complex environments.
- Commitment to continuous professional development and improving analytical capability within the organisation.
Desirable
- Passion for using data to improve organisational performance, workforce planning, or service delivery
- Collaborative and supportive approach to developing a positive, data-driven culture.
- Confidence in challenging assumptions constructively and influencing decision-making through evidence.
Other
Essential
- Ability to work flexibly to meet organisational and reporting deadlines.
- Willingness to engage with multiple sites, teams, or systems as required by the role.
- Commitment to maintaining confidentiality and complying with data protection and information governance requirements.
Desirable
- Willingness to undertake occasional travel between organisational locations or partner sites.
Person Specification
Qualifications
Essential
- Educated to degree level in a relevant subject (e.g. Mathematics, Statistics, Computer Science, Data Analytics, Information Management, or a related discipline), or able to demonstrate equivalent level of experience and expertise.
- Evidence of continuing professional development in data analysis, business intelligence, or related analytical fields.
- Demonstrable experience in the use of analytical and data visualisation tools, such as Microsoft Power BI, SQL, Excel (advanced), or similar platforms.
- Proven experience in extracting, transforming, and analysing data from multiple and interdependent systems.
Desirable
- Understanding of NHS data systems and reporting standards (e.g. ESR, Health Roster, TRAC, or similar workforce/operational systems).
- Knowledge of data governance, information standards, and GDPR requirements in a healthcare setting.
- Experience in developing and maintaining dashboards and management information reports to support organisational decisionmaking and performance monitoring.
Experience
Essential
- Significant experience of working in a data analysis, business intelligence, or information management role, ideally within a complex or multi-system organisation.
- Proven experience in extracting, manipulating, and integrating data from multiple, interdependent systems and databases
- Demonstrable experience in the design, development, and delivery of dashboards, reports, and analytical outputs that inform decision-making at operational and strategic levels.
- Experience in translating complex data into clear, meaningful insight for a range of audiences, including non-technical stakeholders and senior leaders.
- Experience of ensuring data quality, consistency, and governance across multiple data sources and reporting systems.
- Proven track record of working collaboratively with operational, workforce, and corporate teams to understand requirements and deliver datadriven solutions.
- Experience of using data visualisation and analytical tools such as Power BI, SQL, Excel (advanced), or similar software.
- Comfortable operating as the sole analytical resource, prioritising workload independently and shaping the role over time.
Desirable
- Experience of working within the NHS or wider public sector, with understanding of NHS data flows, reporting processes, and workforce or operational systems (e.g. ESR, Health Roster, TRAC).
- Experience in developing automated reporting processes and performance dashboards to support continuous improvement
- Involvement in data migration, system integration, or transformation projects
- Knowledge of project methodologies
Skills
Essential
- Advanced ability to analyse, interpret, and present complex data clearly and accurately.
- Strong working knowledge of data extraction, transformation, and integration across multiple systems
- Skilled in developing and maintaining interactive dashboards and management information reports (e.g. Power BI, Excel)
- Excellent understanding of data quality, governance, and information security standards (including GDPR).
- Strong problem-solving, critical-thinking, and data visualisation skills to support decisionmaking.
- Ability to communicate technical information effectively to non-technical audiences.
- Excellent attention to detail, accuracy, and data validation.
- Strong organisational and prioritisation skills, with the ability to manage multiple analytical projects.
- Ability to work collaboratively across teams and influence a data-driven culture.
Desirable
- Knowledge of NHS data systems and reporting frameworks (e.g. ESR, Health Roster, TRAC).
- Understanding of performance, workforce, and operational metrics within healthcare.
- Familiarity with data automation, process improvement, or data science tools (e.g. SQL, Python, R).
Personal Qualities
Essential
- Highly analytical, curious, and detail-oriented approach to problem-solving and data interpretation.
- Ability to work independently, exercising sound judgement and managing competing priorities with minimal supervision.
- Strong commitment to data accuracy, integrity, and ethical use of information.
- Excellent interpersonal and communication skills, with the ability to build effective working relationships across multidisciplinary teams.
- Resilient and adaptable, with a proactive approach to managing change and ambiguity in complex environments.
- Commitment to continuous professional development and improving analytical capability within the organisation.
Desirable
- Passion for using data to improve organisational performance, workforce planning, or service delivery
- Collaborative and supportive approach to developing a positive, data-driven culture.
- Confidence in challenging assumptions constructively and influencing decision-making through evidence.
Other
Essential
- Ability to work flexibly to meet organisational and reporting deadlines.
- Willingness to engage with multiple sites, teams, or systems as required by the role.
- Commitment to maintaining confidentiality and complying with data protection and information governance requirements.
Desirable
- Willingness to undertake occasional travel between organisational locations or partner sites.
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.
Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab).
From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab).
Additional information
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.
Applications from job seekers who require current Skilled worker sponsorship to work in the UK are welcome and will be considered alongside all other applications. For further information visit the UK Visas and Immigration website (Opens in a new tab).
From 6 April 2017, skilled worker applicants, applying for entry clearance into the UK, have had to present a criminal record certificate from each country they have resided continuously or cumulatively for 12 months or more in the past 10 years. Adult dependants (over 18 years old) are also subject to this requirement. Guidance can be found here Criminal records checks for overseas applicants (Opens in a new tab).
