Data Engineer Consultant (Fabric, Power BI)

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 optimize ETL/ELT processes to ingest, transform, and store data from multiple sources

• Design, develop, and maintain Power BI dashboards, reports, semantic models, and data visualizations

• 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

Qualification

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