Camille Pham

• Built and maintained dbt exposure pipelines across a warehouse of 2,600+ models on BigQuery, improving dashboard governance and support data quality.

• Implemented alerts to prevent pipeline outages that would have delayed daily KPI reporting for live-ops and executive stakeholders.

• Developed an automatic metadata Looker dashboard, by architecting a Python/dbt pipeline that extracts lineage from JSON artifacts into BigQuery.

• Analyzed 10M+ client records using SQL/AWS to identify core purchasing and engagement trends, which was adopted by the Retail team to prioritize outreach and personalize in-store experience.

• Developed KPI dashboards and monthly reports for regional leadership, ensuring timely and consistent delivery of critical performance metrics across the EMEA region

• Ensured database integrity through data reallocation and on-demand merge.

• Drove €5,000 in operational savings per year (7% cost reduction per site) by conducting consumption analysis across four sites using Python.

• Created high-impact visualizations that clarified projected cost savings and mitigated financial risks, leading to the executive approval and immediate adoption of staff training recommendations to minimize energy consumption without requiring upfront capital investment.