Senior Power BI Architect: Dataverse & Data Lake

Calleo; Sydney; On-site; AUD 120,000 - 190,000; Full time

Job summary

Calleo is seeking an experienced Senior Power BI Developer to join a Federal Government client. You will design reporting data models and integrate data from Dataverse and Data Lake to deliver high-quality BI reporting and analytics.

The role requires strong expertise in Power BI, data modelling, Dataverse, Data Lake, DAX, Power Query and SQL, with the ability to operate in a complex government environment and set up governed semantic models for self-service reporting.

Qualifications

• Strong experience designing and developing Power BI reporting data models.
• Ability to integrate data from Dataverse and Data Lake environments.
• Expertise in DAX, Power Query, and SQL within a Federal Government context.

Responsibilities

• Design the reporting data model from Dataverse and the Data Lake.
• Build the five standard reports and the executive dashboards.
• Set up row-level security, workspaces and a governed semantic model for self-serve reporting.
• Tune performance and scheduled refresh.
• Document the model and train the business area and sustainment team.
• Leverage DAX, Power Query and SQL for robust reporting.
• Report from Dataverse, including via Azure Synapse Link or a data lake.
• Enable safe self-service reporting for business users.

Skills

Power BI

Data modelling

Dataverse

Data Lake

DAX

Power Query

SQL

Job description

Calleo is seeking an experienced Senior Power BI Developer to join a Federal Government client. You will design reporting data models and integrate data from Dataverse and Data Lake to deliver high-quality BI reporting and analytics.

The role requires strong expertise in Power BI, data modelling, Dataverse, Data Lake, DAX, Power Query and SQL, with the ability to operate in a complex government environment and set up governed semantic models for self-service reporting.