BI Developer

Transport for NSW; Sydney; On-site; AUD 125,000 - 140,000; Full time

Job summary

Transport for NSW is seeking a hands-on BI Developer to design, develop, and maintain BI solutions that empower data-driven decisions. You’ll transform complex data into clear reports, dashboards and semantic models using Power BI Desktop, Service, SQL and DAX.

You’ll collaborate with stakeholders to translate business requirements into maintainable solutions, ensure data quality, automate reporting, and optimise BI products throughout their lifecycle.

Qualifications

• Design, develop and maintain BI solutions that support data-driven decision-making across Transport for NSW.
• Transform complex data into clear, accurate reports, dashboards and semantic models using BI tools.
• Translate business requirements into maintainable technical solutions and explain reporting logic to stakeholders.
• Ensure data quality, automate reporting processes, and improve reliability and maintainability of BI products.
• Experience with Power BI workspaces, apps, scheduled refresh, gateways, permissions and row-level security.

Responsibilities

• Design, develop and maintain BI solutions supporting data-driven decisions across NSW Transport.
• Use Power BI Desktop, Service and SQL to create reports, dashboards and semantic models.
• Collaborate with stakeholders to define reporting logic and deliver fit-for-purpose solutions.
• Support data quality, automate reporting, troubleshoot issues and improve BI reliability.

Skills

Power BI Desktop

Power BI Service

SQL

DAX

Power Query/M

Dimensional data modelling

Star schemas

Stakeholder communication

Tools

Git

Azure DevOps

Microsoft Fabric

Azure data services

Deployment pipelines

Job description

BI Developer (Temporary Opportunity until October 2027)

Organisation/Entity: Transport For NSW

Job category: Human Resources & Recruitment

Job location: Macquarie Park, NSW, AU, 2113

Job reference number: 111289

Employment type: Fixed Term Full-Time

Salary range: $124810.0-$139787.0

Your career path could surprise even you, there's so much variety. You're all about the detail and this role will allow you to drive evidence-based decision making to optimise systems and efficiency, not just for the business but for our customers too. It's data and research with impact you can see.

In this role, you'll:

Work as part of the Business Intelligence team, you will design, develop and maintain BI solutions that support data-driven decision-making across Transport for NSW.

You will use Power BI Desktop, Power BI Service and SQL to transform complex data into clear, accurate and actionable reports, dashboards and semantic models.

You will work with stakeholders to understand business requirements, define reporting logic and deliver fit-for-purpose solutions. You will also support data quality, automate reporting processes, troubleshoot reporting issues and identify opportunities to improve the reliability and maintainability of BI products.

You are an experienced, hands‑on Power BI Developer with strong skills in Power BI Desktop, Power BI Service, Power Query/M, DAX and SQL.

You have practical experience in dimensional data modelling, including star schemas, table grain, relationships and date tables, and can diagnose issues across data sources, transformations, models, calculations and report visuals.

You understand Power BI workspaces, apps, scheduled refresh, gateways, permissions and row-level security, and can develop and support reliable BI solutions through their full lifecycle.

You can translate business requirements into maintainable technical solutions, explain reporting logic clearly and work effectively with technical and non-technical stakeholders. You are collaborative, detail-focused and committed to data quality and accurate reporting.

Experience with Git or Azure DevOps, Power BI Project files, deployment pipelines, Microsoft Fabric, Azure data services or performance optimisation will be highly regarded.

Who we are

Transport for NSW provides a safe, integrated, and efficient transport system. We connect people, communities and industry every day. Our workforce is as diverse as the community we serve. If you’d like further information on our inclusion and diversity initiatives, visit Transport careers .

For more information about this role, please contact [e-mail].

Aboriginal people and people living with disability are supported throughout the recruitment process and at work, and we encourage you to apply. Visit Supporting Aboriginal People or Supporting People with Disability for more information or speak to your talent team member to arrange any adjustments to how you interact with us.

Transport acknowledges the Aboriginal people of the country on which we work, their traditions, culture and a shared history and identity. We also pay our respects to Elders past and present and recognise the continued connection to country.