Data Engineer Consultant (Fabric, Power BI)

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

Job summary

Avanade Australia Pty Ltd is seeking a Data Engineer Consultant (Fabric, Power BI) in Perth. You will design and build scalable data pipelines, ETL/ELT solutions, and modern analytics platforms using Microsoft Fabric.

You will develop interactive Power BI dashboards, reports, and semantic models to enable data-driven decision-making while ensuring data quality and performance. Work closely with architects, analysts, and stakeholders to deliver secure data insights across batch and near real-time

Qualifications

• Demonstrated experience in data engineering, BI, or data-focused roles.
• Strong experience with Microsoft Fabric and analytics workloads.
• Hands-on expertise in Power BI dashboards, reports, and data modelling.

Responsibilities

• Design, build, and maintain scalable data pipelines and ETL/ELT processes.
• Develop Power BI dashboards, reports, and semantic models.
• Collaborate with architects, analysts, and stakeholders to deliver reliable data and reporting solutions.
• Ensure data quality, security, and performance across data platforms.

Skills

Data Engineering

Power BI

SQL

ETL/ELT

Microsoft Fabric

Data Visualization

Data Warehousing

Cloud platforms

Job description

Data Engineer Consultant (Fabric, Power BI) Location: Perth

Summary: As a Fabric Data Engineer / Power BI Consultant at Avanade, you'll design and build scalable data pipelines, ETL/ELT solutions, and modern analytics platforms using Microsoft Fabric. You will also develop interactive Power BI dashboards, reports, and semantic models that enable data-driven decision‑making. Working closely with architects, analysts, and business stakeholders, you'll deliver secure, high‑quality data and insights across batch and near real‑time use cases while continuously improving performance, reliability, and user experience.

Key Responsibilities

• Design, build, and maintain scalable data pipelines and data integration solutions using Microsoft Fabric
• Develop and optimise ETL/ELT processes to ingest, transform, and store data from multiple sources
• Design, develop, and maintain Power BI dashboards, reports, semantic models, and data visualisations
• Translate business requirements into meaningful analytics and reporting solutions
• Work closely 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 and Experience

• 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
• Strong experience with 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 optimisation 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; however, Australian Permanent Residents (PR holders) will also be considered.