Skip to main content
Shawn MugambiSM
Open to opportunities

Shawn Mugambi

@shawnmugambi1

Data Analyst at Data Cycle Analytics turning messy client data into reconciled reports, dashboards, and automated checks.

Kenya
Message

At Data Cycle Analytics, I turn messy client data from SAP exports, ERP downloads, and spreadsheets into reliable reporting. I designed a MySQL database for disorganized SAP exports, connected it to Power BI, and wrote DAX measures around the client’s KPIs.

For a client with ad budgets spread across separate sheets, I wrote a VBA routine to consolidate targets, forecasts, and actuals into a master sheet, then built the budget dashboard. I also developed daily Python and SQL reconciliation checks that flag duplicates, nulls, and mismatches before figures reach a report.

At Minet Insurance, I built monthly Power BI claim utilisation reports and reconciled accounts across operational and finance systems. My work also includes insurance claims and compliance checks, and projects such as an EPRA fuel price pipeline using Python, PostgreSQL, Airflow, dbt, BigQuery, and Power BI.

Experience

Work history, roles, and key accomplishments

MI

Data & Analytics Intern

Minet Insurance

Jun 2025 - Aug 2025 (2 months)

Built monthly Power BI claim utilisation reports, reconciled accounts, 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, performed compliance checks, and supported underwriting and claims teams.

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

Certificate, 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

Certificate, 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