NHS Jobs
Location
Ashton Under Lyne, Greater Manchester | United Kingdom
Job description
Data Warehouse Design, code, test and implement efficient T-SQL scripts, Views and Stored Procedures, as part of Data Warehouse development. Proactively manage and administrate the integrity of data within the Warehouses: investigating, raising and resolving issues with the appropriate Trust managers. Responsible for monitoring the technical performance of the Data Warehouse, where poor performance is identified lead on the analysis and development of new ways of working to improve efficiency. Developing the Data Warehouse to fulfil the requirements of a Business Intelligence System i.e., it should support intelligent decision-making. Ensure all information outputs of the Data Warehouse are accurate, fit for purpose and delivered to the appropriate timescales. Ensure that documentation is developed and maintained for the Data Warehouse. Working with other aspects of SQL Server namely SSDT and utilise SSIS to develop new data sources and maintain existing ones. Promote and champion the use of the information contained within the Data Warehouse. Development of future data sources into the Data Warehouse. Understanding concepts and regularly research into new technologies around Cloud computing namely Microsoft Azure, Power Apps and Power Automate. In addition, any knowledge and experience with Microsoft Fabric would be desirable. Ensure any BI software purchases e.g., SQL Server Management Studio, Visual Studio for SSDT and Redgate are well within the BI budget allocation and the financial responsibility of procurement of any systems that have a Business Intelligence functionality. Working with the Head of BI in the planning and structure of the Business Intelligence team within the allocated resources and budget constraints to ensure a highly productive tool and team are built that delivers against the Trust BI strategy. Reporting and Dashboard Development Design and develop highly sophisticated and interactive dashboards (in Power BI) and reports from data held within the various Trust IT systems including the extraction of data from current non-DW systems such as Finance, HR and Governance. Provide expert advice and support in the use of IT systems; undertake data analysis using T-SQL, and develop automated reports using SSRS (SQL Server Reporting Services). Develop drill-through dashboards to meet user requirements to replace (on an automated basis) the need for some existing manual reports. Interrogate live information systems as appropriate and maintain and interrogate stand-alone databases for the production of information reports which are not supported by the Trusts PAS. Key to the role, you will provide and receive sensitive or contentious data. For example, data related patients care (including details of End of Life Care) and data related to staff employment including sickness data and payroll data. Produce, analyse and interpret highly complex statistical information and facts that are derived from various data source options to large groups of users (both internal and external) in a clear and understandable way in the way of formal presentations. To ensure thorough documentation and change control processes are in place, accessible and maintained for all processes and developments.
Job tags
Salary
£50.95k - £57.35k per annum
