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 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.