Kingsley Ihemere

Analytics Engineer @Vet.Ct

Cambridge, GB

Managed and maintained a modern and robust enterprise data warehouse on Amazone Redshift, ensuring high performance, data integrity and scalability to meet the data needs of the business.• Utilized Data Vault 2.0 data model with 17 hubs, 30 satellites, and 32 link tables to ensure data integrity, maintainability and scalability within the data warehouse.• Leveraged AWS Data Migration Service to efficiently migrate and replicate data from disparate data sources including Postgres, Jira, HubSpot CRM, and DynamoDB into the Data Lake in Amazon S3• Implemented Kimball dimensional data modeling framework on 8 data marts that feeds 45+ Power BI dashboards and reports• Monitored the entire data pipeline across 3 different environments, including Development, Staging and Production environments, ensuring smooth data extraction, transformation and loading processes• Utilized Apache Airflow to orchestrate and manage 21 complex DAGs workflow and monitor the performance and reliability of the data processes.• Implemented Spark and Delta Lake for high-performance data processing and reliable data lineage tracking with the pipeline.• Design, developed and maintained 45+ interactive Power BI reports within 8 Power BI Service Workspaces for departments, facilitating data-driven decision making across VetCT.• Maintained Development, Testing and Production environments within Power BI Service, ensuring smooth development, deployment and maintenance of reports and dashboards.• Conducted and implemented data quality checks, validation and testing processes to maintain high data quality and reliability.• Managed 80+ modular and reusable SQL objects in Data Build Tool (dbt) for efficient data transformation processes and enhance data quality across the data pipeline• Manages and implemented slowly changing dimensions type 2 (SCD 2) using data build tool (dbt), ensuring that incremental loads are efficiently implemented

University of Benin

Bachelor of Science - BSc, Mathematics

Teesside University

Masters of Science , Artifical Intelligence with Data Analytics