I'm Ross Garrett, a data engineer–analyst with over a decade in technical roles across government and cultural institutions. I specialize in modern cloud data platforms and enterprise analytics, with 5+ years delivering solutions on Microsoft Fabric and Databricks, and 12+ years in hands-on data management across Treasury, Health, and Environment sectors. Currently, I’m building a Microsoft Fabric pilot at DCCEEW and overseeing production infrastructure for 20+ Power BI reports (10+ external-facing). I’m Microsoft Certified Fabric Analytics Engineer Associate (DP-600), focused on Azure data stack, lakehouse architectures, Delta Lake optimization, data governance, and scalable data pipelines.

Ross Garrett

I'm Ross Garrett, a data engineer–analyst with over a decade in technical roles across government and cultural institutions. I specialize in modern cloud data platforms and enterprise analytics, with 5+ years delivering solutions on Microsoft Fabric and Databricks, and 12+ years in hands-on data management across Treasury, Health, and Environment sectors. Currently, I’m building a Microsoft Fabric pilot at DCCEEW and overseeing production infrastructure for 20+ Power BI reports (10+ external-facing). I’m Microsoft Certified Fabric Analytics Engineer Associate (DP-600), focused on Azure data stack, lakehouse architectures, Delta Lake optimization, data governance, and scalable data pipelines.

Available to hire

I’m Ross Garrett, a data engineer–analyst with over a decade in technical roles across government and cultural institutions. I specialize in modern cloud data platforms and enterprise analytics, with 5+ years delivering solutions on Microsoft Fabric and Databricks, and 12+ years in hands-on data management across Treasury, Health, and Environment sectors.

Currently, I’m building a Microsoft Fabric pilot at DCCEEW and overseeing production infrastructure for 20+ Power BI reports (10+ external-facing). I’m Microsoft Certified Fabric Analytics Engineer Associate (DP-600), focused on Azure data stack, lakehouse architectures, Delta Lake optimization, data governance, and scalable data pipelines.

See more

Experience Level

Expert
Expert
Expert
Expert
Expert
Intermediate
Intermediate
Intermediate

Language

English
Fluent

Work Experience

Data Analyst / Engineer at Dept of Climate Change, Energy, Environment & Water (DCCEEW)
January 1, 2023 - November 11, 2025
Architected and developed a comprehensive Databricks database using Unity Catalog implementing full medallion architecture (bronze/silver/gold) with production PySpark notebooks processing complex multi-source environmental data. Manage daily operations across Azure Data Lake Storage, Data Factory, Databricks, Power BI, and Fabric services; process complex multi-tab Excel reports with extensive validation, metadata tracking, and audit trails; implemented custom Delta Lake optimization techniques (VACUUM operations and V-Order). Co-developed and managed updates for 10+ external-facing environmental dashboards with rigorous data quality standards; managed Azure DevOps repository connected to Databricks repo for the WRRD ESPP solution.
Data Analyst / Senior Project Manager at Dept of Health and Aged Care
January 1, 2023 - January 1, 2023
Designed and delivered a bespoke executive reporting system for the Health Workforce Division PMO, integrating disparate SharePoint sources across 8 tables with hundreds of fields. Performed extensive data modeling, cleaning, transformation, and developed complex DAX measures and calculated fields; supported monthly early releases and ensured alignment with governance and privacy requirements.
Data Analyst / Project Manager at The Treasury
January 1, 2022 - January 1, 2022
Delivered 6 releases of the Payment Times Reporting Register (paymenttimes.gov.au), ensuring data authenticity for public financial disclosure. Responsibilities included data analysis, cleaning, transformation, and end-to-end data management from Dynamics CRM capture portal through SQL databases to the public register; developed a comprehensive Data Management Strategy for the Payment Times Reporting Scheme.
Program Manager / Business Analyst at National Film & Sound Archive
January 1, 2021 - January 1, 2021
Led the delivery of 15+ ICT software, cloud, and hardware implementations including the world-first 'Archival Data Storage in DNA' project. Managed CMS design and deployment with API, data schema modeling, and ETL design; supported PTRS Report Submission Portal and transition of Power BI responsibilities from Department to Treasury; managed culturally sensitive Indigenous secret and sacred audiovisual collections with appropriate governance protocols.

Education

Add your educational history here.

Qualifications

Microsoft Certified: Fabric Analytics Engineer Associate (DP-600)
January 11, 2030 - November 11, 2025

Industry Experience

Government, Healthcare, Education, Media & Entertainment, Non-Profit Organization

Experience Level

Expert
Expert
Expert
Expert
Expert
Intermediate
Intermediate
Intermediate