Job Description
Job summary We have a 9 month fixed term opportunity for the right candidate to lead a critical team within the SWAST's Data Analytics and Insight service. We are seeking a hands-on, experienced manager with highly developed technical skills in MS SQL Server based data analytics and reporting to join our Senior Leadership Team. The post holder will manage an expert team of analysts who provide a vital service to SWAST by responding to a high volume of adhoc data queries for internal and external customers (including Freedom of Information Requests) and maintain the optimum state of the data warehouse and its data pipelines. This role is only open for internal members of SWAST staff. Main duties of the job The DSS Manager leads a team of 5-10 data engineering and reporting specialists to provide business intelligence services to senior managers, colleagues and external stakeholders. Please see detailed job duties in attached Job Description. About us Working for us is an experience like no other. We provide emergency and urgent care, 24 hours a day, 365 days a year, operating across the largest ambulance region in England of 10,000 square miles and responding to an average of 2,650 incidents every day. We remain committed to ensuring that we provide the best possible care for all our patients, which is reflected in our five-year strategy which has continually improving patient care at its very core. At the heart of our beautiful and diverse region we employ over 6000 people and are supported by over 575 volunteers. If you embody our values of one team, compassionate and innovative and are looking to make a real difference to peoples' lives, then we would love to hear from you. In return we will equip you with the skills, resources and development you need to thrive in your role. You will have opportunities to progress to roles at a higher pay grade and enjoy continuous professional development In line with the 5 year strategy to achieve our vision that "Together, we will deliver the best care when you need us most", SWAST made a promise to the population of the South West of England that "Everyone will benefit from our improved infrastructure, enhanced digital tools and data insights, and our organisation will be recognised as a great place to work". This role is fundamental to enable SWAST to deliver this promise. Details Date posted 13 May 2025 Pay scheme Agenda for change Band Band 8a Salary £60,460 to £67,263 a year pa Contract Fixed term Duration 9 months Working pattern Full-time Reference number 202-51904185 Job locations SWAST HQ Abbey Court Exeter EX2 7HY Job description Job responsibilities The DSS Manager leads a team of 5-10 data engineering and reporting specialists to provide business intelligence services to senior managers, colleagues and external stakeholders. The DSS Manager is accountable for successfully operation of the Trusts business intelligence platforms and technologies from end-to-end. This includes management and ongoing change of our data warehouse (including data sourcing from operational systems, data imports and transformation processes, metric calculations and performanceoptimisation) and reporting tools (including report and dashboard design, scheduling and automation, platform administration and usage monitoring).The DSS Manager is responsible for building trusted relationships with a broad and diverse range of stakeholders across the Trust, understanding their information needs and delivering solutions that support them to optimise performance. Please see further details in attached Job Description Job description Job responsibilities The DSS Manager leads a team of 5-10 data engineering and reporting specialists to provide business intelligence services to senior managers, colleagues and external stakeholders. The DSS Manager is accountable for successfully operation of the Trusts business intelligence platforms and technologies from end-to-end. This includes management and ongoing change of our data warehouse (including data sourcing from operational systems, data imports and transformation processes, metric calculations and performanceoptimisation) and reporting tools (including report and dashboard design, scheduling and automation, platform administration and usage monitoring).The DSS Manager is responsible for building trusted relationships with a broad and diverse range of stakeholders across the Trust, understanding their information needs and delivering solutions that support them to optimise performance. Please see further details in attached Job Description Person Specification Education/Qualifications Essential Educated to a Degree level or equivalent experience in computer science or related subject. Desirable ITIL v4 foundation and some advanced certification. Experience Essential Extensive practical experience in conducting thorough data Extraction, Transformation and Load, (ETL) analysis, modelling and visualization in a work environment. Experience of managing a team. Experience of the full set of Microsoft Business Intelligence Technologies Desirable ITIL process management. Skills Essential Ability to analyse very complex issues where material is conflicting and drawn from multiple sources. Strong analytical skills. Person Specification Education/Qualifications Essential Educated to a Degree level or equivalent experience in computer science or related subject. Desirable ITIL v4 foundation and some advanced certification. Experience Essential Extensive practical experience in conducting thorough data Extraction, Transformation and Load, (ETL) analysis, modelling and visualization in a work environment. Experience of managing a team. Experience of the full set of Microsoft Business Intelligence Technologies Desirable ITIL process management. Skills Essential Ability to analyse very complex issues where material is conflicting and drawn from multiple sources. Strong analytical skills. 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. Certificate of Sponsorship 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. Certificate of Sponsorship 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) . Employer details Employer name South Western Ambulance Service NHS Foundation Trust Address SWAST HQ Abbey Court Exeter EX2 7HY Employer's website https://www.swast.nhs.uk (Opens in a new tab) Employer details Employer name South Western Ambulance Service NHS Foundation Trust Address SWAST HQ Abbey Court Exeter EX2 7HY Employer's website https://www.swast.nhs.uk (Opens in a new tab). Location : SWAST HQ, Abbey Court, EX2 7HY Exeter, United Kingdom