Job summary
The post holder will provide a robust data management and integration service to ensure that the provides accurate and timely information to the Trust via its reporting systems. As part of the data management strategy of the organisation, the post holder will be required to develop and maintain data integration pipelines which capture data from source systems and deliver it to the data warehouse and reporting solution. The Digital Services team utilise the Microsoft Azure platform.
Career Progression pathways and development opportunities:
We are committed to get the very best out of our staff and support staff in their career aspirations. We have career pathways available, where you will be able to develop your skills and build on your experience to progress into other roles across different specialties. In addition, we offer ongoing training and development in conjunction with the BCS membership.
Main duties of the job
- Define, develop, test and implement data flows which will routinely capture data from a variety of disparate data sources to update the data warehouse.
- Work with data modellers, report developers and business managers to develop data flows which will populate data models designed to deliver business value.
- Ensuring that all development work conforms the Trust Data Quality Assurance Framework ensuring that full documentation is available for audit and routine monitoring.
- Ensure that all developed data flows have error handling and detailed logging implemented to identify potential systems issues and ensure that user accessible data is not adversely affected.
- Participate or lead projects aligned to key organisational objectives of the Trust. This may require the assessment of different development options and recommendations to support those objectives.
- Develop mechanisms to automatically fetch and validate data from external and national resources, including GP, address, processed data and national benchmark details.
Flexible working:
As one of the few Trusts in London we are proud to offer flexible working as part of our new ways of working, and we are happy to talk flexible working at the interview stage. In this role you will be able to work Monday to Friday in the time frames from 8am to 6pm, giving you the very best of good work life balance.
About us
About the team:
The informatics team is split into two areas, data delivery and requirements & engagement. These teams work together to deliver against our service model to the organisation.
We work in an environment of collaboration, and whilst we endeavour to deliver information in a right the first-time environment, we have also created the space for teams and individuals to test out new technologies or interest projects within ring-fenced time - often in collaboration with external consultancies who support and encourage learning within the team.
About the location:
The Digital Services Informatics team is based at Jeanette Wallace House, in-between Bromley and Croydon (CR0 1FE)
Our Trust headquarters is located at Denmark Hill less than 5 minutes from the train station (zone 2). We also provide services and operate across other locations, such as London boroughs of Croydon, Lambeth, Lewisham and Southwark; and substance misuse services for residents of Bexley, Lambeth, Greenwich and Wandsworth
Job description
Job responsibilities
- Define, develop, test and implement data flows which will routinely capture data from a variety of disparate data sources to update the data warehouse.
- Work with data modellers, report developers and business managers to develop data flows which will populate data models designed to deliver business value.
- Ensuring that all development work conforms the Trust Data Quality Assurance Framework ensuring that full documentation is available for audit and routine monitoring.
- Ensure that all developed data flows have error handling and detailed logging implemented to identify potential systems issues and ensure that user accessible data is not adversely affected.
- Participate or lead projects aligned to key organisational objectives of the Trust. This may require the assessment of different development options and recommendations to support those objectives.
- Develop mechanisms to automatically fetch and validate data from external and national resources, including GP, address, processed data and national benchmark details.
- Lead on the development of data quality monitoring tools and techniques to support the accurate reporting of all internal and external reports and lead on the development of reporting from the Trusts data warehouse.
- Work with partners, such as the Biomedical Research Centre (BRC) to integrate and process data from Natural Linguistic Processing (NLP).
- Link data sets using key data items enabling the production of holistic data sets.
- Develop new procedures and policies to benefit both data management practices and the delivery of value, articulating the benefits and any implications for the organisation.
- The post holder will assist in the provision of customer support, interfacing and maintaining business and supplier relationships
Job description
Job responsibilities
- Define, develop, test and implement data flows which will routinely capture data from a variety of disparate data sources to update the data warehouse.
- Work with data modellers, report developers and business managers to develop data flows which will populate data models designed to deliver business value.
- Ensuring that all development work conforms the Trust Data Quality Assurance Framework ensuring that full documentation is available for audit and routine monitoring.
- Ensure that all developed data flows have error handling and detailed logging implemented to identify potential systems issues and ensure that user accessible data is not adversely affected.
- Participate or lead projects aligned to key organisational objectives of the Trust. This may require the assessment of different development options and recommendations to support those objectives.
- Develop mechanisms to automatically fetch and validate data from external and national resources, including GP, address, processed data and national benchmark details.
- Lead on the development of data quality monitoring tools and techniques to support the accurate reporting of all internal and external reports and lead on the development of reporting from the Trusts data warehouse.
- Work with partners, such as the Biomedical Research Centre (BRC) to integrate and process data from Natural Linguistic Processing (NLP).
- Link data sets using key data items enabling the production of holistic data sets.
- Develop new procedures and policies to benefit both data management practices and the delivery of value, articulating the benefits and any implications for the organisation.
- The post holder will assist in the provision of customer support, interfacing and maintaining business and supplier relationships
Person Specification
Qualifications
Essential
- Educated to Degree level or equivalent experience
- Evidence of professional/managerial development
Desirable
- Higher post-graduate education in a relevant subject
- Relevant Professional qualifications
Knowledge, Skills and experience
Essential
- Extensive experience in developing data flows in Microsoft SQL Server (SSIS / T-SQL) or Microsoft Azure to meet the business needs of the organisation
- Highly developed specialist reporting database knowledge underpinned by theory and experience
- Knowledge of project based and continuous Dev-Ops approaches
- Evidence of change management practices
- The facilitation of a customer focussed culture within a team
- Excellent written, verbal, and other media communications /Presentation skills
- A logical and sensible approach to problem solving
- Ability to organise and prioritise their workload, and be able to work under pressure
- To analyse and apply user information to problem solving
- Ability to express complex issues, both orally and in writing in an easily understood manner for a range of audiences
- Negotiation, influencing and persuading skills
- Pro-active and self-motivated in completing work to a high standard in conjunction with other staff
- Excellent team skills and ability to work with members of own and other teams and departments at all levels of the organisation.
Desirable
- Experience of developing data pipelines using Microsoft Azure Data Factory, PolyBase and Synapse
- Evidence of relevant professional training in data modelling
- Prince 2, Agile or other Project Management methodologies
- Use of ITIL in a work environment
- Knowledge of mental health services
Person Specification
Qualifications
Essential
- Educated to Degree level or equivalent experience
- Evidence of professional/managerial development
Desirable
- Higher post-graduate education in a relevant subject
- Relevant Professional qualifications
Knowledge, Skills and experience
Essential
- Extensive experience in developing data flows in Microsoft SQL Server (SSIS / T-SQL) or Microsoft Azure to meet the business needs of the organisation
- Highly developed specialist reporting database knowledge underpinned by theory and experience
- Knowledge of project based and continuous Dev-Ops approaches
- Evidence of change management practices
- The facilitation of a customer focussed culture within a team
- Excellent written, verbal, and other media communications /Presentation skills
- A logical and sensible approach to problem solving
- Ability to organise and prioritise their workload, and be able to work under pressure
- To analyse and apply user information to problem solving
- Ability to express complex issues, both orally and in writing in an easily understood manner for a range of audiences
- Negotiation, influencing and persuading skills
- Pro-active and self-motivated in completing work to a high standard in conjunction with other staff
- Excellent team skills and ability to work with members of own and other teams and departments at all levels of the organisation.
Desirable
- Experience of developing data pipelines using Microsoft Azure Data Factory, PolyBase and Synapse
- Evidence of relevant professional training in data modelling
- Prince 2, Agile or other Project Management methodologies
- Use of ITIL in a work environment
- Knowledge of mental health services
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.
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.
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).
