Data & AI Analyst - Systems Integrator

Hamilton Barnes; Sydney; Hybrid; AUD 120,000 - 170,000; Full time

Benefits offered by this job

Sydney-based hybrid working环境

Job summary

Hamilton Barnes is seeking a data platform engineer to design and maintain Microsoft Fabric data platforms, pipelines, lakehouses and semantic models for healthcare clients. You will build ETL/ELT processes and deliver Power BI dashboards to enable self-service analytics.

Join a technology services provider expanding its analytics and AI capabilities, applying governance, data quality and privacy controls, and collaborating with stakeholders to define KPIs and measurable outcomes; some travel to

Qualifications

• 5+ years of experience in data engineering, analytics, BI or related fields.
• Hands-on with Microsoft Fabric including lakehouses, warehouses, pipelines and semantic models.
• Advanced Power BI development, including DAX and data modeling.
• Advanced SQL and complex data transformations.
• Experience with ETL/ELT, data ingestion and cloud data architecture.
• Experience integrating data from multiple enterprise apps and healthcare systems.
• Strong communication with both technical and non-technical stakeholders.
• Understanding of governance, privacy and security controls.

Responsibilities

• Design and maintain Microsoft Fabric data platforms (lakehouses, warehouses, pipelines, semantic models).
• Build ETL/ELT processes and integrate data from APIs, databases and SaaS apps.
• Deliver Power BI dashboards and reusable reporting models using DAX and SQL.
• Support healthcare data migration and data separation tasks.
• Apply governance, privacy and security controls across enterprise data.
• Develop AI-assisted analytics using Microsoft Copilot and Azure AI.
• Collaborate with CIO and stakeholders to define KPIs and enable self-service analytics.
• Occasionally attend client offices and hospital sites as required.

Skills

Data engineering

Analytics

BI

Power BI

SQL

ETL/ELT

Azure data services

Data modeling

Governance & quality

Stakeholder communication

Generative AI understanding

Education

Tools

Microsoft Fabric

Azure Data Factory

Azure Synapse

Azure Databricks

Python

PySpark

Git

CI/CD

Purview

Dataverse

Power Platform

Copilot Studio

Azure OpenAI

Job description

Join a technology services provider with decades of experience supporting critical infrastructure through ICT, cloud and managed services. The company is expanding its data, analytics and AI capabilities, with an opportunity to help establish a modern, governed data platform using Microsoft Fabric, Power BI and Azure.

Interested in shaping the future of enterprise data and AI?

Responsibilities

• Design and maintain Microsoft Fabric data platforms, including pipelines, lakehouses, warehouses and semantic models.
• Build ETL/ELT processes and integrate data from APIs, databases, SaaS applications and enterprise systems.
• Deliver Power BI dashboards and reusable reporting models using DAX, Power Query and SQL.
• Support healthcare data migration and technology separation, validating datasets and resolving reporting dependencies.
• Apply data quality, governance, privacy and security controls across enterprise and healthcare information.
• Develop practical AI-assisted analytics using Microsoft Copilot, Azure AI and large language models.
• Work with the CIO, technical teams and business stakeholders to define KPIs, present insights and enable self-service analytics.
• Attend client offices and hospital sites as required.

Required Skills/Qualifications

• 5+ years of experience in data engineering, analytics, business intelligence or related disciplines.
• Strong hands‑on experience with Microsoft Fabric, including lakehouses, warehouses, pipelines and semantic models.
• Advanced Power BI development skills, including DAX, Power Query, dashboards and data modeling.
• Advanced SQL and experience designing complex data transformations.
• Strong understanding of ETL/ELT, data ingestion, orchestration and cloud data architecture.
• Experience integrating data from multiple enterprise applications and operational systems.
• Hands‑on experience with Microsoft Azure data services and cloud technologies.
• Strong understanding of dimensional modeling, semantic modeling and reusable data structures.
• Experience implementing data quality, governance, validation and reconciliation processes.
• Understanding of generative AI, LLMs and enterprise AI applications.
• Experience delivering data solutions within transformation, migration or modernization programs.
• Strong communication skills and the ability to engage technical and non-technical stakeholders.
• A proactive, commercially aware approach to problem-solving and delivering measurable business outcomes.

Desirable Skills

• Microsoft Certified: Fabric Analytics Engineer Associate (DP-600).
• Azure Data Factory, Azure Synapse Analytics or Azure Databricks.
• Python, PySpark, Git and CI/CD.
• Microsoft Purview, Dataverse and Power Platform.
• Microsoft Copilot, Copilot Studio and Azure AI Foundry.
• Experience with Azure OpenAI and enterprise AI integration.
• Experience integrating ERP, HRIS or healthcare systems.
• Microsoft Dynamics 365 Business Central experience.
• Previous experience within healthcare, hospital operations or regulated environments.
• Experience working within an MSP, IT consultancy or systems integrator.
• Healthcare industry experience is highly desirable but not essential; strong Microsoft data engineering, governance and operational analytics experience will be prioritized.

Benefits

• Sydney-based hybrid working environment.
• Full-time, permanent employment.
• Opportunity to contribute to a major enterprise data transformation using Microsoft Fabric, Power BI, Azure and emerging AI technologies.
• End-to-end involvement across data architecture, engineering, integration, analytics and governance.
• Exposure to a business-critical healthcare environment and the development of broader client-facing data and AI capabilities.
• Direct collaboration with technology leadership to shape enterprise analytics and AI adoption.

Salary

• Competitive salary based on qualifications