North Sydney, New South Wales, Australia
I'm a Data Analyst with 3+ years of commercial analytics experience and a PhD in Economics from ANU, based in Sydney and helping teams turn complex data into clear business decisions. My core toolkit is SQL, Python, and Power BI (advanced — DAX, Power Query, RLS, Service deployment). What I bring beyond the tools is a meticulous, detail-oriented approach to data quality and the ability to translate technical analysis into clear narratives for executives and non-technical stakeholders. I've worked across consulting, fintech, and energy — analysing 70M+ row datasets, building dashboards that go from "weekly" to "near real-time", and surfacing margin opportunities worth several percentage points to mid-market clients. Earlier in my career, I supported Chinese government delegations in commercial engagements with Rio Tinto and BHP — early experience in high-stakes corporate communication and bilingual (Mandarin–English) liaison that I've carried into every role since. I'm an early adopter of AI in analytics workflows, having integrated ChatGPT and GitHub Copilot into daily SQL, DAX, and Python work since 2023 — typically saving ~15 hours per week of routine effort. I'm genuinely curious about where the field is heading and enjoy keeping pace with the frontier. Open to: Data Analyst, BI Analyst, Senior Data Analyst, and Commercial Analytics roles in Sydney — particularly in financial services, professional services, and retail. Feel free to reach out at [email protected] or via LinkedIn message.
Boutique consulting firm serving Australian enterprise clients across financial services, retail, and energy sectors. • Designed and deployed 6+ end-to-end Power BI dashboards (DAX, Power Query, Row-Level Security, scheduled refresh) tracking revenue, margin, and operational KPIs (metric variables) — taking executive reporting from weekly to near real-time. • Conducted Python and Excel deep-dives uncovering 5–8% gross margin uplift opportunities for a mid-market retail client, delivered through dedicated executive dashboards. • Implement rigorous data validation and reconciliation across every dashboard release — line-by-line cross-checks ensuring zero reporting discrepancies during executive review cycles. • Run structured discovery workshops with senior stakeholders to align on KPIs, data sources, and visual design before build — translating business requirements into scalable analytics solutions. • Actively integrate enterprise-grade AI (ChatGPT Enterprise, GitHub Copilot, Microsoft Copilot) into daily analytical work — accelerating SQL drafting, DAX writing, and ETL automation under strict compliance frameworks, cutting analytical prep time by ~40%.
National-level applied research institute focused on fintech, digital economy, and policy analytics. • Analysed 78M+ records of public and commercial datasets using SQL and Python, building cost-benefit models and applying regression analysis and hypothesis testing to inform market entry and operational strategy decisions. • Built 10+ interactive Power BI and Tableau dashboards (DAX-driven KPIs, drill-through pages, parameterised filters) translating quantitative findings into concise insights consumed by senior management and external auditors. • Designed 20+ automated data quality rules and meticulous documentation of data lineage and DAX measure definitions — reducing reporting errors by ~30% and ensuring every dashboard met audit-grade accuracy standards. • Adopted AI-assisted analytics workflows early (from 2023) — using GitHub Copilot and ChatGPT to accelerate SQL query generation, Python data-wrangling, and Power BI semantic model development, saving ~15 hours per week. • Presented dashboard insights and analytical findings to senior leadership and external auditors, distilling complex econometric outputs into clear, audience-appropriate narratives.
Public safety analytics firm — Tsinghua University spin-off — partnering with Chinese municipal governments and Tsinghua University academics on urban emergency response and resource optimisation. • Developed spatial models and optimal routing algorithms in Python, improving fire-rescue dispatch efficiency by ~20% across 3+ municipal pilots. • Built operational dashboards (Power BI / Tableau) consolidating real-time public safety datasets across multiple municipal departments — enabling government leadership to monitor incident response and resource allocation at a glance. • Engineered ETL pipelines aggregating disparate public safety datasets into a centralised database, performing rigorous data quality checks and source reconciliation to ensure dashboard reliability. • Applied inventory optimisation and economic principles to balance warehousing costs against shortage risks, reducing emergency stockpile holding cost by ~12%. • Partnered with Tsinghua academics and government officials to design evidence-based emergency protocols adopted in 2 municipal-level frameworks — regularly translating technical analysis into briefings for non-technical decision-makers.
PhD research focused on econometric modelling and quantitative analysis applied to large-scale macroeconomic datasets. • Conducted doctoral research in econometrics, applying Python and advanced statistical modelling to large-scale Australian and international macroeconomic datasets. • Presented research findings at international academic conferences and faculty seminars, building early experience communicating quantitative results to mixed-expertise audiences. • Maintained version-controlled, reproducible analytical code and detailed methodological documentation across multi-year research projects. • Awarded the Full Australian Postgraduate Award (APA) Scholarship and the Goldsmith Endowment Award for PhD students in Economics. ► Quantitative Execution: Bridged the critical gap between theoretical mathematical models and highly efficient computational execution.
Australian arm of a top-5 Chinese state-owned energy group — one of the largest thermal coal importers from Australia. • Supported Chinese government delegations and Group executives in commercial engagements with Rio Tinto and BHP, preparing data-driven briefing packs on coal pricing, supply-demand outlook, and contract benchmarking that directly informed long-term offtake negotiations. • Acted as bilingual (Mandarin–English) liaison across Chinese parent-group leadership, Sydney HQ, and Australian counterparts at Rio Tinto and BHP — drafting meeting agendas, minutes, and follow-up correspondence with meticulous attention to numerical accuracy and diplomatic tone. • Built Excel-based dashboards and pricing trackers consolidating coal market benchmarks (Newcastle thermal coal index, AUD/USD movements, freight rates), giving Australian and Group executive leadership a single source of truth for weekly trading and procurement decisions. • Analysed Australian energy sector data — coal pricing, electricity market trends, regional supply-demand — producing commercial insights that supported pricing strategy and contract structuring across multi-million-dollar coal supply agreements. • Improved data verification and reporting systems across the supply chain, reducing manual reconciliation effort by ~25% through tighter validation rules and source-document cross-checks.