Role Description
Yolk Digital is looking to fulfil a role with our client, the Department of Foreign Affairs and Trade (DFAT). DFAT is seeking two experienced Power BI Developers / Data Engineers to join its Business Solutions Branch. These roles sit within the Database Management and Dynamics Section and are focused on delivering and maintaining DFAT's Power BI reporting capabilities and data warehouse infrastructure built on Microsoft Fabric.
You will design and build enterprise-grade dashboards, semantic models, and data pipelines, working across the full Microsoft Fabric stack including Lakehouse, Data Factory, and Delta table architecture. A strong grasp of DAX, Power Query, and SQL is essential, alongside hands-on experience with data governance, row-level security, and Power BI Service administration. This is a technically deep, delivery-focused role requiring close collaboration with data engineers, business analysts, and stakeholders to translate complex business requirements into analytics solutions. You will also contribute to CI/CD deployment pipelines, licence optimisation, and ongoing performance tuning across reports and datasets.
Working Arrangements
Onsite: This is a strictly on-site, Canberra-based role requiring five days per week in the office. Remote and interstate candidates will not be considered.
Security Clearance
Candidates must hold or be able to obtain Negative Vetting Level 1 (NV1).
Key Responsibilities
Duties may include some or all of the following:
- Design, develop and deploy interactive dashboards and reports using Microsoft Power BI
- Build and manage enterprise semantic models using Microsoft Fabric Lakehouse and Warehouse
- Develop and optimise data models using DAX and Power Query (M language)
- Implement data ingestion and transformation pipelines using Fabric Data Factory
- Work with Lakehouse architecture leveraging Delta tables
- Implement row-level security (RLS) and data governance best practices
- Administer Power BI Service including tenancy settings, capacity management and workspace governance
- Implement and maintain Role-Based Access Control (RBAC) across workspaces, apps, datasets and Fabric artifacts
- Optimise performance of reports, datasets and queries
- Support CI/CD deployment pipelines for BI artifacts
- Manage gateway configurations and on-premises data connectivity
- Perform licence assignment and optimisation based on user roles and usage patterns
- Ensure data quality, accuracy and documentation standards are maintained
- Collaborate with data engineers, business analysts and stakeholders to translate requirements into analytics solutions
Skills and Experience
- Microsoft Power BI (dashboard and report development)
- DAX and Power Query (M language)
- SQL and data modelling
- Microsoft Fabric (Lakehouse, Warehouse, Data Factory, Dataflows Gen2)
- Delta Lake architecture
- Azure ecosystem (Azure Data Lake, Azure SQL, Entra Key Vault)
- Row-level security (RLS) and RBAC implementation
- Power BI Service administration and tenancy management
- Microsoft licensing and optimisation
- Azure DevOps and Git (advantageous)
Essential Criteria
- 5+ years demonstrated experience in a similar Power BI development or data engineering role
- Strong proficiency in DAX, Power Query (M) and SQL
- Experience with data modelling, Delta Lake architecture, Dataflows Gen2 and Fabric pipelines
- Knowledge of the Azure ecosystem including Azure Data Lake, Azure SQL and Entra Key Vault
- Experience implementing row-level security (RLS) and data governance best practices
- Knowledge of Microsoft licensing, RBAC and Power BI tenancy administration
Desirable Criteria
- Experience with DevOps processes and tools including Azure DevOps and Git
- Hands-on experience with Microsoft Fabric (Lakehouse, Warehouse, Data Factory)
Application Instructions
Upload a one-page pitch (up to 5000 characters) in the "Response to Criteria" section of the application. Your pitch must address the Essential Criteria, and Desirable Criteria. Apply via the website:
https://yolkdigital.com.au/job-board-database/lead-data-engineers
AU
