Data Engineer Analyst (Fabric, Power BI)

8207 Avanade Australia Pty Ltd Company; Perth; On-site; AUD 120,000 - 160,000; Full time

Job summary

8207 Avanade Australia Pty Ltd Company in Perth is seeking a Data Engineer Analyst (Fabric, Power BI) to design, build, and maintain data pipelines and BI solutions. You will work with Microsoft Fabric, Power BI, and SQL to deliver scalable analytics and reporting capabilities across multiple data sources.

The role emphasizes collaboration with data architects, business analysts, and stakeholders, with a focus on data quality, security (RLS) and near-real-time processing.

Qualifications

• Demonstrated experience in Data Engineering, BI, or data-focused engineering roles.
• Strong experience with Microsoft Fabric, Lakehouse, Data Factory, Data Warehouse, and analytics workloads.
• Hands-on expertise in Power BI development, including dashboards, reports, data modelling, DAX, and semantic models.
• Strong SQL skills and experience with relational and analytical data platforms.
• Proficiency in ETL/ELT development and data pipeline orchestration.
• Experience with cloud data platforms such as Microsoft Fabric, Azure Databricks, Synapse, or equivalent.

Responsibilities

• Design, build, and maintain scalable data pipelines and data integration solutions using Microsoft Fabric.
• Develop and optimize ETL/ELT processes to ingest, transform, and store data from multiple sources.
• Create and maintain Power BI dashboards, reports, semantic models, and data visualizations.
• Translate business requirements into meaningful analytics and reporting solutions.
• Collaborate with data architects, business analysts, and stakeholders to deliver reliable data and reporting solutions.
• Implement data processing solutions across batch and near-real-time use cases.
• Ensure data quality, reliability, and performance across data platforms and reporting solutions.
• Support cloud-based data platforms, data lakes, lakehouses, and data warehouses.
• Apply data security, privacy, Row-Level Security (RLS), and access control requirements across data and reporting solutions.
• Troubleshoot and resolve data pipeline, data quality, and Power BI performance issues.
• Contribute to automation, monitoring, governance, and continuous improvement of data engineering and BI practices.

Skills

Power BI

SQL

ETL/ELT

Data modeling

DAX

CI/CD for data

Education

Bachelor's degree

Tools

Microsoft Fabric

Data Factory

Lakehouse

Azure Databricks

Synapse

Job description

Overview

Data Engineer Analyst (Fabric, Power BI) – Perth

Responsibilities

• Design, build, and maintain scalable data pipelines and data integration solutions using Microsoft Fabric.
• Develop and optimize ETL/ELT processes to ingest, transform, and store data from multiple sources.
• Create and maintain Power BI dashboards, reports, semantic models, and data visualizations.
• Translate business requirements into meaningful analytics and reporting solutions.
• Collaborate with data architects, business analysts, and stakeholders to deliver reliable data and reporting solutions.
• Implement data processing solutions across batch and near-real-time use cases.
• Ensure data quality, reliability, and performance across data platforms and reporting solutions.
• Support cloud-based data platforms, data lakes, lakehouses, and data warehouses.
• Apply data security, privacy, Row-Level Security (RLS), and access control requirements across data and reporting solutions.
• Troubleshoot and resolve data pipeline, data quality, and Power BI performance issues.
• Contribute to automation, monitoring, governance, and continuous improvement of data engineering and BI practices.

Qualifications

• Demonstrated experience in Data Engineering, Business Intelligence, or data-focused engineering roles.
• Strong experience with Microsoft Fabric, including Lakehouse, Data Factory, Data Warehouse, and analytics workloads.
• Hands‑on expertise in Power BI development, including dashboards, reports, data modelling, DAX, and semantic models.
• Strong SQL skills and experience with relational and analytical data platforms.
• Proficiency in ETL/ELT development and data pipeline orchestration.
• Experience working with structured, semi-structured, and large-scale datasets.
• Experience with cloud data platforms such as Microsoft Fabric, Azure Databricks, Synapse, or equivalent.
• Familiarity with dimensional modelling, Star Schema, and performance optimization techniques.
• Experience implementing Row-Level Security (RLS) and Power BI governance best practices.
• Experience with CI/CD pipelines and DevOps practices for data and analytics solutions.
• Strong analytical, problem‑solving, stakeholder management, and troubleshooting skills.

Location & Work Rights

This role is based in Perth, Western Australia. Candidates currently based in Perth or willing to relocate to Perth are encouraged to apply. Australian Citizens are highly preferred; Australian Permanent Residents (PR holders) will also be considered.