Skip to main content
Shawn MugambiSM
Looking for a job

Shawn Mugambi

@shawnmugambi

Data Analyst at Data Cycle Analytics turning messy client data into reliable Power BI reporting and reconciliation checks.

Kenya
Message

At Data Cycle Analytics, I work across client engagements to turn disorganised data into reporting people can use. I structured SAP exports in MySQL, connected the database to Power BI, and wrote DAX measures around each client's KPIs.

For a multi-market ad budget, I wrote an Excel VBA routine to consolidate targets, forecasts, and actuals into a master sheet, then built the budget dashboard. I also created daily Python and SQL checks that flag data issues and send exception reports before figures reach a report.

At Minet Insurance, I built monthly Power BI claim utilisation reports and reconciled accounts across operational and finance systems. I also worked with underwriting and claims at APA Insurance, where I was part of the team that developed the Motor Vvuga product.

Experience

Work history, roles, and key accomplishments

MI

Data & Analytics Intern, Life & Medical

Minet Insurance

Jun 2025 - Aug 2025 (2 months)

Built monthly Power BI claim utilisation reports, reconciled accounts across systems, produced performance reports, and wrote benchmarking proposals.

AI

Actuarial Trainee

APA Insurance

May 2022 - Jul 2022 (2 months)

Validated policy and claims data, ran cross-ledger reconciliations and exception reports in Excel, and performed compliance checks. Supported underwriting and claims on motor, general, and reinsurance business.

Education

Degrees, certifications, and relevant coursework

KASNEB logoKA

KASNEB

CIFA, Finance

Completed CIFA Level 1 and is currently pursuing Level 2.

World Bank Group logoWG

World Bank Group

Fundamentals of Data Visualization, Data Visualization

2026 - 2026

Completed the Fundamentals of Data Visualization certification in 2026.

Daystar University logoDU

Daystar University

Bachelor of Science, Actuarial Science

2021 - 2025

Pursued a Bachelor of Science in Actuarial Science, completing the degree in November 2025.

DA

DataXcelerate

Data Analysis and Visualization using Excel, Data Analysis

2023 - 2023

Completed the Data Analysis and Visualization using Excel certification in 2023.

Tech stack

Software and tools used professionally

Interested in hiring Shawn?

You can contact Shawn and 90k+ other talented remote workers on Himalayas.

Message Shawn

People also viewed

View all talent

Get matched with your dream remote job

Sign up now and join over 250,000+ remote workers who receive personalized job alerts, curated job matches, and more for free!

Sign up
Himalayas profile for an example user named Frankie Sullivan