Australian State Government Insurance Company
Mar 2025 – Jun 2025Data Analyst / Engineer — GenAI-Powered Legacy Migration
A large-scale migration of on-premise data into a new Snowflake Enterprise Data Warehouse required converting a huge volume of legacy SAS scripts into SQL — a slow, error-prone task by hand.
- Built a GenAI workflow using Anthropic's Claude 3.7 to convert legacy SAS scripts into Snowflake SQL at scale
- Owned PII-masking across hundreds of SAS files, designing a Python Regex–based solution to identify and mask/map sensitive data
- Supported the ETL team writing SQL stored procedures across 3 staging layers and 1 target layer to migrate data into production
Impact — Delivered productionised code in 50% less time than planned and a 50% reduction in resourcing cost — efficient enough that Bill was moved onto the ETL stream to support further activities off the back of it.