Hi, I’m Peter, a Senior Data Engineer and Data Modeller with over 20 years of experience in BI, analytics, and process improvement. I excel at designing scalable data architectures, building robust ETL/ELT pipelines, and delivering actionable insights through dashboards and reports. I collaborate with SMEs and business teams to translate requirements into high-quality data solutions, focusing on governance, data quality, and compliance while enabling trusted decision-making.

Peter Thai

Hi, I’m Peter, a Senior Data Engineer and Data Modeller with over 20 years of experience in BI, analytics, and process improvement. I excel at designing scalable data architectures, building robust ETL/ELT pipelines, and delivering actionable insights through dashboards and reports. I collaborate with SMEs and business teams to translate requirements into high-quality data solutions, focusing on governance, data quality, and compliance while enabling trusted decision-making.

Available to hire

Hi, I’m Peter, a Senior Data Engineer and Data Modeller with over 20 years of experience in BI, analytics, and process improvement. I excel at designing scalable data architectures, building robust ETL/ELT pipelines, and delivering actionable insights through dashboards and reports.

I collaborate with SMEs and business teams to translate requirements into high-quality data solutions, focusing on governance, data quality, and compliance while enabling trusted decision-making.

See more

Experience Level

Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Intermediate
Intermediate
See more

Language

English
Fluent

Work Experience

Data Modeller / Technical Data Analyst / Data Engineer at Essential Energy
August 1, 2022 - Present
Analysed and validated data sources from Operations, Management, and BI/Excel reports; designed and advised on data collection, cleansing, and exploration processes; documented data mappings and business rules to ensure data integrity; built end-to-end conceptual, logical and physical data models using Inmon and Kimball approaches; developed Databricks ETL pipelines (Bronze-Silver-Gold) using SQL and Python to deliver analytics-ready datasets; created Power BI dashboards; implemented CDC pipelines and ensured data security and governance across reporting solutions.
Senior Business / Data Analyst at AGL Energy
April 1, 2021 - July 31, 2022
Prepared data migration specifications, mapped data flows, and ingested/reconciled data into the Azure Data Warehouse; consolidated data from electricity, gas, and FX sources; developed Tableau dashboards for sustainability reporting; supported traders in reconciling green positions against regulatory databases; conducted BVT/test data preparation.
Senior Business / Data Analyst at Victoria Building Authority
January 1, 2021 - March 31, 2021
Identified data requirements and migrated data from legacy systems to Salesforce; developed data mappings for ingestion into SQL Server; designed and maintained databases and reporting tools; created Power BI dashboards for oversight; coordinated cladding-related data to support governance and compliance initiatives.
Senior Project Officer at Department of Education and Training VIC
June 1, 2019 - December 31, 2020
Managed business system risks and led BI/enhancement projects; migrated CRM from MS Access to a custom CRM; designed the Contract Evaluation and Management System (CERS) and delivered accurate performance reports; analyzed sector performance data and supported stakeholder decision-making.
Senior Analyst – VBA & SQL Specialist at ATO
May 1, 2018 - May 31, 2019
Converted complex VBA queries to SQL stored procedures; integrated JIRA with BDA logs; developed ETL processes for log file uploads; built a benefits realization dashboard in Power BI for leadership.
Senior Business / Data Analyst at NAB
April 1, 2016 - May 31, 2018
Delivered BI-driven process improvements for Asset Servicing; built backend databases and data interfaces; administered SQL Server; redesigned daily pricing processes; developed SSIS and Python scripts to extract data from data vendors for pricing validation.
VBA Specialist / Senior Data Analyst / Senior Business Analyst at ANZ Bank
January 1, 2014 - April 30, 2016
Remediated Office VBA across Excel/Access; led management information and project reporting; built an Application Manager Dashboard in Power BI; conducted requirements workshops and managed vendor collaboration; led risk and change management.
Senior Programmer Analyst at Advantage Financial Services Pty Ltd
December 1, 2013 - January 31, 2014
Designed, coded and deployed MS Access VBA and SQL Server 2008 applications; produced documentation and mentored junior developers.
SQL DBA & ETL Developer at Victoria Legal Aid
November 1, 2010 - November 30, 2013
Managed eight SQL Servers; performed data mapping and migrations to transition legacy applications to new systems; designed data integration interfaces and ETL processes using SSIS; supported ATLAS, Finance One, TRIM and LDAP integrations.
Application Support Manager / System Testing Manager at Victoria Legal Aid
April 1, 2007 - November 30, 2010
Led enhancement and maintenance of business systems; managed vendor relationships and SLAs; directed testing and UAT for ATLAS, intranet, and Finance One integrations; implemented governance for system changes.
Senior Business Analyst / BI Developer at Victoria Legal Aid
February 1, 2000 - April 30, 2007
Gathered requirements, designed conceptual data models, and developed dashboards/reports (SSRS, Crystal Reports, Excel VBA); transformed business logic into physical data models for ATLAS.

Education

Master of Artificial Intelligence at La Trobe University
January 1, 2025 - January 13, 2026
Graduate Diploma in Innovation and Service Management at RMIT
January 1, 2008 - January 13, 2026
Master of Business Information Systems at Monash University
January 1, 2002 - January 13, 2026
Bachelor of Business (Accountancy) at RMIT
January 1, 1999 - January 13, 2026

Qualifications

Data bricks course: Data Engineering + SQL Analytics and BI
January 11, 2030 - January 13, 2026
Mastering the Requirements Process – VOLERE
January 11, 2030 - January 13, 2026
PRINCE2 Practitioner
January 11, 2030 - January 13, 2026
ITIL v2 Foundation Certificate
January 11, 2030 - January 13, 2026
ISTQB Foundation Certificate (Testing)
January 11, 2030 - January 13, 2026
Microsoft Certified Professional – SQL Server Administration (SQL 2000) and SQL Server Design (SQL 2000)
January 11, 2030 - January 13, 2026
Enterprise Suite Technical certification for System Administrator – Technology One products
January 11, 2030 - January 13, 2026

Industry Experience

Financial Services, Education, Government, Professional Services, Software & Internet

Experience Level

Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Intermediate
Intermediate
See more

Hire a Data Analyst

We have the best data analyst experts on Twine. Hire a data analyst today.