Okoth O

Sr Data Analyst

Dorsia • Período integral

Jun 2025 - Sep 2026 • 1 yr 3 mos

Analyzed customer behavior, purchasing patterns, booking activity, and revenue performance to identify opportunities for business growth and improved customer engagement. Conducted RFM (Recency, Frequency, Monetary) analysis to segment customers based on purchasing behavior, engagement frequency, and customer value. Developed customer cohort and retention analyses to understand customer lifecycle trends, repeat purchases, and long-term engagement. Built predictive analytics and anomaly detection models using Python and Prophet to identify unusual fluctuations in business KPIs and revenue trends. Developed and optimized SQL queries and data transformation pipelines using BigQuery, dbt, and Dataform to support reliable reporting and analysis. Analyzed customer engagement and revenue trends to provide actionable insights supporting marketing strategies, customer retention, and business decision-making. Automated recurring data preparation, transformation, and reporting processes to improve efficiency and reduce manual analysis. Developed analytical datasets and reporting frameworks to monitor customer activity, revenue performance, and operational KPIs. Collaborated with business stakeholders to translate analytical requirements into measurable KPIs, reporting solutions, and actionable recommendations. Performed data quality checks, validated analytical outputs, and investigated discrepancies to ensure accuracy and consistency across reporting datasets.

Data Scientist

Metra Vision • Período integral

May 2022 - Jun 2025 • 3 yrs 1 mo

Metravision consults on data, digital platforms, and emerging tech. Services: IT strategy, business intelligence, product/project management, UX/UI design, cloud/DevOps, and front-end development. Led data science projects leveraging cutting-edge technologies and APIs to extract actionable insights from diverse datasets. Utilized tools including Snowflakes, Power BI, dbt, BigQuery, Looker Studio, Tableau, R, Fivetran, Airbyte, and various Marketing Analytics APIs to drive data-informed decision-making. Designed and implemented an uninterrupted time series model to evaluate interventions aimed at reducing product returns. Delivered measurable impact by enabling an 8% reduction in returns, achieved through introducing targeted return fees based on model insights

Sr SQL Developer

Men of Action • Meio período

Apr 2024 - Jan 2025 • 9 mos

Men of Action is a mentorship and personal-development organization focused on optimizing client performance and engagement through datadriven insights. Monitored client performance and subscription revenue trends, ensuring accurate and timely performance tracking. Built and optimized complex PostgreSQL queries to extract and transform client data for analytics and reporting. Developed and deployed Grafana dashboards to visualize client metrics and provide real-time insights to management. Designed and implemented an RFM-based membership cohorting model using SQL to segment clients by engagement and value. Enabled a 20% improvement in Annual Recurring Revenue (ARR) by empowering the marketing team to execute more targeted campaigns based on customer activity patterns.