d
derrick_chia

Derrick

@derrick_chia

Data Analyst

Singapore
English
About me
I’m a Data Analyst with hands-on experience in Excel, Power BI, Power Query, HubSpot CRM, and marketing data analysis. I specialize in turning raw and complex data into clear dashboards, reports, and actionable business insights. I can help with data cleaning, Excel automation, dashboard creation, sales and marketing funnel analysis, conversion tracking, and performance reporting. I focus on creating practical and easy-to-understand solutions that help businesses make better decisions from their data.... Read more

Skills

d
derrick_chia
Derrick
Offline • 

See my services

Data Cleaning
I will analyze and create professional excel dashboards from your business data
From$25 / projectMore details

Work experience

Babilala

Performance Marketing Analyst

Babilala • Full-time

May 2025 - Present • 1 yr 3 mos

Developed executive dashboards and KPI reports for senior management, monitoring marketing and enrolment performance across 60+ preschool centres. Built end-to-end funnel reporting covering Leads, Qualified Leads, Tours, Contracts, and Commencement. Consolidated and analysed data from HubSpot, LittleLives, ManyChat, and multiple marketing channels to evaluate campaign performance, conversion rates, lead quality, and customer behaviour. Automated reporting and business processes using Excel, VBA, Google Apps Script, Zapier, and AI-assisted workflows, reducing repetitive manual work by approximately 50%. Conducted funnel leakage, withdrawal trends, budgeting, forecasting, and data quality analysis to support management decision-making. Also developed predictive planning models using historical data and centre benchmarks to improve forecasting and performance planning.

Accounting_Direct

Data Analyst

Accounting Direct • Full-time

Feb 2024 - Present • 2 yrs 6 mos

Built and maintained business dashboards using Superset, Metabase, and Looker Studio, covering MRR, churn, growth, NDR, sales, marketing, and CRM KPIs. Developed and optimized SQL queries for complex subscription and revenue analysis. Built Python and Airflow ETL pipelines integrating data from Chargebee, HubSpot, Google Ads, and Google Analytics. Automated recurring reports and provided customer segmentation and performance insights to support business decision-making.