Setting up and executing extract, transformation and load (ETL) functions to build a data pipeline
Extraction and analysis of large data sets from MySQL
Performance tuning for current and newly added queries to the databases, ensuring the database resources are fully utilized
Delivering clear analysis and reporting of core business metrics to shareholders
Creation and management of reports and dashboards
Data management
Enhancing and optimising existing reporting processes
Ad hoc analysis and reporting to clients and shareholders
Aid in reconfiguring existing architecture and database structure to address our shareholder's evolving needs
Daily maintenance and monitoring of all BI related databases and dashboards, including proficient handling of emergencies
Providing actionable insight to drive growth of core products
