I'm a results-driven Data Analyst with 3+ years of experience building automated Python and SQL pipelines that cut reporting time by up to 50%. I turn messy, multi-source datasets into clean, reliable insights that teams actually use, across AgriTech, financial services, and operational analytics. I'm adept at building end-to-end ETL workflows, data validation, and creating Power BI/Tableau dashboards that drive decisions. I enjoy collaborating with actuarial, product, and NGO teams to embed analytics into operations and empower non-technical teammates with scalable data solutions.

Lucy Wambui Kamau

I'm a results-driven Data Analyst with 3+ years of experience building automated Python and SQL pipelines that cut reporting time by up to 50%. I turn messy, multi-source datasets into clean, reliable insights that teams actually use, across AgriTech, financial services, and operational analytics. I'm adept at building end-to-end ETL workflows, data validation, and creating Power BI/Tableau dashboards that drive decisions. I enjoy collaborating with actuarial, product, and NGO teams to embed analytics into operations and empower non-technical teammates with scalable data solutions.

Available to hire

I’m a results-driven Data Analyst with 3+ years of experience building automated Python and SQL pipelines that cut reporting time by up to 50%. I turn messy, multi-source datasets into clean, reliable insights that teams actually use, across AgriTech, financial services, and operational analytics.

I’m adept at building end-to-end ETL workflows, data validation, and creating Power BI/Tableau dashboards that drive decisions. I enjoy collaborating with actuarial, product, and NGO teams to embed analytics into operations and empower non-technical teammates with scalable data solutions.

See more

Experience Level

Expert
Expert
Expert
Expert
Expert
Expert
Expert

Work Experience

Data Analyst at Pula Advisors
September 1, 2024 - February 1, 2026
Designed and maintained Python & SQL pipelines processing 10,000+ farmer risk records monthly across 6 data sources, reducing end-of-month reporting time from 4 days to under 2 days.
Data Analyst at Tifa Research
October 1, 2025 - January 1, 2026
Built modular Python pipelines to ingest, clean, and structure large financial and market survey datasets, standardising processing across 5+ ongoing research projects.
Data Analyst at Atlas Isuzu Auto Service Center
May 1, 2023 - December 1, 2025
Designed ETL workflows that consolidated operational data from 4 internal systems (inventory, service logs, billing, CRM) into a single structured reporting database. Analysed service and sales data to identify operational inefficiencies, delivering insights that informed staffing and parts inventory decisions. Built structured cleaning and validation pipelines that improved data accuracy for monthly management reporting by eliminating duplicate and mismatched records.
Data Analyst (Volunteer) at TiqTech Solutions
January 1, 2022 - March 1, 2023
Automated weekly reporting workflows using Python scripts, reducing manual report generation from ~5 hours to under 30 minutes. Supported data cleaning and validation for internal product analytics, improving consistency across dashboards used by the product team.
IT & Data Support Intern at Digital Data Divide Kenya
January 1, 2022 - Present
Assisted in processing and reporting data for digital literacy programmes reaching 500+ beneficiaries across Nairobi County. Supported technical operations and data workflows for community-facing digital adoption initiatives.

Education

BSc in Statistics & Computer Science at Technical University of Mombasa
January 11, 2030 - April 7, 2026

Qualifications

Google Data Analytics Professional Certificate
January 11, 2030 - April 7, 2026
Data Science & Python
January 11, 2030 - April 7, 2026
Machine Learning Specialization
January 11, 2030 - April 7, 2026
Generative AI with LLMs
January 11, 2030 - April 7, 2026
Data Protection Certification
January 11, 2030 - April 7, 2026

Industry Experience

Agriculture & Mining, Financial Services, Professional Services, Software & Internet, Non-Profit Organization, Media & Entertainment