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