Business Intelligence Developer

Profectus; Canberra; Hybrid; AUD 110,000 - 150,000; Full time

Job summary

Profectus is seeking experienced BI Developers to design, build and maintain reports and dashboards for Australian Government programs. The role focuses on semantic data models, complex SQL, and secure, scalable reporting across large data sources.

Hybrid working arrangements with Canberra preference, and the opportunity to work across executive and service delivery teams to translate business needs into robust BI solutions.

Qualifications

• 5+ years in BI or reporting development roles.
• Experience with Power BI, Tableau or similar BI tools.
• Advanced SQL skills.
• Data modelling for reporting (star schemas).
• Gathering and translating reporting requirements.
• Experience working with large data sets from multiple sources.

Responsibilities

• Design, build and maintain reports and dashboards.
• Develop semantic data models and measures for reporting.
• Write SQL queries and data transformations for reporting.
• Gather reporting requirements from business stakeholders.
• Validate report data against source systems and resolve discrepancies.
• Optimise report and data model performance.
• Apply row-level security and access controls to reports.
• Publish, manage and support reports in production.
• Document data sources, report logic and definitions.

Skills

Power BI

Tableau

Advanced SQL

Data modelling

Requirements gathering

Large datasets

Tools

Microsoft Fabric

Azure Synapse

Databricks

DAX

Power Query

PL-300

Job description

Profectus is seeking expressions of interest from experienced BI Developers for likely future opportunities across the Australian Government. The work is likely to require building reports, dashboards and data models that turn large program and operational data sets into information for executives, program areas and service delivery teams.

Key Responsibilities

• Design, build and maintain reports and dashboards
• Develop semantic data models and measures for reporting
• Write SQL queries and transformations to prepare reporting data
• Gather reporting requirements from business stakeholders
• Validate report data against source systems and resolve discrepancies
• Optimise report and data model performance
• Apply row-level security and access controls to reports
• Publish, manage and support reports in production
• Document data sources, report logic and definitions

Required Experience

• Minimum five years in BI or reporting development roles
• Power BI, Tableau or similar BI tools
• Advanced SQL
• Data modelling for reporting, including star schemas
• Gathering and translating reporting requirements
• Working with large data sets from multiple source systems

Desirable Experience

• Microsoft Fabric, Azure Synapse or Databricks
• DAX and Power Query
• Microsoft Power BI Data Analyst (PL-300) certification
• Government or other regulated-industry reporting programs

Security Clearance Requirements

• Must be an Australian Citizen
• Must hold a current AGSVA Baseline Security Clearance (minimum)

Working Arrangements

• Hybrid
• Canberra preferred

Why Profectus

Profectus partners with Australian Government agencies to deliver trusted ICT capability across complex delivery programs. We take a long term, relationship driven approach, supporting our people across the full lifecycle of their engagement while contributing to outcomes of national importance.