I'm Sudhir Panmand, a data engineering professional based in Sydney with a proven track record in building modern data platforms and driving value from data. In my current role at the State Insurance Regulatory Authority, I lead migrations, governance, and cloud-based architectures that improve data accessibility and security. I enjoy turning complex data into reliable, scalable solutions using Snowflake, Azure, and ETL tools, delivering insights faster and enabling data-driven decision making across government, retail, and media organizations. I'm passionate about automation, cost optimization, and mentoring teams to adopt best practices in data engineering.

Sudhir Panmand

I'm Sudhir Panmand, a data engineering professional based in Sydney with a proven track record in building modern data platforms and driving value from data. In my current role at the State Insurance Regulatory Authority, I lead migrations, governance, and cloud-based architectures that improve data accessibility and security. I enjoy turning complex data into reliable, scalable solutions using Snowflake, Azure, and ETL tools, delivering insights faster and enabling data-driven decision making across government, retail, and media organizations. I'm passionate about automation, cost optimization, and mentoring teams to adopt best practices in data engineering.

Available to hire

I’m Sudhir Panmand, a data engineering professional based in Sydney with a proven track record in building modern data platforms and driving value from data. In my current role at the State Insurance Regulatory Authority, I lead migrations, governance, and cloud-based architectures that improve data accessibility and security.

I enjoy turning complex data into reliable, scalable solutions using Snowflake, Azure, and ETL tools, delivering insights faster and enabling data-driven decision making across government, retail, and media organizations. I’m passionate about automation, cost optimization, and mentoring teams to adopt best practices in data engineering.

See more

Experience Level

Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
See more

Language

English
Advanced

Work Experience

Lead Data Engineer at State Insurance Regulatory Authority, Sydney
April 1, 2022 - Present
Led legacy platform migration from Oracle to Snowflake using Talend ETL, improving data management efficiency. Designed auditing and logging in Snowflake to ensure traceability. Architected a data lake on Azure Data Lake and a data warehouse on Snowflake. Implemented an automated deployment pipeline using GitHub Actions. Built security architecture for Azure Data Lake and Snowflake RBAC. Developed data transformation pipelines and multi-format ingestion (JSON, CSV, XML). Modernized data platform reducing maintenance costs vs legacy Oracle. Designed migration jobs to resolve navigation issues preventing potential losses. Introduced weekly batch analytics for insurer submissions data, boosting analytics efficiency by 75%. Created data products enabling regulatory reporting for SIRA.
Senior Data Engineer at British American Tobacco, Sydney
April 1, 2021 - April 1, 2022
Developed ETL processes using Wherescape; built end-to-end data pipelines with Wherescape and Azure Data Factory. Ingested structured and semi-structured data into Snowflake; automated CI/CD in Azure DevOps. Built reporting in Power BI; designed and implemented Airflow ELT solutions to improve insight turnaround. Engaged with stakeholders; integrated data from files, APIs, and Python scripts. Created sales, share, and profit reports in Power BI.
Senior Data Engineer at State Insurance Regulatory Authority, Sydney
September 1, 2020 - March 1, 2021
Implemented Single Sign-On for Snowflake; designed data quality rules; optimized Snowflake costs by 70%. Built a logging and audit model in Snowflake. Created 20+ ETL processes via Talend and Snowflake. Built Airflow pipelines improving reporting conversion rates by 12%. Ingested data from diverse sources and supported data lake/Azure security architecture. Automated CI/CD scripts in Azure DevOps and contributed to legacy platform migration.
Lead Data Engineer at Transport NSW, Parramatta
September 1, 2019 - September 1, 2020
Developed ETL processes using Matillion; built data pipelines to connect multiple data sources. Ingested data into Snowflake using S3/Glue/Lambda. Mentored a team of ETL developers. Implemented a multi-dimensional data model in Snowflake. Reduced ETL/data processing costs by migrating to Snowflake and leveraging multi-cluster warehouses. Implemented dynamic data masking and a security matrix with role-based permissions; allocated dedicated warehouses per department to monitor usage and cost.
Senior BI Developer/ Data Engineer at The Big Red Group, Sydney
March 1, 2018 - September 1, 2019
Rebuilt reporting system from MySQL to Snowflake data warehouse; built robust data pipelines using Matillion and AWS big data technologies. Created star and snowflake schema views for actionable insights. Integrated data from AdWords, Facebook, Stripe, PayPal, and Afterpay to Snowflake. Implemented Data Lake in Snowflake; decommissioned Redshift to reduce AWS costs. Built OLAP cubes and BI reports; collaborated with product and data teams to support data infrastructure needs.
BI Developer/ Data Analyst at Truelocal/Sensis, Sydney
March 1, 2016 - March 1, 2018
Built stored procedures, views, triggers, and constraints to ensure data integrity. Implemented indexes to accelerate data retrieval. Created SSIS packages to ETL data into data warehouses, flat files, Excel, and OLE DB destinations. Developed reports and dashboards in Tableau. Performed DBA duties, security, query optimization, and job monitoring. Built SSRS reports; managed AWS RDS/EC2/Redshift/S3 solutions and migrations to AWS; implemented DOMO and BI data marts; migrated SQL Server 2012 to AWS.
Data Migration Analyst at Jobready Solutions, Sydney
March 1, 2015 - March 1, 2016
Participated in the software development life cycle; designed and managed data migration processes. Designed integration packages for data transformations using Pentaho Kettle. Demonstrated knowledge of advanced SQL queries. Owned ETL design, implementation, development, and testing of data transformation, extraction, and migration activities. Analyzed external data and reported irregularities; developed strategies to support business requirements; created user stories for data migration within Agile methodology.

Education

Professional Year in Information Technology at Performance Education, Sydney
July 1, 2014 - July 1, 2015
Master of Information Technology at Charles Sturt University, Sydney
February 1, 2012 - April 1, 2014
Bachelor of Information Technology at Mumbai University, Mumbai
June 1, 2007 - April 1, 2010

Qualifications

Add your qualifications or awards here.

Industry Experience

Government, Professional Services, Media & Entertainment, Retail, Software & Internet