Skip to main content
Brian Cheung

Brian Cheung

Senior Business Intelligence Analyst

Vancouver, Metro Vancouver Regional DistrictMember since October 2, 2025
DAXsemantic modelsSQLPythonETLMicrosoft FabricLakehousepipelinesPower AutomateOracleSharePointperformance analysisStataExceldata governanceSOPsAzure fundamentalsPowerPointExcel VBAFactivaLexisNexiseconometric analysisgravity model of international tradesurvey designpolicy research
·

About

Senior Business Intelligence Analyst with 8+ years of experience, including 2+ years in the Canadian public sector, delivering governed datasets, semantic models, dashboards and executive reporting. Hands-on with Power BI (DAX, Power Query), SQL, Python, Microsoft Fabric, Oracle, Power Automate and ETL pipelines. Migrated 15+ legacy Excel reports to automated Power BI dashboards, cutting monthly reporting time by 40%, and turned complex operational data into decision-ready briefings for senior leadership.

Master of Public Administration; First-Class Honours in Business Economics.

Experience

Senior Business Intelligence Analyst - Ministry of Social Development and Poverty Reduction, Government of British Columbia

(2024-01 - 2025-09)

  • Spearheaded reporting modernization for the BC Bus Pass Program, migrating 15+ legacy Excel reports to automated Power BI dashboards and reducing monthly reporting time by 40%.
  • Developed and maintained scalable analytics using Microsoft Fabric and Lakehouse architecture, improving data governance and consistent access to reporting data.
  • Integrated BC Transit Compass Card and UMO data using Microsoft Fabric, supporting passenger analytics and service-equity tracking.
  • Engineered ETL and data-processing workflows using Python, SQL, and Power Automate to process high-volume program data and update/support Oracle data warehouse reporting.
  • Developed SQL-based datasets and Power BI reporting solutions, including DAX measures, filters, time-based analysis, KPI reporting, and interactive dashboards for operational and executive users.
  • Produced monthly performance reporting and 20+ data summaries and briefing notes for Executive Leadership, translating complex analysis into decision-ready information.
  • Led data governance and knowledge-transfer initiatives, documenting data definitions, reporting requirements, processes, and SOPs on Confluence and advising stakeholders on data management practices.
  • Supported controlled reporting access and governance processes, working with management and stakeholders to document requirements and maintain appropriate access.

Junior Policy Analyst (MPA Intern) - Department of Public Works, Government of Nova Scotia

(2022-05 - 2023-12)

  • Conducted policy research, data analysis, survey design, jurisdictional reviews, legal reviews, and stakeholder consultations for provincial policy initiatives.
  • Analyzed quantitative information using Excel and Power BI and prepared briefing notes and reports for senior management.
  • Synthesized information from multiple sources into concise research findings and decision-support materials.

Operations Performance Analyst - Cathay Pacific Catering Services Ltd - Hong Kong

(2019-04 - 2021-11)

  • Designed and automated 10+ Power BI dashboards integrating SharePoint and Oracle data, improving KPI tracking and accelerating executive reporting timelines by 25%.
  • Delivered cost, revenue, flight, operational, and performance analysis for senior stakeholders.
  • Produced management and board-level reporting and supported data-driven operational performance monitoring.

Market Research Analyst - AuCoeurDuLuxe HK Ltd

(2017-07 - 2019-01)

  • Led research projects for SK-II, Clarins, Pernod Ricard, Richemont, and internal studies, coordinating APAC fieldwork and data processing.
  • Designed surveys and delivered analytical findings using Excel, PowerPoint, and Power BI.

In-Country Research Analyst - Euromonitor International - Hong Kong

(2013-08 - 2017-05)

  • Conducted field research and stakeholder interviews, analyzed market data, and authored market reports, forecasts, and competitive analyses.

Junior Analyst - Blue Umbrella Ltd

(2012-03 - 2013-07)

  • Delivered due diligence reports for global financial institutions and government clients and built a PEP database using Excel VBA.
  • Conducted structured research using Factiva, LexisNexis, and other databases.

Language Interpreter (Multilingual) - Teleperformance - Vancouver, BC

(2026-04)

  • Deliver accurate real-time English–Cantonese interpretation of complex, time-sensitive information, building the precision and attention to detail that also underpin data quality work.
  • Handle confidential and sensitive information in line with privacy and organizational requirements, maintaining neutrality and professionalism.
  • Communicate technical or complex content clearly between parties, a skill that carries over to explaining analytics to non-technical stakeholders and supporting Cantonese-speaking audiences.

Education

Master of Public Administration (MPA) - Dalhousie University (2021-09 - 2023-12)

Bachelor of Arts (Hons) in Business Economics – First Class - Business Economics - University of Exeter (2008-07)

Skills

Senior Business Intelligence Analyst

Reviews

Related