Job summary
Data Engineering Team supports decision-making within the Trust through the provision of a comprehensive information and analysis service by managing and optimizing the flow, storage, and accessibility of data from clinical on-clinical systems within the Trust. The post holder plays a pivotal role in ensuring that data flows smoothly, remains consistent, and is available for decision-making, insights and analytics.
Main duties of the job
The post holder will contribute to the smooth transition of the onsite data warehouse solutions into a more efficient, scalable and secure cloud infrastructure while supporting the current data platform and infrastructure. The post holder plays a pivotal role in ensuring that data flows smoothly, remains consistent, and is available for decision-making, insights and analytics. The post holder will also be responsible for maintaining the current data warehouse solutions by ensuring operational efficiency, routine maintenance, issue resolution, monitoring and reporting.
About us
St George's University Hospitals NHS Foundation Trust is one of the country's principal teaching hospitals and our main site is shared with St George's, University of London, which trains medical students and carries out advanced medical research. We have over 9,000 dedicated staff serving a population of 1.3 million across south-west London.
We deliver a large number of services, such as cardiothoracic medicine and surgery, neurosciences and renal transplantation. We also cover significant populations from Surrey and Sussex, totalling around 3.5 million people. As well as acute hospital services, we provide a wide variety of specialist care and a range of community services to patients.
Job descriptionJob responsibilities
As a member of the Trusts Data Engineering team, this role serves as a strategic and architectural expert in the development and maintenance of the data warehouse and its associated systems and solutions.
Deliver the trusts future data landscape by designing scalable and reliable data platforms on cloud infrastructure, ensuring data integrity and supporting continuous delivery of data solutions.
Design, development, and implement scalable and efficient data pipelines and workflows using Azure Data Factory and other ETL tools.
Build and manage data lakes, warehouse and databases on Azure including Synapse Analytics, Azure Data Lake and Azure SQL Database and develop our future data processing solutions in Microsoft Fabric.
Take full ownership of assigned responsibilities across advisory, implementation, and review phases, engaging effectively with both technical teams and senior leadership.
Act as an internal technical leader and innovator, contributing to the development of advanced and tailored technical solutions for the trust while championing engineering excellence.
Collaborate with wider IDT team including analysts, back office and other stakeholders to understand requirements and translate them into effective solutions.
Provide technical support for the existing database applications.
Design, develop, and implement new data feeds, ETL processes, and data marts to support evolving analytical and reporting needs.
Proactively review new and emerging technologies and their potential benefit to the Trust, fostering a culture of innovation and continuous improvement.
Develop solutions and provide management for the implementation of NHS Information Standards, mapping data standards and implementation of common data models.
Maintain robust data modelling practices, collaborate with other team members for best practices.
Ensure compliance with NHS Information Standard Notices (ISNs) and data standards.
Develop algorithms to transform data into usable models and ensure data quality and integrity.
Maintain and support the current data warehousing infrastructure to support the reporting needs of the Trust by managing various extraction, transformation, and load (ETL) processes.
Provide advanced technical knowledge and skills to support the information needs of the Trust.
Ensure accuracy and timeliness of data and adhere to security and Information Governance policies and procedures.
Act as a team leader and provide deputising support to the Data Engineering Manager as required.
To diagnose complex problems, situations and/or information and make informed judgements to formulate solutions and recommend/decide on best course of action.
Ensure all technical processes, current and future are documented.
Where necessary, advise and guide colleagues on technical and best practice matters.
Job description
Job responsibilities
As a member of the Trusts Data Engineering team, this role serves as a strategic and architectural expert in the development and maintenance of the data warehouse and its associated systems and solutions.
Deliver the trusts future data landscape by designing scalable and reliable data platforms on cloud infrastructure, ensuring data integrity and supporting continuous delivery of data solutions.
Design, development, and implement scalable and efficient data pipelines and workflows using Azure Data Factory and other ETL tools.
Build and manage data lakes, warehouse and databases on Azure including Synapse Analytics, Azure Data Lake and Azure SQL Database and develop our future data processing solutions in Microsoft Fabric.
Take full ownership of assigned responsibilities across advisory, implementation, and review phases, engaging effectively with both technical teams and senior leadership.
Act as an internal technical leader and innovator, contributing to the development of advanced and tailored technical solutions for the trust while championing engineering excellence.
Collaborate with wider IDT team including analysts, back office and other stakeholders to understand requirements and translate them into effective solutions.
Provide technical support for the existing database applications.
Design, develop, and implement new data feeds, ETL processes, and data marts to support evolving analytical and reporting needs.
Proactively review new and emerging technologies and their potential benefit to the Trust, fostering a culture of innovation and continuous improvement.
Develop solutions and provide management for the implementation of NHS Information Standards, mapping data standards and implementation of common data models.
Maintain robust data modelling practices, collaborate with other team members for best practices.
Ensure compliance with NHS Information Standard Notices (ISNs) and data standards.
Develop algorithms to transform data into usable models and ensure data quality and integrity.
Maintain and support the current data warehousing infrastructure to support the reporting needs of the Trust by managing various extraction, transformation, and load (ETL) processes.
Provide advanced technical knowledge and skills to support the information needs of the Trust.
Ensure accuracy and timeliness of data and adhere to security and Information Governance policies and procedures.
Act as a team leader and provide deputising support to the Data Engineering Manager as required.
To diagnose complex problems, situations and/or information and make informed judgements to formulate solutions and recommend/decide on best course of action.
Ensure all technical processes, current and future are documented.
Where necessary, advise and guide colleagues on technical and best practice matters.
Person Specification
Experience & Knowledge
Essential
- Over 2 years' experience in developing dashboards using Tableau desktop, creating data sources using Tableau desktop.
- 5 years data handling experience, of which at least 2 years should have been within a Tableau role.
- Advanced knowledge of SQL Server 2008 R2 and at least 4 years' experience in using it
- Tableau server administration experience
Desirable
- Knowledge of Data Protection Act
- Experience in using other business intelligence tools like Qlickview, SSRS, Power BI and Business Objects.
Education & Qualification
Essential
- Degree level or equivalent experience (relevant to role)
- Postgraduate qualification in relevant area or equivalent experience
Desirable
- Management qualification or equivalent experience
Skills & Ablities
Essential
- Administrative and organisational skills
- Good analytical skills for spotting or anticipating weaknesses in processes
- Ability to manage own workload and work to tight deadline
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.
Employer details
Employer name
St George's University Hospitals NHS Foundation Trust
Address
St George's Hospitals NHS Trust
Blackshaw Road
London
SW17 0QT
Employer's website
:quality(80))
:quality(80))
:quality(80))