Job Summary
NUH Digital Services are looking for an experienced Senior Data Warehouse Analyst/Developer to join the Data Warehousing Team as a dedicated resource for the Trust R&I department.
The potential post-holder will have to hit the ground running, and must therefore have proven experience in working with Research teams including clinicians to elicit software requirement and develop research study data management processes and Standard Operating Procedures. They must have excellent written and verbal communication skills. They must also have demonstrable and verifiable experience with metadata profiling and transforming data to the OMOP CDM, and they must be familiar with data pseudonymisation, anonymisation, and national data opt-out checking.
Candidates must also have proven expertise at a senior level in database modelling and database design, data warehousing and data migration, and the use of SQLServer, TSQL, and SSIS.
Previous NHS experience and familiarity with NHS data and datasets are likewise required.
Please note that regular on-site attendance will be required for this role, and that interviews will be conducted on site.
Main duties of the job
In addition to the brief list above you must familiarise yourself with the full job description and person specification attached to this advert prior to applying. Please note that all essentials listed in the job description are indeed essential.
Working closely with colleagues in the R&I department as well as the Data Warehousing and other Digital & Information teams, the post holder will be expected to take a leading role in the analysis, design, and development of both standard as well as ad-hoc data warehousing packages and data pipelines for the provision of data for research purposes.
As an expert in the field of Trust data, data validation, ETL mechanisms, and data provision, the post-holder may also be expected to provide leadership and mentoring for less experienced colleagues. They will also be expected to help with the development and maintenance of standards, procedures, and best practice guides, also where this may concern the potential adoption of new technologies in the team.
About us
With over 19,000 staff, we are one of the biggest employers in the city with a central role in supporting the health and wellbeing of our local population. We play a leading role in research, education and innovation.
Come and join our wonderful team at NUH. We are big believers in diversity and welcome new ideas to help develop our team in order to deliver world class healthcare to the vast patient populations we serve. With endless personal development opportunities available, at NUH we will endeavour to turn your job into a career!
We particularly welcome applications from people who identify as Black, Asian and Minority Ethnic, or Disabled, as we are striving to be better represented at NUH.
Job description
Job responsibilities
Your work will be varied and interesting, encompassing e.g. the investigation of acquiring potential new datasets from various clinical systems into the Trust data warehouse, building new data pipelines, ongoing monitoring of existing packages, providing architectural and strategic advice, etc.
You will primarily be working with R&I colleagues, but you will still be part of the wider data warehousing team, and you will work closely with the SQLServer DBA team members and with many other colleagues within and outside the Digital & Information department on a daily basis. We are very friendly and supportive of each-other, and try to provide everyone in our teams with the opportunity to learn and develop.
In your application, please make sure you address the key points outlined in the Person Specification and in this advert, so we can assess your suitability for this role, specifically with regards to your practical experience in working in the R&I sphere and OMOP, as well as your experience with standard NHS datasets, SQLServer / SSIS, data mapping, requirements gathering, analysis and design, and providing any and all associated project documentation.
Person Specification
Training and Qualifications
Essential
- A relevant IT degree at MSc level or above, or equivalent technical qualification & experience (equivalent experience = a minimum of 3 years’ working in a relevant technical role of sufficient seniority)
Experience
Essential
- Experience of working in a similar role within the NHS and with NHS data sets.
- At least 3 years’ experience of software development within a structured environment.
- Expert knowledge of and experience in the use of SQLServer databases and SQL/TSQL
- Expert knowledge of and experience in the use of SSIS
- Experience in requirements gathering, software analysis/design and in data mapping
- Must have considerable and demonstrable experience of working with data for research including OMOP, developing National data Opt-outs, and pseudonymisation processes.
- Must have considerable and demonstrable experience of working with Research teams including clinicians to elicit software requirements and develop research study data management processes and Standard operating procedures.
Desirable
- Experience of working with JSON and/or XML
- Experience of working with non-Microsoft ETL tools and database technologies
- Experience of working with Cloud ETL tools and technologies
Communication & Relationship Skills
Essential
- Excellent verbal and written communication
- Demonstrable experience in writing standards documents, best practice guides, etc
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).
Closing Date: 19 September 2024
