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