Sophie Chandrema

Analytics Consultant @On Data

London, GB

Led, maintained, and automated 30+ interactive Power BI dashboards and data modeling for a global hotel group, increasing Power BI adoption from 25% to 70% among 500+ users- Delivered data-driven insights and strategic solutions to CRM and Commercial team, optimising customer loyalty segmentation and retention strategies - Collaborated with cross-functional stakeholders (Revenue Management, Commercial, Finance, Marketing etc.) to define key business metrics, document business requirement, and establish data workflow to align with project objective- Developed, optimised, and validated ETL pipeline from multiple third party sources with SQL-based data logic via dbt Cloud, to identifying key inefficiencies and optimisation opportunities in cloud based infrastructure- Maintained and implemented data benchmarking initiatives, maintaining less than 1.5% variance for business key metrics reports across 30+ global hotel properties, improving report reliability- Presented business strategies and technical concept to both technical and non-technical stakeholders, reducing business decision fatigue and aligning project direction- Utilised Jira within an Agile framework to track and prioritise data anomalies, collaborating with stakeholders to resolve critical business issues efficiently