Data Management Senior Analyst

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

Job summary

A regional healthcare provider in Portsmouth is seeking a Data Warehouse Developer to enhance data management strategies. The role demands expertise in SQL and data analytics to support reporting and service delivery. Responsibilities include monitoring data services, developing high-quality reports, and improving operational processes. Candidates should possess a degree in ICT or related fields, alongside relevant hands-on experience. This full-time position emphasizes teamwork and requires strong communication skills.

Benefits

On-site nursery

Access to free Beach Hut

Wellness Centre with gym and swimming pool

Diversity and inclusion 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 provided for reliable information availability.
• Develop and maintain ETL processes and reporting datasets.
• Create standard reports and dashboards for data warehouse delivery.
• Support automation solutions for efficiency in processes.

Skills

Databases

Data Analytics

Microsoft Access

SQL

Power BI

R

Tableau

Data Management

Data Mining

Data Analysis Skills

Analytics

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.

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

To maintain and develop solutions that will automate schedule and improve upon current processes within the Analytical Services team and the wider Trust.

Promote train and support users of the Trusts reporting solution to improve access to Trust information.

Support the robotic process automation design process and responsibility for building the solutions to replace repetitive tasks by enabling the integration of existing systems which will free up administration and clinical time for other duties and patient care.

Responsible for ensuring that the quality and technical approach taken is aligned with the Digital Strategy and IT Design Authority principles and ensure that solutions meet the customers goals and objectives which in turn improve the quality of the 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 in 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 be able to offer our staff some fantastic benefits including our on-site Nursery access to our free Beach Hut for those long summer days our on-site Wellness Centre including a gym and a swimming pool access to our fantastic staff networks including LGBTQ Race Equality and DisAbility and awards ceremonies to recognise your achievements. We believe we can offer support to all of our staff when they need it the most.

We welcome the unique contributions that you can bring in terms of your education opinions culture ethnicity race sex gender identity and 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