JoanW

Specialist in Marketing Data Analysis & Interpretation

Education

B.Sc. Applied Statistics with Computing,

Language(s)

FRENCH
ENGLISH

Skills

blog

Work Experience

Mar 2025 – Present: Growth Lead – ANDO Kitchens (Remote)


- Lead growth strategy and execution across ANDO and AURO brands, managing cross-platform campaigns and customer engagement journeys.
- Designed real-time Power BI dashboards tracking KPIs such as CAC, LTV, retention, and campaign ROI to support executive decision-making.
- Segmented users into behavioral cohorts and executed targeted SMS and retention flows to increase repeat purchases.
- Collaborated with design, operations, and tech teams to deliver performance and brand campaigns aligned with strategic goals.
- Supported revenue growth initiatives, scaling ANDO App contribution to over 15% of Kenya sales and accelerating brand launches.

Feb 2022 – Feb 2025: Marketing & Data Analyst – ANDO Kitchens (Remote)


- Consolidated data from Microsoft Dynamics CRM, Mixpanel, Metabase, and Meta Ads API to enable segmentation and reduce CPA by 12%.
- Automated data workflows using Python, SQL, and Azure, improving ETL efficiency and reporting reliability.
- Built Power BI dashboards visualizing key metrics including CAC, LTV, churn, and campaign performance.
- Conducted A/B testing on messaging and campaigns, improving open rates (+18%) and conversions (+9%).
- Partnered with product and operations teams to resolve data integration issues and onboard new data sources.

May 2024 – Feb 2025: Data Analyst Consultant – Sunesis Consulting (Remote)


- Unified Salesforce CRM and lending data using SQL pipelines to enable full applicant journey tracking.
- Built predictive risk models in Python and SQL, reducing 30-day delinquency rates by 20%.
- Developed Power BI dashboards integrating risk scores to support data-driven collections strategies.
- Advised client teams on SQL, data modeling, and dashboard development to improve analytics capability.

May 2022 – Nov 2023: Data Analyst – Children’s Investment Fund Foundation (CIFF) (Remote)


- Cleaned, validated, and analyzed CRM and survey data to support audits and risk assessments.
- Developed 150+ Power BI dashboards to visualize KPIs, risk exposure, and program performance.
- Conducted A/B testing on monitoring protocols, improving field data accuracy by 22%.
- Resolved complex SQL issues, optimized queries, and mentored analysts to ensure reliable analytics delivery.