Joan Wambui

● Oversee the assembly of large, complex data sets that meet functional / non-functional business requirements and align data
architecture with business requirements.
● Developing ETL processes that enable and run data migrations across different databases and different servers and defining and
implementing data stores based on system requirements and consumer requirements.
● Monitor the existing metrics, analyze data, and lead partnerships with other Data and Analytics teams to identify and implement
the system and process improvements.
● Build analytics reports that utilize the data pipeline to provide actionable insights into customer acquisition, operational
efficiency, and other key business performance metrics.
● Oversee the process for creating and maintaining optimal data pipeline architecture and creating databases optimized for
performance, implementing schema changes, and maintaining data architecture standards across the required organization
databases.
● Perform thorough testing and validation in order to ensure proper data governance and quality across the business.

Oversee the assembly of large, complex data sets that meet functional / non-functional business requirements and align data architecture with business requirements.
Develop ETL processes that enable and run data migrations across different databases and different servers and defining and implementing data stores based on system requirements and consumer requirements.
Monitor the existing metrics, analyze data, and lead partnerships with other Data and Analytics teams to identify and implement system and process improvements.
Build analytics reports that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency, and other key business performance metrics.
Oversee the process for creating and maintaining optimal data pipeline architecture and creating databases optimized for performance, implementing schema changes, and maintaining data architecture standards across the required organization databases.
Perform thorough testing and validation in order to ensure proper data governance and quality across the business.

Streamlined ease of access to vital data necessary for quick decision-making in active marketing campaigns.
Developed an automation process for most reports from the ground up using SQL and Power BI that provided real-time insights.
Conducted statistical analysis i.e., post-analysis of marketing activities, cohort analysis, and ad-hoc analysis to identify trends in data.
Created marketing campaigns that were data-driven targeting specific customers and boosting profits by 15%.
Developed and maintained data visualization dashboards to help management track key performance indicators and make data-driven decisions.
Managed multiple projects simultaneously and derived high-quality work within tight deadlines and presented findings and recommendations in a clear concise manner.

Identifying valuable data sources and automating collection processes.
Entering and uploading data into company databases and systems, ensuring accuracy and completeness of information.
Verifying the accuracy of data and resolving any discrepancies in a timely manner.
Maintaining confidentiality of sensitive information and ensuring compliance with data protection regulations.
Responding to requests for information and assisting with research projects as needed.

Mentoring and guiding young students in universities to learn programming.
Organizing events and activities on campus to promote coding contests and data camps.
Coordinating responses based on established academic policies that benefit students to learn more about technology.
Developing a tech community in Kenyan universities with over 100 active student participants.