This is my profileContact via CazVidEffie
Data Analyst at Hypa Africa
Contact
Competencies
Expert in analyzing complex datasets to derive actionable insights for business strategies.
Skilled in writing complex SQL queries for data extraction and manipulation from various databases.
Experienced in designing and implementing data pipelines to support analytics and reporting workflows.
Proficient in creating BI reports and dashboards that facilitate data-driven decision-making.
Adept at transforming data into meaningful customer insights, influencing marketing and sales strategies.
Education
Summary
Accomplished Data Analyst with expertise in deriving insights from complex datasets to inform strategic decisions. Proven track record in improving business performance through data-driven methodologies.
Key Achievements
- Delivered actionable insights on customer performance and pricing strategy, enhancing decision-making for senior leadership.
- Extracted and analyzed data across sales performance and inventory movement, driving strategic improvements at Bolt Market.
- Designed end-to-end data pipelines, streamlining BI reporting processes for various clients as a Freelance Data Analyst.
Experience
Data Analyst: Insights & Analytics
Work directly with senior leadership to deliver ad-hoc and structured analytical outputs on key business questions spanning customer performance, category health, pricing strategy, and operational efficiency across B2C and B2B commercial platforms. Build and maintain customer segmentation models, grouping customers by spending behavior, purchase frequency, and product affinity to inform targeting, retention, and business strategy decisions. Conduct basket analysis and customer churn analysis to identify patterns in purchasing behavior, surfacing early signals of disengagement and informing proactive retention actions. Define, track, and report KPIs across product performance, fulfillment, and customer behavior, building automated dashboards that give leadership real-time visibility into business health. Instrument alerts and anomaly detection systems to flag performance deviations early, enabling proactive rather than reactive decision-making across commercial and operations teams. Led end-to-end launch of a new product category, conducting market research, building pricing models, and designing performance tracking systems that monitored category growth from inception through profitability. Partnered with marketing teams on campaign performance analysis — measuring commercial impact of promotional activities through segmented revenue, units sold, and buyer behavior reporting
Data & Commercial Analyst
Extracted, cleaned, and analyzed data from business ERP and platform systems using SQL to generate insights across sales performance, inventory movement, and customer demand patterns. Built customer performance reports and segmentation frameworks, analyzing purchasing behavior, basket composition, and spending patterns to support commercial and marketing decisions. Designed and implemented cross-system data validation workflows, ensuring accuracy and consistency of platform data used in reporting and business decision-making. Developed reusable reporting templates and standardized KPI definitions across commercial and operations teams, improving speed and consistency of insights delivery. Supported business teams by translating analytical findings into clear, actionable recommendations, adapting communication style to audience needs and decision context
Freelance Data Analyst
Designed and implemented end-to-end data pipelines using Python, SQL, and dbt-style transformations, building analytical datasets that support BI reporting and business intelligence workflows. Built multi-tenant reporting structures and automated operational and financial workflows in cloud-based data environments, reducing manual intervention and improving reporting reliability. Collaborated closely with business stakeholders to translate analytical findings into actionable recommendations, adapting quickly to shifting priorities and evolving requirements. Applied Git and version control practices across collaborative analytics projects, maintaining code quality and documentation standards