Data Management Senior Analyst

Portsmouth Hospitals University NHS Trust; Portsmouth; Hybrid; GBP 38,000 - 47,000; Full time

Job summary

A healthcare organization in Portsmouth is seeking a Band 6 Data Analyst to oversee the development and performance of their Data Warehouse. Candidates should have a degree in ICT and hands-on experience in database development and SQL. Responsibilities include creating reports, monitoring services, and automating processes to enhance operational efficiency. Offers a range of modern employee benefits and opportunities for professional development.

Benefits

On-site nursery

Free Beach Hut for summer

On-site Wellness Centre (gym and swimming pool)

Access to staff networks

Qualifications

• Post-qualification hands-on experience of systems and database development.
• Experience of writing SQL queries in a real-world environment.
• Experience of system implementation management and support.

Responsibilities

• Monitor services for reliable data availability.
• Develop and maintain ETL processes and reporting datasets.
• Create standard reports and dashboards.
• Automate processes to improve efficiency.
• Support users in accessing reporting solutions.

Skills

SQL

Databases

Data Analytics

Data Management

Data Mining

Microsoft Access

Power BI

R

Tableau

Data Analysis Skills

Education

Degree level qualification or equivalent in ICT or related field

Job description

This vacancy is open to employees of Isle of Wight NHS Trust and Portsmouth Hospitals University NHS Trust only

Band 6 : 38682 - 46580 pro rata per annum

Permanent contract

Full time : 37.5 hours

The post holder will be required to work in a team responsible for the development, maintenance and performance of the Data Warehouse. Examples of tasks include:

• Responsible for the daily monitoring of services provided by the Data Management Function to ensure the reliable and consistent availability of information for Trust operational and performance reporting. Resolve issues and communicate with key stakeholders when problems are encountered.
• Responsible for the development and maintenance of ETL processes, data cleansing routines, indexing and reporting datasets.
• Develop and maintain high quality, clear and user-friendly data models that support the production of good business intelligence.
• Create attractive and high quality initial set of standard reports and dashboards as part of the delivery of new data into the data warehouse and Trust reporting systems.
• Maintain and develop solutions that will automate processes and improve upon current processes within the Analytical Services team and the wider Trust.
• Promote, train and support users of the Trust's reporting solution to improve access to Trust information.
• Support the robotic process automation design process and responsibilities for building the solutions to replace repetitive tasks by enabling the integration of existing systems, freeing up administration and clinical time.
• Ensure that the quality and technical approach aligns with the Digital Strategy and IT Design Authority principles and that solutions meet customer goals and objectives, thereby improving the quality of services delivered by the hospital.

For Further information please see attached: Job Description

Qualifications

• Degree level qualification or equivalent in ICT or related field

Experience

• Post-qualification hands‑on experience of systems and database development
• Experience of writing SQL queries in a real‑world environment
• Experience of system implementation management and support

Knowledge

• Strong customer service skills
• Able to set clear and appropriate objectives for self and others to meet overall goals
• Ability to manage multiple complex problems in sometimes stressful environments
• Excellent planning and time‑management skills; able to clearly manage priorities for self and team to meet deadlines
• Good technical awareness to understand and resolve technical problems
• Good knowledge in relational database design and implementation
• Good knowledge in SQL
• Good knowledge of computer languages
• Good knowledge of computer program design methods and techniques
• Good knowledge of data protection and information security / governance issues
• Ability to teach and instruct others
• Excellent written communication and documentation
• Excellent communication and interpersonal skills to influence and persuade staff in all roles and at all levels

Additional Information

The health and wellbeing of our staff is at the forefront of everything we do. We are proud to offer our staff some fantastic benefits including on‑site nursery, free Beach Hut for summer days, on‑site Wellness Centre (gym and swimming pool) and access to staff networks such as LGBTQ, Race Equality, DisAbility and awards ceremonies to recognise achievements. We believe we can support all of our staff when they need it most.

We welcome the unique contributions that you can bring in terms of your education, opinions, culture, ethnicity, race, sex, gender identity, expression, nation of origin, age, languages spoken, veterans status, colour, religion, disability, sexual orientation and beliefs.

Remote Work: Yes

Employment Type: Full-time

Key Skills

Databases, Data Analytics, Microsoft Access, SQL, Power BI, R, Tableau, Data Management, Data Mining, SAS, Data Analysis Skills, Analytics

Experience: years

Vacancy: 1