Summary
Overview
Work History
Education
Skills
Websites
Selected Projects & Achievements
Timeline
Generic
LUKE ZANDSTRA

LUKE ZANDSTRA

Summary

Business Intelligence & ESG Data Analyst with 5+ years’ experience in Power BI, SQL, and sustainability reporting for multinational clients.

Overview

8
8
years of professional experience

Work History

DATA analyst / account manager

GCX
08.2022 - Current
  • Manage multinational client accounts in real estate & distribution; deliver ESG and GHG reporting used in board-level sustainability disclosures.
  • Clean, validate, and analyze GHG and sustainability data, ensuring compliance with international reporting standards.
  • Designed and deployed interactive Power BI dashboards, cutting client reporting turnaround by 30% and enabling executive-level decision-making.
  • Act as primary client contact for requirements gathering, progress updates, and delivery of findings.
  • Key technologies: Power BI, Excel, Python, SQL, ESG data frameworks.

DATA SUPPORT ENGINEER

PBT GROUP LTD
06.2020 - 07.2022
  • Provided 1st–3rd line support for multinational clients (via PBT and subcontract with DOT Group, UK).
  • Maintained client data technologies and resolved incidents across SQL Server and ETL pipelines.
  • Designed and implemented a centralized help-desk system with Power BI integration, improving incident tracking and reporting.
  • Key technologies: SQL Developer, Microsoft SQL Server, IBM Infosphere DataStage, Power BI.

Tutor

university of cape town
02.2018 - 06.2018
  • Tutored students in commercial programming, provided consultation for projects, and graded assessments.

Education

B.comm - Information Systems

University of Cape Town
03.2020

SQL For Data Science

Coursera

GHG Protocol Training (WRI / Greenhouse Gas Protoc

Udemy

Python For Data Analysis

Datacamp

AI For Everyone (Andrew Ng)

Coursera

Skills

  • Data & BI Tools: Microsoft Power BI, Excel, SQL Server, Python (Pandas, automation), IBM Infosphere DataStage
  • GHG Accounting / ESG Data: Environmental data management, reporting, and analysis for sustainability compliance
  • Programming Knowledge: SQL, C#, ASPNET (intermediate); Python, Java, JavaScript, HTML/CSS (basic–intermediate), Nextjs
  • Project Management: Requirements gathering, stakeholder management, documentation, workflow optimization

Selected Projects & Achievements

  • Data Cleansing Automation (2024) – Built Python + AI workflow to automate cleansing of large datasets (Pandas, OpenAI API, ML techniques).
  • Help-Desk Implementation (2020) – Led internal rollout of digital help-desk system integrated with Power BI for reporting.
  • ERP Process Improvement (2019) – Analyzed and redesigned hire-purchase contract process for retail client; awarded EY Top Achievers (2nd Place).
  • ASP.NET System Development (2018) – Developed a proof-of-concept web app for UCT RC&I, integrating relational database and interactive catalogue.

Timeline

DATA analyst / account manager

GCX
08.2022 - Current

DATA SUPPORT ENGINEER

PBT GROUP LTD
06.2020 - 07.2022

Tutor

university of cape town
02.2018 - 06.2018

B.comm - Information Systems

University of Cape Town

SQL For Data Science

Coursera

GHG Protocol Training (WRI / Greenhouse Gas Protoc

Udemy

Python For Data Analysis

Datacamp

AI For Everyone (Andrew Ng)

Coursera
LUKE ZANDSTRA