Analytics Technical Specialist

Job responsibilities

Supporting Development of Research Databases

1) Work with digital and clinical colleagues to establish a research database, bringing together data from different clinical systems based on agreed specifications.

2) Identify data sources and write queries to populate the database with the required data. Consulting with SMEs where necessary.

3) Work with digital colleagues and clinical to establish a pseudo anonymisation process to anonymise data within the research database. This will include fully anonymising imaging files, and other sensitive data.

4) Develop data dictionaries and meta data to support database use (for sharing with data users).

5) Be the primary contact for any queries relating to the data. Coordinating and delivering extracts and responding to any queries.

6) Create data quality reports for extracted dataset to be validated by second analyst, liaising with data access committee on any issues or concerns.

7) Feedback on data quality issues and support projects aiming to improve data quality.

8) Report to data access committee any data breaches or issues with database.

9) Act as mediatory/advisor on dataset (consult with SMEs where necessary)

10) Work with Digital and clinical colleagues on database refreshes and updates.

Supporting the Core Analytical Function

1) Postholder will manage their own day-to-day activities including:

a. Answering analytics requests. Providing data extracts and analysis - incorporating data science tools and techniques, where appropriate.

b. Explain methodologies and recommendations to a wide range of audiences (technical and non-technical).

c. Identify the most applicable techniques and variables to meet the customers needs, investigating conflicting information.

d. Writing programming code in SQL/ R/ Python as appropriate.

e. Investigating outliers and data quality issues.

f. Providing data to support research and audit projects.

g. Completing project documentation and delivering projects to agreed specifications.

2) Contribute to teams peer review process for queries and analytical outputs.

3) Interpret and resolve complex data problems by adopting an analytical approach designed to identify the most suitable solution and avoid future recurrence.

4) Continually review, and strive to improve, working policies and procedures which may impact across departments. Implement new and improved processes and policies as appropriate.

5) Support the delivery of the Clinical Outcomes and Data Strategy in conjunction with CO Director, Head of Analytics, Lead Analyst and Clinical Teams - particularly around improving data access.

6) Execute other duties appropriate to the skills and experience of the post holder which may be identified by the manager.

7) Take a proactive approach to developing own skills and experience.

8) Support team members. Mentor and coach junior members and undertake line management duties as required.

9) Demonstrate the agreed set of values and accountable for own attitude and behaviour.

Knowledge

Essential

• Expertise in database management and data flows.
• Practical knowledge and experience of a range of data analysis and visualization methods and practices

Desirable

• Knowledge of metadata design, how to apply appropriate metadata repositories and manage changes to existing metadata repositories.

Experience

Essential

• Extensive experience of working with and linking complex datasets using programming code.
• Experience of creating and establishing new data collection flows and processes.
• Experience of data insight analysis and intelligence reporting.
• Experience of producing documentation and reports to a Trust Board level standard.

Desirable

• Staff management/supervisory experience
• Experience in NHS or Health related analytical role
• Experience of working with Unix-based operating systems

Qualifications

Essential

• Post graduate qualification in an analytical/ statistics/ data science discipline or demonstrable equivalent experience.
• Able to demonstrate ongoing commitment to own personal development

Desirable

• Evidence of statistical training or application of statistical techniques.
• Database / dataflow / reporting practitioner certificates, e.g. SQL, Microsoft server tools etc.
• PRINCE 2 Foundation or equivalent project management

Other

Essential

• Evidence of continuing professional and personal development

Skills

Essential

• Advanced SQL skills

Desirable

• Data Science/advanced statistical skills

Knowledge

Essential

• Good understanding of current state and future trends in business intelligence and analytics, and proven track-record of keeping up with this fast-moving discipline.
• Awareness of Information Governance requirements

Desirable

• Understanding of the concepts and principles of data modelling.
• Awareness of how to design and build ETL/ELT, data pipelines, and data wrangling processes.

Experience

Essential

• Experience of identifying data quality issues and developing data quality reports.
• Experience of interpreting and presenting information in a meaningful manner
• Experience of identifying, and applying, appropriate analytical techniques to task in hand, and learning, and applying, new skills and methodologies where appropriate.
• Experience of providing oversight and advice to more inexperienced members of the team.
• Experience of working on projects/assignments involving a range of stakeholders with differing priorities.
• Experience of identifying areas for impactful innovation in data tools and techniques

Desirable

• Experience of the operational implementation of new technologies and processes
• Experience of creating metadata, designing appropriate metadata repositories and managing changes to existing metadata repositories.
• Project management
• NHS Data Dictionary
• NHS Datasets

Skills

Essential

• Demonstrable ability to design, develop and implement innovative data, BI, and analytics solutions, including: oTechnical analysis of requirements and specifications oWriting and management of code for the analysis and processing of data oPerformance tuning of data processing and analytical analysis code
• Excellent communication skills, with ability to translate technical concepts to non-technical audience.
• Ability to focus on complex problems, pay attention to detail, identify issues, and provide trouble shooting solutions
• Ability to understand the needs of technical, business, and clinical stakeholders and interpret them into technical requirements which can be implemented.
• Able to influence and negotiate with peers and senior managers to ensure best practice and successful development and implementation of change in your work area.
• Ability to be organised and to manage competing priorities

Desirable

• Proficient in writing clean, readable, and efficient Python code.

Values

Essential

• Ability to demonstrate the organisational values and behaviours

Other

Essential

• Office based role for first 3 months minimum then Hybrid (2 days a week on-site)
• Maintain confidentiality relating to patient data and sensitive information relating to the business of the Trust
• Ability to work flexibly to meet key deadlines and core service coverage

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.

Certificate of Sponsorship

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).