Mark Ochwada

Analytics Engineer and Decision Intelligence specialist with 6+ years building end-to-end AI-powered analytics platforms, ETL pipelines, and BI systems that drive operational decisions across donor-funded programs and enterprise environments. Architect of full-stack data platforms integrating PostgreSQL, Python ML models, REST APIs, and interactive dashboards translating raw data into measurable business outcomes. Recognized for deep Monitoring & Evaluation expertise, donor program analytics, and real-world operational data experience across East Africa.

Evolving toward Analytics Engineering and Applied AI to deliver decision intelligence at scale.

SME Loop M&E Backstopper at Somo Africa (2026-01 – Present)

• Lead Monitoring, Evaluation, and Learning (MEL) backstopping for the SME Loop project across multiple regions, ensuring data quality, consistency, and compliance with donor and partner requirements.
• Design, manage, and maintain end-to-end data pipelines, including data collection tools, ETL processes, validation protocols, and reporting workflows.
• Develop and maintain interactive Power BI dashboards to support evidence-based decision-making, performance tracking, and stakeholder reporting.
• Oversee routine data quality assessments, validation exercises, and analysis to ensure accuracy, reliability, and timely availability of project data.
• Support program teams with data interpretation, learning insights, and performance reviews to inform adaptive management.
• Lead reporting processes, including periodic donor and partner reports, learning briefs, and internal performance summaries.
• Provide capacity strengthening and technical support to field and program teams on MEL tools, systems, and best practices.
• Coordinate closely with program management to align MEL outputs with project objectives, timelines, and partner expectations.
• Contribute to learning and knowledge management by documenting lessons learned, best practices, and improvement recommendations.

Data Analyst at Somo Africa (2022-10 – 2026-01)

• Leveraged Somo's proprietary DigiKua impact tracking app to measure business performance across the MSME portfolio.
• Analyzed collected data to generate impact reports and identify additional monitoring opportunities for the organization.
• Worked with departmental leads to create M&E frameworks and streamline data pipelines for Somo programs.
• Created systems to enable Somo to navigate high volumes of data efficiently, improving data processing speed.
• Prepared accurate database design and architecture reports for management and executive teams.
• Recommended solutions to improve new and existing database systems; provided staff training and individual support.
• Ensured data integrity through normalization initiatives; processed confidential data in compliance with guidelines.
• Commissioned and decommissioned data sets; troubleshot reporting database environments and reports.

Data Analyst at RUH Solar (2020-03 – 2022-01)

• Managed master data lifecycle including creation, updates, and deletion across enterprise systems.
• Provided quality assurance of imported data, working with QA analysts where necessary.
• Designed and managed reporting environment, covering data sources, security, and metadata governance.
• Supported data warehouse in identifying and revising reporting requirements; evaluated changes to source production systems.
• Assessed and implemented new or upgraded software, assisting with strategic decisions on system transitions.
• Troubleshot reporting database environment; trained end-users on new reports and dashboards.
• Provided technical expertise in data storage structures, data mining, and data cleansing.

IT Support Technician at United States International University – Africa (2018-08 – 2018-12)

• Provided remote and hands-on client support for multimedia and IT equipment troubleshooting.
• Maintained Multimedia Bookings Calendar and prepared classroom multimedia inventory records.
• Set up and troubleshot projectors, computer systems, and AV equipment for institutional functions.
• Configured and managed Campus Public Address Systems for institution-wide events.

Bachelor of Business Information Technology in Business Information Technology – Jomo Kenyatta University of Agriculture & Technology (JKUAT) (2016 – 2019)

Diploma in Business Information Technology in Business Information Technology – St. Paul's University (2015 – 2016)