Stephen Karanja | Data Analyst

Stephen Karanja

Data Analyst

Based in Nairobi, Kenya

About

I’m Stephen Karanja, a data analyst with a strong focus on automation and bioinformatics. I work at the intersection of data, technology, and biology,using tools like SQL, Python, Excel, and n8n to clean, structure, and analyze complex datasets. My background includes projects in genomics, precision medicine, and workflow automation, where I’ve applied statistical methods and machine learning techniques to uncover insights and make processes more efficient. Beyond analysis, I build automated systems that save time and reduce errors,whether that’s creating Excel models for finance, designing data pipelines with APIs, or integrating AI into daily operations. Recently, I earned a certification in Data Science and Bioinformatics from Stanford Medicine, which sharpened my skills in omics data,

Skills

Projects

Kaggle's Super store Sales Analysis

Analyzed the Superstore Sales dataset using Python and Power BI to uncover patterns in profitability, customer behavior, and regional performance. Delivered interactive dashboards and insights that highlighted discount inefficiencies and growth opportunities across categories and markets.

Personal Finance Tracker

I built a dynamic Excel-based tool that helps users manage debt and investments by automating repayment schedules, tracking budgets, and providing payoff timelines. It also integrates Power Query for real-time updates and includes clear visual dashboards for debt progress and portfolio performance.

Freelancer AI Job Finder

The Freelancer AI Job Finder is a custom automation I built to streamline how freelancers discover and apply for projects across multiple platforms. The system uses APIs and AI models to scan job boards, extract relevant listings, generate tailored proposals, and keep track of applications—all from

OL Financial analysis

This interactive dashboard provides a comprehensive overview of income sources, financial performance, and profitability metrics. It features a visually engaging network chart that breaks down revenue streams, highlighting key contributors such as advertising, licensing, and subscriptions.

Maji ndogo water project

In this project, I was tasked to find out the problems associated with water shortage in a region in Africa disguised as Maji ndogo "Short Water" where surveys were done and after analysis, I discovered issues affecting this shortage and suggested solutions to mitigate these shortcomings.

Experience

Aug 2020 – Present

Data Analyst Team Lead @ CloudFactory

-Designed and refined loyalty metrics, KPIs, and behavioral analytics dashboards using Power BI, Looker, and Excel to monitor customer retention and engagement. -Partnered with product and marketing teams to design A/B and multivariate tests, analyze outcomes, and optimize loyalty features and offers. -Built data structures and quality checks for reporting pipelines, ensuring governance and platform observability. Automated SQL- and Python-based workflows (Pandas, NumPy, Statsmodels, Scipy, Matplotlib), saving 120+ hours/month and reducing manual errors. Introduced Generative AI and LLM-driven automation prototypes for anomaly detection and automated reporting. Trained and supervised 6 analysts, embedding QA processes and values-driven leadership, improving accuracy and delivery standards.

Aug 2018 – Jul 2020

Junior Data Analyst @ CloudFactory

-Created MySQL and Looker Studio dashboards for monitoring project KPIs, productivity, and data quality across 10+ active projects. -Supported Fintech loyalty and CRM analytics initiatives, improving customer retention, reporting, and budgeting accuracy. -Coordinated with stakeholders on deliverables, provided status reports, and ensured compliance with project milestones. -Assisted in data segmentation efforts for user behavior analysis and product optimization

Education

2023

Bachelor of Applied Science - BASc Data Analytics @ Explore AI Academy

Bachelor of Applied Science - BASc Data analytics involves collecting, processing, and interpreting raw data to extract meaningful insights, patterns, and trends. Through statistical and computational techniques, it aids in informed decision-making and predictive modeling across various fields, helping businesses and researchers uncover valuable information hidden within the data. Skills: Apache · Google BigQuery · Python (Programming Language) · Apache Superset · Programmatic thinking · Microsoft Power BI · Attention to Detail · Data Visualization · Gathering and Analysing Data · Microsoft Excel · Visualization · Looker (Software) · Project Management · Data Integrity · Confidentiality · Data Analysis · Visual Basic for Applications (VBA) · SQL · Analytical Programming · Problem Solving

Jun 2025

Data Science – Bioinformatics & AI in Precision Medicine @ Stanford Medicine

I completed a Stanford Medicine certification in Data Science with a focus on Bioinformatics and AI in Precision Medicine. The program covered key areas including genomics, transcriptomics, proteomics, metabolomics, and microbiome analysis, as well as statistical methods, machine learning, and AI applications in healthcare. It emphasized practical approaches to analyzing complex biomedical datasets, integrating clinical and molecular data, and applying AI techniques to support personalized treatment and research in precision medicine. Skills: Genomic data analysis, transcriptomics, proteomics, metabolomics, microbiome analysis, statistical modeling, data visualization, machine learning, AI in healthcare, precision medicine applications, clinical data integration, dimensionality reduction