Responsibilities:- Developing end-to-end ETL data pipelines using Python, SQL, Docker, Linux, Mage.ai, Spark, Google Cloud Storage and Google BigQuery.- Designing, building, and maintaining data warehouses and databases to ensure efficient data movement from various sources to different stakeholders- Developing visualizations and dashboards to present data insights clearly and effectively, leveraging Looker Studio.- Creating and maintaining data models to represent complex business processes and improve data accessibility.- Performing data analysis using Python and MS Excel to derive actionable insights and support decision-making processes.

- Automated ETL Pipelines: Developed a custom python ETL class to automate scraping of historic forex data from Alpha Vintage API, transformed and loaded the data into Google BigQuery.- Predictive Modeling: Utilized machine learning techniques to predict individuals' likelihood of owning a bank account, providing insights for tailored outreach strategies and policy planning.- Telegram Alert Bot: Created a Cron-based Telegram bot using Python to send automated alerts for critical updates, featuring clear communication protocols and timely notifications.

- Led a project that processed 5,000+ bursary applications with 99% accuracy, ensuring timely disbursement of financial assistance- Successfully migrated manual data entry processes to a digital platform, resulting in a 20% reduction in errors and faster processing times.

- Designed and maintained a database for over 1,000 graduating students, ensuring data accuracy for the yearbook publication by 90%, and facilitating seamless yearbook compilation. - Streamlined data entry processes using Google Forms, improving data collection efficiency and reducing errors.- Recorded, safeguarded, and distributed meeting minutes to pertinent stakeholders.- Captured photographs of graduating students in adherence to the quality standards of the United States International University of Africa brand.

Daily management of the tuck shop which included selling of fast-moving consumer products, management of inventory and provision of mobile banking services