Job overview 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. Advert 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. Working for our organisation 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. Detailed job description and main 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