Senior Fabric & Power BI Data Architect

The HR Ally; City of Melbourne; On-site; AUD 120,000 - 170,000; Full time

Job summary

The HR Ally in Melbourne is seeking an experienced Data Engineer/BI specialist to design and implement scalable data solutions using Microsoft Fabric and Power BI for enterprise reporting and self-service analytics.

You will collaborate with stakeholders to translate analytics requirements into robust, secure data pipelines, models and dashboards while applying governance and best practices across the data platform.

Qualifications

• 5+ years of data engineering / BI experience with strong recent hands-on Microsoft Fabric and Power BI capability.
• Strong Microsoft Fabric experience across Lakehouse, Warehouse, OneLake, Data Factory/Pipelines and semantic models.
• Advanced Power BI development experience including DAX, Power Query, data modelling and performance optimisation.
• Strong SQL skills and practical experience with data transformation and dimensional modelling.
• Experience designing and operating enterprise-grade data pipelines and analytics solutions.
• Understanding of Microsoft Azure data services and integration patterns.
• Experience implementing security, governance, RLS and controlled access to analytical data.
• Working knowledge of Git, CI/CD and deployment practices for data and BI solutions.
• Ability to work independently on complex engineering tasks while collaborating effectively with business and technical stakeholders.

Responsibilities

• Design and build scalable data solutions using Microsoft Fabric, including Lakehouse, Warehouse and OneLake capabilities.
• Develop and maintain data ingestion, transformation and orchestration pipelines using Fabric Data Factory and related services.
• Build robust dimensional and analytical data models that support enterprise reporting and self-service analytics.
• Develop and optimise Power BI semantic models, reports and dashboards using DAX and Power Query.
• Improve performance, reliability and maintainability across Fabric and Power BI workloads.
• Implement appropriate security, Row-Level Security (RLS), access controls and data governance practices.
• Support CI/CD, deployment pipelines, source control and environment promotion for data and BI assets.
• Work with business stakeholders and analysts to translate reporting and analytics requirements into sustainable technical solutions.
• Troubleshoot complex data, model, refresh and performance issues across the Microsoft data stack.
• Collaborate with architects, engineers and delivery leads to align solutions with the broader data-platform direction.
• Produce clear technical documentation and support knowledge transfer to team members.

Skills

Microsoft Fabric

Power BI

DAX

Power Query

SQL

Data modelling

Security/RLS

CI/CD

Git

Azure data services

Tools

Microsoft Fabric

Power BI

Azure Data Factory

Git

Job description

The HR Ally in Melbourne is seeking an experienced Data Engineer/BI specialist to design and implement scalable data solutions using Microsoft Fabric and Power BI for enterprise reporting and self-service analytics.

You will collaborate with stakeholders to translate analytics requirements into robust, secure data pipelines, models and dashboards while applying governance and best practices across the data platform.