Job description
Responsible for the supporting the maintenance and development of the data warehouse including the design and implementation of automated Data Extract, Transformation and Load processes to meet new and changing requirements. Based on customer consultation design functional specifications for development work. Using creative and problem solving skills, support the changing information requirements of the trust through the design, development, creation and deployment of data warehouse tables and other BI developments. Work with the wider informatics team in the documenting workflow and designing specification of new BI solutions including, but is not limited to, new data warehouse tables/views, Visualisations, R and Python development.
Development and deployment of pro forma and report templates to support efficient table and report design and development across the trust. Identify, investigate and resolve problems in the production of routine and ad-hoc reports and ensure all work is fully validated and quality assured prior to distribution and that reports meet the end users need. Unresolved discrepancies must be reported to the senior management. Undertake continued data validation and maintenance of the data warehouse, ensuring that any core system changes are communicated to you, and are implemented, as appropriate, within the data warehouse.
System administration of Business Intelligence software including the monitoring of usage and compliance. Development of applications (web and non-web) to support data capture. Produce and deliver comprehensive training material to develop and maintain a high level of skills and abilities across the team. Ensuring that technical BI skills are shared and developed.
Teach, tutor and, coach, formally or informally as required to ensure effective use of the BI systems. Regularly evaluate performance and development needs, escalating exceptional performance and/or any concerns to the senior analyst. Take ownership of individual and team workloads, keeping people informed of progress and managing expectations where necessary, ensuring that all departmental routine and ad-hoc reporting is produced to meet the agreed deadlines. Self-development.
The BI landscape is continually changing and the technical analysts will be expected to invest time reviewing, assimilating and deploying new information which would further the trusts BI capabilities. Please see the attached job description for full details and main responsibilities for this role.