Job Summary
Interviews are expected to take place week commencing 14th October, 2024
The post holder will ensure specialist or complex IM&T information is processed in accordance with policies and procedures. Contribute to meeting strategic data and analytics planning and assist with the delivery of data, reporting and analytical products, with some small team leadership/mentorship aspects.
The Trust is redeveloping its data, reporting, and analytics infrastructure, moving to a cloud-based Lakehouse solution hosted on Databricks with Power BI for presentation.
We’re looking to add to the team to support this development work, with the successful candidate being a technical lead and mentor for data skills within the team and wider-organisation as it seeks to efficiently meet requirements and improve ability to derived value from its data.
Main duties of the job
- Oversee data flow functions including procedure setting and review. Investigate and implement resolutions or provide guidance on appropriate corrective actions when standard operations are interrupted.
- Contribute to design and co-lead on development cycles to ensure high quality production of automated data flows and resulting data assets.
- Administrate on-premises and cloud-based information management and reporting systems. Co-lead on planning and development of data tools and product use.
- Be a subject matter expert within the team and wider organisation regarding data management, data analysis, and associated software and system use. Be a mentor to team colleagues ensuring best practice is established and shared across the team.
- Lead on activities that develop and maintain transform data into valuable insights and presentation through a range of presentation tools and advanced techniques.
About us
We are an award winning and CQC rated good health and social care Trust delivering integrated services across Hull, East and North Yorkshire. Find out more on our website
We are a forward thinking and dynamic Trust with a real commitment to staff development. We value our colleagues and invest in them to ensure they have the right skills to deliver outstanding care.
We are proud to score above or equal to the average for all NHS People Promise theme areas demonstrating our commitment to improve the experience of working in the NHS for everyone. Wherever you work we know you will receive a warm welcome and all the support you’ll need to get you started.
We recognise the positive value of diversity and promotes equality whilst challenging discrimination. We welcome and encourage job applications from people of all backgrounds.
Work life balance is about having influence and flexibility over when, where and how you work. If the work pattern for this role does not meet your needs, we welcome an application and are happy to discuss working arrangements that differ from those advertised.
We offer a unique range of benefits that go above and beyond other NHS Trusts including an enhanced leave package and health and wellbeing support.
From city to countryside, market towns to moors you’ll find a place to call home including some of the most affordable places to live in the UK..
Job description
Job responsibilities
Communication and Relationships Skills
- Be a mentor for data analysis and data processing techniques, coaching, and advising team members and wider staff on the use of data tools.
- Interpret highly complex and sensitive information and provide complex information where there is a significant barrier.
- Communicate complex and technical information and language simply and accessible for non-technical audiences, including to a broad or large group of staff members.
- Advocate on behalf of a team and communicate what it does to create trust and authenticity.
Analytical and Judgemental Skills
- Analyse, investigate, and resolves complex data problems, selecting an appropriate solution where there are several options in the absence of precedence or established process.
- Analyse and understand 3rd party applications from a technical perspective.
- Research/investigate a variety of issues and conflicting information, to advise and propose solutions.
- To deal with complex enquiries effectively and responsively, deciding upon appropriate follow-up action.
- To scope, analyse and initiate additional or improved working practices.
- The application of machine learning to derive additional value from Trust data.
Planning and Organisational Responsibilities
- Contribute and co-develop strategic plans in line with organisation data and analytics goals.
- Plan development sprints in line with strategic goals, organise a complex and broad range of activities or programmes, requiring formulation or adjustment as required.
- Prioritise day-today tasks, adjusting to meet day-to-day changed where required.
- Initiates plans and modifies work programmes, for example new data sources, flows, systems, or reporting products.
- Review and approve code base changes prior to deployment to production environment.
Physical Skills
- Advanced keyboard skills.
- To travel to meetings locally and regionally as required.
Responsibilities for Patient Care
- Contact with patients is incidental.
Responsibilities for Policy and Service Development Implementation
- Full understanding of relevant Trust policies and procedures e.g., Fire, Health & Safety, Data Protection/Security of Information.
- To contribute to the reviewing, developing, and monitoring of departmental policy relevant to the service area and impacting on other areas.
- To implement policies and procedures relevant to own work area.
- Proposes changes to IM&T user working practices and, procedures e.g., when planning for new projects, changes in legislation, new reporting processes, new training programmes impacting across the organisation.
Responsibilities for Financial and Physical Resources
- To use office equipment in an appropriate manner, reporting any faults following the recognised organisational procedure
- Safe use of equipment other than equipment used personally.
- safe use of expensive equipment and maintenance of physical assets.
- Responsible for the proper and safe use of software and systems by users.
- Responsible for software and systems including installation, administration, and maintenance, including cloud-based technologies.
- Monitor cloud usage costs ensuring they remain within budget, escalating intervening and escalating where anomalies occur.
Responsibilities for Human Resources
- Demonstrate process and provides training in relation to reporting solutions and relevant IT systems to other relevant staff in the organisation.
- To work towards the objectives agreed in the Performance and Development Review.
- Demonstrate personal development in specialist data management and processing.
- Assist with recruitment and day to day management of the Data Engineering team. Including planning and prioritising workload when required.
- Can allocate work to junior members of the team.
- Delivers training in own specialism to other staff and organisations.
Responsibilities for Information Resources
- Responsible for maintaining multiple information and reporting systems, cloud and on premise based, used for integration, data management, general reporting, and analytics.
- Occasionally configure and develop other cloud infrastructure as required.
- Support the ongoing development and implementation of the data warehouse.
- Reverse engineer data sources and create data models to inform translation to analytics data model to meet Trust user requirements.
- Design, build and test data products based on feeds from multiple systems using a range of different storage technologies and/or access methods. You understand how to create repeatable and reusable products.
- Contribute to and maintain the data warehouse model and loading processes.
- Create and maintain objects for information presentation and reporting.
- Routinely monitor data warehouse integration processes resolving issues efficiently.
- The role involves processing sensitive patient information.
Responsibilities for Research and Development
- To contribute to research projects within the team.
- To participate in external audits of Trust activities and information systems/processes.
- Review and evaluate new technologies and products as required in relation to the teams function
- Undertake testing/adaptation of equipment, software, or systems.
Person Specification
Qualification and Knowledge
Essential
- Post-degree level qualification in the relevant area, or equivalent experience and relevant specialist knowledge.
- Knowledge of NHS terminology and healthcare information concepts.
Desirable
- Data modelling techniques and their application.
- Awareness or emerging trends and techniques relating to data management & processing for analytics.
Experience
Essential
- Demonstrable experience of working in the field where the post is held.
- Writing complex and easy-to-read SQL statements, and how implementation might impact performance.
Desirable
- Working with Spark-based information management systems, or other similar data systems.
- Data Integration systems and techniques
Skills and Competencies
Essential
- Advanced SQL programming, including DML and DDL.
- Python and/or PowerShell.
- Logical approach to technical problems with attention to detail and numeracy skills.
Desirable
- Azure or other cloud infrastructure concepts.
- Different data formats and transmission technologies and their application.
- Work to deadlines and prioritise work accordingly.
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: 26 September 2024
