Business Analyst in Warwick

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

• 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).
• Provide actionable insight to inform operational, workforce, and strategic planning, driving performance improvement and supporting the company's growth.
• 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 responsibilities

• 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.
• 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.
• 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.
• 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.
• 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.

Person Specification

• 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.
• 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 decision-making and performance monitoring.

Experience

• 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 data-driven 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.
• 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.

Skills

• 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 decision-making.
• 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.
• 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

• 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.
• 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

• 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.
• 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.