Data Analyst

Charles & Keith is a Singapore-based fashion brand known for its stylish and affordability. It operates globally with a strong presence in Asia, offering trendy designs and a fast-fashion approach.

• Architected robust data models and end-to-end ETL pipelines using advanced SQL and Power Query (M code), extracting, cleaning, and transforming 16M+ rows of enterprise data to track core KPIs including Net Sales, Return on Sales (ROS), and inventory performance.
• Spearheaded strategic migration of legacy Power BI dataflows from Gen1 to Gen2, optimizing refresh performance by 35%, resolving frequent timeout bottlenecks, and ensuring high stability for daily Business As Usual (BAU) operations.
• Developed dynamic, parameter-driven Power BI dashboards and paginated reports (Power BI Report Builder) featuring complex DAX measures for Year-over-Year (YoY) tracking, time-intelligence toggles, and Dynamic Row-Level Security (RLS) to enforce role-based data access across store categories and regions, actively partnering with stakeholders through full-cycle UAT.
• Automated critical reporting workflows using Power Automate, establishing real-time Microsoft Teams alert systems for dataflow refresh failure notifications and scheduling automated report distributions, reducing manual operational overhead by 10+ hours/week.