Data and Operations Analyst
May 2023 – Mar 2026- Automated Reporting Pipeline: Replaced manual weekly reporting across 3 retail locations with an automated Power BI and Microsoft Fabric solution — cutting reporting effort by ~40% and enabling real-time KPI visibility
- Analytics-Ready Data Modelling: Engineered dbt Core pipelines (staging to mart layers) for retail sales and inventory data, implementing automated data quality tests
- Reliable Daily Data Refreshes: Orchestrated scheduled ETL workflows using Apache Airflow — DAGs with task dependencies, retries, and failure alerting
- Centralised Data Warehouse: Migrated cleaned data into Snowflake, writing SQL queries and views as the single source of truth for downstream Power BI reporting
- Forecasting & Trend Prediction: Built forecasting and trend prediction scripts in Python to support demand planning and inventory decisions
- Root Cause & Governance: Investigated data issues to identify root causes, maintained data integrity standards and audit-ready documentation
- Stakeholder Collaboration: Partnered with operations and business teams to translate requirements into analytical tasks