Data Engineer Analyst (Fabric, Power BI)

Job Description

Data Engineer Analyst (Fabric, Power BI)

Location: Perth

Summary

As a Fabric Data Engineer / Power BI Analyst 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.