I am a Microsoft Certified Power BI Data Analyst with 8+ years of BI and analytics experience, built on more than two decades working with enterprise solutions, digital transformation, and business analysis. I specialize in Power BI development, advanced DAX, data modelling, and SQL within the Microsoft Azure ecosystem. Lately I architected an automated data quality management framework in Microsoft Fabric for a HRIS legacy-to-Workday migration, achieving 100% data reconciliation across employee, compensation, compliance, learning, and absence datasets. I design silver and gold data layers using Medallion Architecture, leverage AI-assisted development tools to accelerate delivery, and partner with cross-functional teams across healthcare, public sector, manufacturing and professional services to turn complex requirements into scalable, next-generation analytics.

Saman Coliaie

I am a Microsoft Certified Power BI Data Analyst with 8+ years of BI and analytics experience, built on more than two decades working with enterprise solutions, digital transformation, and business analysis. I specialize in Power BI development, advanced DAX, data modelling, and SQL within the Microsoft Azure ecosystem. Lately I architected an automated data quality management framework in Microsoft Fabric for a HRIS legacy-to-Workday migration, achieving 100% data reconciliation across employee, compensation, compliance, learning, and absence datasets. I design silver and gold data layers using Medallion Architecture, leverage AI-assisted development tools to accelerate delivery, and partner with cross-functional teams across healthcare, public sector, manufacturing and professional services to turn complex requirements into scalable, next-generation analytics.

Available to hire

I am a Microsoft Certified Power BI Data Analyst with 8+ years of BI and analytics experience, built on more than two decades working with enterprise solutions, digital transformation, and business analysis. I specialize in Power BI development, advanced DAX, data modelling, and SQL within the Microsoft Azure ecosystem.

Lately I architected an automated data quality management framework in Microsoft Fabric for a HRIS legacy-to-Workday migration, achieving 100% data reconciliation across employee, compensation, compliance, learning, and absence datasets. I design silver and gold data layers using Medallion Architecture, leverage AI-assisted development tools to accelerate delivery, and partner with cross-functional teams across healthcare, public sector, manufacturing and professional services to turn complex requirements into scalable, next-generation analytics.

See more

Experience Level

Expert
Expert
Expert
Expert
Expert

Language

English
Fluent

Work Experience

Senior Data Analyst / Data Lead at Alchemy Solutions
March 1, 2024 - Present
Architected enterprise data quality management framework in Microsoft Fabric implementing automated validation, cleansing, and transformation for HRIS legacy-to-Workday migration across 500K+ employee records, achieving 100% data reconciliation with zero post-go-live integrity issues across employee, compensation, compliance, learning, and absence datasets. Designed silver and gold data layers in Fabric lakehouses following Medallion Architecture principles, optimising enterprise reporting infrastructure for scalable analytics and enabling self-service BI. Leveraged AI-assisted development tools for M Language and Python, improving development efficiency by 40% and accelerating pipeline cycles. Delivered data governance solution analysing 1,120+ Microsoft Teams and SharePoint sites, providing governance recommendations for cleanup and archiving. Developed automated data validation routines ensuring completeness, accuracy, consistency, and referential integrity across multiple data doma
Business Intelligence Developer at ONCALL Group Australia
October 1, 2023 - March 1, 2024
Designed comprehensive financial reporting solution integrating Xero data with dynamic DAX measures for MTD, YTD, Prior Year, and YOY analysis across multi-state operations; enabling executive-level budget variance analysis. Developed Sales Pipeline dashboard with drill-through functionality for data quality insights, win/loss patterns, source analysis, and pipeline progression. Delivered complex finance revenue reports integrating multiple sources with state-specific rules and Service Delivery Type logic; analyzed Hours, Revenue, Cost of Sales, and Profit margins. Implemented advanced data modelling techniques and complex DAX calculations for dynamic KPI tracking to support real-time decision-making.
Business Intelligence Developer at Department of Environment, Energy & Climate Actions (DEECA)
May 1, 2023 - October 1, 2023
Conducted pre-migration assessment of enterprise Report Server infrastructure, documenting As-Is status, datasets, sources, KPIs, reports and dependencies. Designed standardized Power BI template framework for FFMVIC and DEECA reports with dynamic colour palettes and branding guidelines. Led re-implementation of FIRETIMES reporting suite from legacy paginated reports to Power BI Service with enhanced interactivity. Developed Emergency Management Workforce and Standard of Cover reports for large operational datasets, incorporating regulatory requirements.
Power BI Data Analyst at Department of Health - Victoria (DHHS/DH/DFFH)
December 1, 2018 - April 1, 2023
Developed 40+ mission-critical Power BI dashboards supporting statewide COVID-19 response (Vaccination tracking, Case & Contact Tracing, Test Tracker, PPE Monitoring, Rapid Antigen Test data). Delivered reporting solutions for Ministers' Office Database, Procurement Self-Service, and other operational needs. Supported Office 365 migration for 12,000+ users, provisioning governance and automated workflows; provided Level 3 SharePoint support. Created SharePoint Knowledge Base with scripts and documentation to improve team capability.
Power BI Developer/SharePoint SME at Labelmakers Australia Pty Ltd
January 1, 2018 - December 1, 2018
Led digital transformation delivering end-to-end Power BI dashboards and SharePoint solutions across Engineering, Sales & Marketing, HR, QA, and Operations; designed organizational portal on Office 365/SharePoint to centralise processes and enhance cross-department collaboration.
Power BI Developer/SharePoint SME at Deakin University
April 1, 2016 - December 1, 2017
Developed enterprise Procurement System with automated Nintex workflows (Purchase Requisition, Exemption Forms, Sign-off, and Invoice management). Created Tender Document Management with Vendor Surveys; integrated Mobile Management framework into SharePoint Online and delivered end-user training.
SharePoint Consultant/Business Analyst at Catholic Church Insurance
April 1, 2015 - April 1, 2016
Designed and migrated Claim Property and Motor System with Document/Record Management; led Azure to On-prem migration; designed SharePoint Governance Framework.
SharePoint Consultant/Business Analyst at Broad Air NSW Pty
October 1, 2014 - March 1, 2015
Delivered Account/Customer Database, Tender Management, Contract Management, and Project Tracking systems.
SharePoint Consultant at Department of Education
September 1, 2014 - October 1, 2014
Provided Level 3 support for SharePoint 2007/2010/2013 enterprise Farms (Dev, UAT & Prod).

Education

B.Sc. Industrial Engineering – System Analysis and Planning at IAU - Tehran, Iran
September 1, 1996 - April 1, 2000

Qualifications

Microsoft Certified: Power BI Data Analyst Associate
January 11, 2030 - December 25, 2025
Microsoft Certified: Azure Data Fundamentals
January 11, 2030 - December 25, 2025

Industry Experience

Healthcare, Government, Manufacturing, Education, Professional Services