Skip to main content
Thao Pham

Thao Pham

Data Analyst

Talent
LondonMember since November 11, 2026
Claudedbtsemantic layersBigQueryPostgreSQLquery optimisationAirflowPythonGitHubCI/CDTableauLookerself-service BIperformance dashboards
·

Hire this person

Send a job offer directly to this candidate

Claudedbtsemantic layersBigQueryPostgreSQL

About

Data Analyst with 4+ years of experience across technology, robotics, finance and retail, specialising in analytics engineering and AI-enabled analytics. Experienced in delivering end-to-end data solutions, from raw data ingestion and dbt modelling on BigQuery to Python-powered reporting automation and self-service BI using Tableau, Looker and Power BI. Built a Claude-powered self-service analytics system that enables business users to query trusted data in natural language, uncover insights and translate findings into actionable, data-driven decisions that can be shared across teams.

Experience

Data Analyst - Ocado Technology - London, UK

(2024-08)

  • AI & Intelligent Automation
  • Designed and implemented a Claude-powered self-service analytics system enabling business users to query trusted business data in natural language and generate actionable insights without writing SQL. Designed domain-aware AI capabilities using reusable skills, structured data foundations, business logic, metric definitions and expert guidance across robotics, operational and commercial analytics.
  • Established AI evaluation and quality frameworks to assess answer accuracy, identify knowledge gaps and refine AI responses. Integrated domain context and analytical guidance to improve answer reliability and reduce repetitive ad hoc SQL requests and analyst dependency.
  • Developed AI-assisted automation workflows using Claude, SQL and Python, streamlining development, debugging and customer reporting from raw data processing to automated datasets, visualisations and report delivery.
  • Data Engineering & Modelling
  • Own the end-to-end product analytics data layer, building dbt models on BigQuery and PostgreSQL to transform raw ROS robot JSON events into structured staging, warehouse, business and semantic layers using SQL and Python.
  • Built and integrated cross-system data solutions connecting Amazon Connect, HubSpot and internal operational platforms into unified reporting models, enabling consistent analytics across multiple business domains.
  • Improved data reliability and warehouse efficiency through data quality validation, root-cause investigation, transformation fixes, historical backfills and BigQuery query optimisation.
  • Developed and maintained production data workflows using Airflow, GitHub and CI/CD, delivering scheduled pipelines and version-controlled dbt releases while reducing deployment risks and manual intervention.
  • Analytics Products & Reporting
  • Customer dashboards: Build customer-facing Tableau dashboards and automate the delivery of monthly performance reports via email.
  • Internal dashboards: Build dashboards for Product Engineering, Reliability, Delivery and Customer Success teams, enabling them to monitor robot performance, investigate root causes and detect failures. This includes a probable out-of-service robot indicator used by technicians, engineers and regional managers to identify potentially unavailable robots before visiting sites.
  • Leadership dashboards: Develop Control Tower dashboards that give leadership a consolidated view of business performance, highlight key metrics below target and support operational decision-making. Develop adoption reporting for a Tableau estate of ~100 sites and 2,000+ dashboards.

Data Analyst - Wickes - Watford, UK

(2023-05 - 2024-08)

  • Data Engineering & Automation:
  • Designed and maintained ELT pipelines in BigQuery, transforming raw sales and pricing data into clean, well-structured analytical models for commercial reporting.
  • Automated the manual daily data collection using Google Apps Script, streamlining data ingestion from partner email files into Google Sheets and BigQuery.
  • Developed and deployed Python-based web scraping scripts to extract, standardise, and analyse competitor product and pricing data for commercial analytics.
  • Analytics & Reporting:
  • Built and maintained sales and pricing dashboards in Looker Studio for commercial and trade planning teams.
  • Conducted in-depth analysis of sales and pricing data using BigQuery SQL and Python to identify pricing trends, market movements, and competitor insights.
  • Collaborated with cross-functional teams to define reporting requirements, validate business logic, and ensure data accuracy.

Business Intelligence Intern - HEINEKEN - Edinburgh, UK

(2022-06 - 2022-09)

  • Developed an integrated eCommerce sales dashboard in Power BI, enabling self-service analytics and replacing an external vendor solution, reducing annual operational costs.
  • Conducted ETL processes including data extraction, transformation, and loading into the data warehouse using Python, Power Query (M), Power BI, and DAX.
  • Gathered and documented business and functional requirements to ensure reporting solutions aligned with stakeholder needs.

Business Data Analyst - IRENDER Technology - Hanoi, Vietnam

(2020-06 - 2022-01)

  • Supported ELT processes and collaborated with Data Engineering teams to improve data quality and streamline data management for reporting and analytics.
  • Conducted in-depth analysis of customers, sales, marketing data, and the cloud computing services sector, delivering valuable insights to stakeholders in finance and business.
  • Developed finance and sales performance dashboards supporting KPI tracking, forecasting, financial modelling, and data-driven decision-making.

Education

Master of Business Analysis and Consulting – Distinction - Business Analytics (R/Python for Regressions, Classification, Machine Learning), Quantitative Business Analysis (SPSS), Spreadsheet Modelling & Demand Forecasti - University of Strathclyde (2022-01 - 2023-01)

Bachelor of International Business Management - Advanced Mathematics, Principles of Statistics and Business Statistics, Financial Accounting, Financial Management, and Principles of Accounting.

  • Foreign Trade University (2016-09 - 2020-05)

Skills

Data Analyst

Reviews

Related