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.

<p>Oversee the assembly of large, complex data sets that meet functional / non-functional business requirements and align data architecture with business requirements.<br>
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.<br>
Monitor the existing metrics, analyze data, and lead partnerships with other Data and Analytics teams to identify and implement system and process improvements.<br>
Build analytics reports that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency, and other key business performance metrics.<br>
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.<br>
Perform thorough testing and validation in order to ensure proper data governance and quality across the business.</p>

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

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

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