Data & AI Analytics Engineer

Hamilton Barnes; Sydney; On-site; AUD 120,000 - 180,000; Full time

Job summary

Hamilton Barnes seeks a Data, AI & Analytics Engineer to design and implement a modern data and analytics environment using Microsoft Fabric, Power BI and Azure. You’ll support a healthcare transformation program, building a governed data platform and modernising reporting across data engineering, integration, analytics, governance and AI.

You will translate operational needs into scalable data solutions, establish governance and data quality, and explore AI/ML use cases to drive enterprise

Qualifications

• 5+ years in data engineering, analytics or BI.
• Hands-on with Microsoft Fabric and Power BI.
• Advanced SQL, DAX, Power Query and ETL/ELT.
• Experience with Azure data and cloud technologies.
• Knowledge of data modelling, governance and integration.
• Familiarity with Generative AI and enterprise AI apps.
• Experience in data migration or digital transformation.
• Strong stakeholder engagement.

Responsibilities

• Design and build data platforms using Microsoft Fabric including pipelines, lakehouses and warehouses.
• Develop enterprise Power BI dashboards, semantic models, KPIs and reporting solutions.
• Build ETL/ELT processes to integrate data from multiple systems.
• Support data migration, transformation, reconciliation and reporting transitions.
• Establish data quality, governance, lineage and access controls.
• Identify and develop AI/ML and Copilot use cases.
• Integrate data across APIs, databases, SaaS and enterprise apps.
• Work with business leaders to translate operational requirements into scalable data solutions.

Skills

Stakeholder engagement

Communication

SQL

DAX

ETL/ELT

Generative AI understanding

Tools

Microsoft Fabric

Power BI

Azure

Copilot

Dataverse

Purview

Python/PySpark

Job description

Reporting to: CIO / Head of Digital Transformation

About the Company

The Company is a leading Managed Services Provider delivering ICT, cloud, infrastructure and cybersecurity solutions across Healthcare, Education, Professional Services, Government and other enterprise environments. As part of continued growth and a major digital transformation program, the Company is expanding its capabilities across data engineering, analytics and AI.

About the Role

The Company is seeking a Data, AI & Analytics Engineer to design and build a modern data and analytics environment using Microsoft Fabric, Power BI and Azure.

Initially, you will support a major healthcare transformation program, establishing a standalone and governed data platform while modernising reporting and analytics. This is more than a traditional Power BI role you'll work across data engineering, integration, analytics, governance and applied AI.

Key Responsibilities

• Design and build data platforms using Microsoft Fabric, including pipelines, lakehouses and warehouses.
• Develop enterprise Power BI dashboards, semantic models, KPIs and reporting solutions.
• Build ETL/ELT processes to integrate data from multiple operational and corporate systems.
• Support data migration, transformation, reconciliation and reporting transition activities.
• Establish strong data quality, governance, lineage and access controls.
• Identify and develop practical AI/ML and Microsoft Copilot use cases.
• Integrate data across APIs, databases, SaaS platforms and enterprise applications.
• Work with business leaders to translate operational requirements into scalable data solutions.

Requirements

• 5+ years' experience across data engineering, analytics or business intelligence.
• Strong hands-on experience with Microsoft Fabric and Power BI.
• Advanced SQL, DAX, Power Query and ETL/ELT skills.
• Experience with Azure data and cloud technologies.
• Strong understanding of data modelling, integration and governance.
• Understanding of Generative AI, LLMs and enterprise AI applications.
• Experience working on data migration or digital transformation projects.
• Strong stakeholder engagement and communication skills.
• DP-600, Python/PySpark, Dataverse, Purview and Copilot experience highly desirable.
• Healthcare experience is advantageous but not essential.