Senior Business Intelligence Developer

Key Duties • Provide ongoing support to the information team for all aspects relating to SQL Server data management, ETL and BI processes. • Develop, maintain, document and enhance all ETL processes relating to patient data and associated systems, with a focus on efficient T-SQL development and optimisation. • Contribute to, and assist in, the development and subsequent implementation of the departmental strategy for business intelligence, data modelling (including tabular/semantic models) and reporting. • To line manage junior members of the team and to be responsible for their training and progression within their roles. • To act as a mentor for junior team members as required, particularly in SQL development and data modelling best practice. • Develop, map and document critical business and technical processes, including data models and data flows. • Contribute to the development of internal best practice development methodologies, SQL coding standards, solution documentation and standards. • Develop applications and solutions using rapid agile methods with focus to deliver agreed shippable components to the end user and subsequent iteration to acceptance, including data-driven and semantic layer solutions. • Conduct full technical testing of developed solutions at a unit and system level, including validation of data models and query performance, with appropriate scaling, platform, capacity and load testing. • Ensure that adequate security and data protection protocols are incorporated into solution designs as per Trust IG principles. • Provide technical expert capability to pro-actively resolve issues and assist with support and development issues as required, using high levels of SQL Server and data modelling expertise. • Develop pro-active monitoring and event management procedures to ensure continuous and reliable information systems availability, including database and data pipeline monitoring. • To keep up to date, and have an awareness of, new developments within the NHS, with a particular focus on data, BI, and analytics technologies (e.g. semantic models and visualisation tools such as Power BI). • Assist in other software and data development projects as carried out by the team. Job description Job responsibilities Key Duties • Provide ongoing support to the information team for all aspects relating to SQL Server data management, ETL and BI processes. • Develop, maintain, document and enhance all ETL processes relating to patient data and associated systems, with a focus on efficient T-SQL development and optimisation. • Contribute to, and assist in, the development and subsequent implementation of the departmental strategy for business intelligence, data modelling (including tabular/semantic models) and reporting. • To line manage junior members of the team and to be responsible for their training and progression within their roles. • To act as a mentor for junior team members as required, particularly in SQL development and data modelling best practice. • Develop, map and document critical business and technical processes, including data models and data flows. • Contribute to the development of internal best practice development methodologies, SQL coding standards, solution documentation and standards. • Develop applications and solutions using rapid agile methods with focus to deliver agreed shippable components to the end user and subsequent iteration to acceptance, including data-driven and semantic layer solutions. • Conduct full technical testing of developed solutions at a unit and system level, including validation of data models and query performance, with appropriate scaling, platform, capacity and load testing. • Ensure that adequate security and data protection protocols are incorporated into solution designs as per Trust IG principles. • Provide technical expert capability to pro-actively resolve issues and assist with support and development issues as required, using high levels of SQL Server and data modelling expertise. • Develop pro-active monitoring and event management procedures to ensure continuous and reliable information systems availability, including database and data pipeline monitoring. • To keep up to date, and have an awareness of, new developments within the NHS, with a particular focus on data, BI, and analytics technologies (e.g. semantic models and visualisation tools such as Power BI). • Assist in other software and data development projects as carried out by the team.