Data Warehouse Analyst - Fixed Term/Secondment

Job description

Job responsibilities

The Data Warehouse Analyst will support the work of the Informatics team by:

• Maintaining Leeds Community Healthcare information department data warehouses and related data feeds ensuring data integrity.

Ensuring a range of information is extracted and processed in accordance with policies & procedures.

Monitoring, identification and investigating a range of data quality issues and escalate to the relevant parties.

Performing the maintenance and system administration of databases.

Working closely with Business Intelligence department colleagues in supporting reporting requirements

Acting as a technical expert to users both within the department and to other departments around the Trust in the following key areas: Microsoft SQL Server (T-SQL, SSIS), Data Warehousing Architectures and Scripting

Key Responsibilities

1. Key Operational Responsibilities

1. Carry out and support complex technical database developments.
2. Responsible for the maintenance and development of the Trust Data Warehouse and BI platform, including interpretation of data, report creation and solution design and development
3. Manage and develop underlying Data Warehouse structures to support the overall department strategy
4. Designing and developing the Data Warehousing infrastructure to support the reporting needs of the Trust
5. Lead on the development and modification of extract, transform and load (ETL) routines, using tools and libraries in place within the system administration department (i.e. T-SQL, SSIS)
6. Assisting in creating web forms using ASP.NET framework
7. Compose complex SQL queries and provide quality assurance for SQL queries composed by others
8. Support the Information Manager in ensuring the interagency, security of the Trust data warehouse
9. Responsible for ensuring the Data Warehouses and national dataset are maintained in line with changes to the Clinical Systems
10. Ensure available information is accurate, up-to-date and fit for purpose
11. Submit approved datasets and returns.

12. Perform SQL database maintenance and system administration as required.

13. Responsible for providing technical advice on all Data Warehousing and BI solutions within the Trust

14. Produce and maintain written documentation of data warehouse structures

15. Support production of the Community Services Data Set (CSDS) and the Commissioning Data Sets (CDS) ensuring they are timely, efficient, meet all contractual targets and that there is documentation and process maps available to support these processes

16. Identify data issues and work with the wider team to develop solutions.

17. Adhere to the Trust Data Quality policy by highlighting and investigating data anomalies and inconsistencies as part of the information production process

18. Ensure NHS and agreed internal data standards are applied and adhered to.

19. Support the development of new procedures and techniques for routinely auditing data.

20. To develop and support high quality data standards.

21. Provide high quality service to service users and ensure they are kept informed of any delays or problems with data delivery.

22. Become familiar with the clinical information systems used by the Trust, especially functions key to data input, extract and reporting.

23. Assist with projects at planning, development and implementation stages if appropriate.

24. Deputise as required for more senior staff, including the attendance at meetings, where necessary.

1. The post holder has a legal responsibility to treat all records created, maintained, used or handled as part of their work within the Trust in confidence (even after an employee has left). They also have a duty to manage records in line with the organisations records management policy. Included in these are records relating to patient health, finance, personnel and administrative functions, whether paper based or electronic. All staff have a responsibility to consult their manager if they have any doubts about the correct management of the records with which they work.

Person Specification

Skills and Attributes

Essential

• Analytical and logical thinking
• Data warehousing using SQL Server 2016
• SQL Server Integration Services (SSIS)
• Web development tools and languages
• Intermediate MS Excel skills
• Cognitive skills, ability to identify patterns, trends and outliers from within a range of data
• Information management skills
• Ability to learn new technical skills
• Ability to adapt to changing milestones, assessing problems as they arise and identify solutions.
• Ability to work as part of a team
• Ability to work without direct supervision, prioritising work and acting on own initiative where appropriate; pre-empting problems and working to solve them in an appropriate manner
• Advanced Keyboard Skills

Desirable

• Python

Qualifications

Essential

• Educated to degree level in a relevant subject or equivalent knowledge acquired by previous experience in a relevant role

Experience

Essential

• Experience of data manipulation and analysis using a range of software including databases and spreadsheets
• Experience of relational databases
• Knowledge of information requirements and standards within a healthcare environment

Desirable

• Practical usage of information systems as a user
• Remote extraction of data from information systems
• Experience of testing new data sources and data releases
• Experience in collection, management, manipulation of NHS data sets

Employer details

Employer name

Leeds Community Healthcare NHS Trust

Address

Building 3 White Rose Park

Millshaw Park Lane

Leeds

LS11 0DL

Employer's website

https://www.leedscommunityhealthcare.nhs.uk/join-our-team1/ (Opens in a new tab)