Data Engineer & BI 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

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.