Job summary
We are looking for a highly motivated, enthusiastic and experienced Data Engineer & Platform Lead. This is a new role that will work across both Barnet, Enfield and Haringey (BEH) and Camden and Islington (C and I) mental health trusts and the postholder will play a key role in leading on the accelerated expansion of the Partnership's business intelligence platform and advanced analytical capability to deliver the aims of the Partnership's Digital Strategic Plan.
Note: Interviews will take place on 31st May 2023.
Main duties of the job
The postholder will be responsible for the design, development, testing, deployment and maintenance of extract, transform and load (ETL) processes flowing into the Trust's Azure Data Warehouse. The post-holder analyses datasets to determine their intricacies and relationships and designs & builds models to store this data efficiently.
This individual will provide line management to other data engineer.
The postholder should foster strong relationships with their customers to understand their requirements with a view to building them into the Data Warehouse through the standardisation & automation of business process. The post-holder is an expert in the field of Data Warehouse Development within a Microsoft SQL Server environment & supports colleagues across the Trust in this domain.
About us
Barnet, Enfield and Haringey Mental Health NHS Trust provides local, regional and national award-winning healthcare services. We have more than 3.300 staff working out of 20 main sites serving a population of 1.2 million people.We provide community health services and mental health services for young people, adults and older people. Our North London Forensic Service treats and cares for people in the criminal justice system who have mental health conditions. We also provide one of the largest eating disorders services in England, as well as drug and alcohol services.
We are an organisation that is passionate about equality, diversity and inclusion; one that prides itself in developing the leadership capabilities of its employees, looking after their health and wellbeing, creating safe spaces for staff to speak up and providing opportunities to mentor and be mentored.Our employees are the reason for delivering Good CQC ratings, excellent outcomes and outstanding patient experiences, so it is our aim to create a happy and healthy working environment where youcan thrive and succeed.
Job description
Job responsibilities
Please refer to the attached Job description and Person Specification for main responsibilities of the role.
Job description
Job responsibilities
Please refer to the attached Job description and Person Specification for main responsibilities of the role.
Person Specification
EDUCATION AND QUALIFICATIONS
Essential
- Master's Degree or equivalent in Information Systems or in related subject (data analytics, health economics, statistics or management information etc) or proven equivalent experience.
- Advanced certification in SQL Server
Desirable
- Machine learning qualification
EXPERIENCE AND KNOWLEDGE
Essential
- Experience of working analytically with healthcare data to develop clinical service focused solutions and analysis
- Experience of building analytical solutions within cloud platforms (Azure, Snowflake, Databricks for example)
- Expert level of database skills and computer languages - including SQL, relational database design, querying, and reporting functions obtained in a real-world environment
Desirable
- Experience of working analytically with mental health provider data to develop clinical service focused solutions and analysis
SKILLS AND ABILITIES
Essential
- Specialist knowledge of mapping software and its applications
- Advanced knowledge of relational databases and SQL Server, Data mapping & modelling.
Desirable
- Detailed knowledge of NHS Clinical Systems
PERSONAL QUALITIES
Essential
- Excellent verbal and written communication and interpersonal skills to influence and persuade staff in all roles and at all levels.
Person Specification
EDUCATION AND QUALIFICATIONS
Essential
- Master's Degree or equivalent in Information Systems or in related subject (data analytics, health economics, statistics or management information etc) or proven equivalent experience.
- Advanced certification in SQL Server
Desirable
- Machine learning qualification
EXPERIENCE AND KNOWLEDGE
Essential
- Experience of working analytically with healthcare data to develop clinical service focused solutions and analysis
- Experience of building analytical solutions within cloud platforms (Azure, Snowflake, Databricks for example)
- Expert level of database skills and computer languages - including SQL, relational database design, querying, and reporting functions obtained in a real-world environment
Desirable
- Experience of working analytically with mental health provider data to develop clinical service focused solutions and analysis
SKILLS AND ABILITIES
Essential
- Specialist knowledge of mapping software and its applications
- Advanced knowledge of relational databases and SQL Server, Data mapping & modelling.
Desirable
- Detailed knowledge of NHS Clinical Systems
PERSONAL QUALITIES
Essential
- Excellent verbal and written communication and interpersonal skills to influence and persuade staff in all roles and at all levels.
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).
