Responsibilities

• Extract information via multiple complex SQL joins to various data stores and present insights via data visualizations that are aligned to emerging data visualization standards.
• Assist and input into the design of the company Data Model to enable ingestion, transformation, cleansing and consolidation of data in a standardized format which can then be made available to business users.
• Acquiring data from primary or secondary data sources and maintaining databases / data systems.
• Lead and review on the validation of proposed production data migration systems.
• Enhance data quality and data integrity across all datasets by identification of data anomalies via scripts which be integrated onto a new data quality monitoring framework.
• Ensure that the Central Data Reporting platform operates at maximum performance efficiency by developing indexing strategies and regularly fine-tuning queries and so on.
• Follow defined IT Data Office Team processes and visualisation standards and contribute to their development via a continuous improvement process.
• Facilitate knowledge transfer into IT Data Office team by enabling shadowing, holding walkthrough sessions as required, and adequately commenting, documenting and sharing code.
• Report and update weekly to Senior Data Analytics Manager, on all assigned work including progress update, status of item, target date for completion and any risks or issues.
• Adhere to all department ICT security policies and procedures regarding network and security access as well as data protection compliance.