Senior Data Warehouse Analyst - Cardiff, United Kingdom - Experis LTD

Experis LTD

Verified Company

Cardiff, United Kingdom

3 weeks ago

Posted by:

Tom O´Connor

beBee Recruiter

Description

Senior Data Warehouse Analyst

Location:
Cardiff (Hybrid)

Salary:
£40,588
An exciting opportunity for a
Senior Data Warehouse Analyst to join one of our clients, who are a national public health board

Responsibilities & Key Skills:

Play an active role in the management of extraction, transformation and loading of data into the data warehouse from various clinical systems using available technologies to maximise functionality and efficiency.
To maintain and develop underlying warehouse structures to support the overall information strategy.
To work closely with information department colleagues in supporting reporting requirements.
Support monitoring and identification of data quality issues and escalate to the relevant parties.
Support the Trusts existing oracle data warehouse.
Work to ensure data integrity and technical correctness in line with National and local standards.
Ensure adequate documentation of all data structures, feeds, scripts and processes associated with the data warehouse are maintained.
Provide technical support for complex Oracle and SQL issues.
Ability to translate customer requirements and develop and maintain accurate documentation.
Facilitate the smooth running of the Trusts activity data extracts and submissions the provision of accurate, complete and timely data is key.
Application security, support and user management.
Work with the Local Data Repository's Architect to ensure the Data Warehouse maximises the benefits of new data sources and interface techniques.
Play an active role in liaising and working with external suppliers to enable the delivery and maintenance of third party solutions.
Liaise with other digital and health intelligence teams during formal projects but also to progress change control requests.
Play an active role to ensure the schema in the data warehouse continues to reflect the reporting needs of the service but also evolves to support AI and natural language querying products.