Kiah Wallace

Data Analyst with an Honours degree and experience working with large retail datasets to support business intelligence and reporting. Proficient in SQL for data extraction, transformation, and analysis, with experience building automated dashboards and reporting solutions in Power BI and Excel. Familiar with data workflows, data warehousing concepts, and modern data architectures (lakehouse and data pipelines), with the ability to translate raw data into actionable insights for business stakeholders.

Retail Business Analyst - HomeChoice

(2025-08)

• Built Power BI dashboards and automated reporting workflows to streamline reporting and improve visibility of sales and performance metrics for stakeholders.
• Analysed trends across showrooms, product categories, and customer segments, producing insights that informed retail and merchandising decisions.
• Used SQL and Python to extract, clean, and analyse large datasets covering sales, footfall, and customer transactions.
• Developed a sales funnel analysis (footfall to NSV) to identify conversion drop-offs and improve sales efficiency by ~10% within 3 months.
• Analysed credit application data, assessing approval rates, customer eligibility, and risk trends to support responsible lending decisions and sales performance monitoring.

Property Portfolio Analyst and Manager - Steer & Co

(2024-11 - 2025-08)

• Analysed portfolio performance data to support cashflow forecasting and return projections across property assets.
• Built Excel-based financial models to track revenue streams, monitor trends, and support portfolio performance analysis.
• Used SQL and Power BI to extract, clean, and visualise large datasets, producing dashboards and reports for portfolio insights.

BSc and Honours, BCOM - Property Studies - UCT (2020 - 2024)

NSC Matric - Mathematics, Business, Biology - Herschel Girls (2015 - 2019)