l
letir_data

Karen Letir

@letir_data

Data Analyst

Kenya
English
About me
Freelance Data Analyst specializing in SQL (BigQuery, PostgreSQL), Python, and Power BI/Tableau dashboards. I turn messy datasets into clear, actionable insights — from building automated pipelines to uncovering conversion gaps and retention drivers. Google Data Analytics certified with hands-on portfolio experience across e-commerce, HR, and retail analytics. Detail-oriented, reliable, and easy to work with.... Read more

Skills

l
letir_data
Karen Letir
Offline • 

See my services

BI Analytics
I will clean and analyze your data in excel, sql, or power bi
From$15 / projectMore details

Portfolio

Work experience

Self_Employed

Freelance Data Analyst

Self Employed • Freelance

Sep 2025 - Present • 11 mos

Freelance data analyst specializing in SQL (BigQuery, PostgreSQL), Python, and Power BI/Tableau. Built an automated pipeline from BigQuery through Python to Power BI, uncovering a 74% session-to-product-view drop-off as the primary leak in a conversion funnel. Queried a 1M+ row clickstream dataset to quantify an 8.2 percentage-point conversion gap between user segments. Analyzed 1,470 employee records to identify a 16.12% attrition rate and delivered 5 data-driven retention recommendations. Audited 9,994 retail transactions ($2.3M in sales) to uncover that discounts exceeding 20% consistently triggered negative margins. Google Data Analytics certified, with a portfolio of end-to-end projects spanning e-commerce, HR, and retail analytics.