BI Developer (Temporary Opportunity until October 2027)

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

Job summary

Transport for NSW is seeking a skilled BI Developer for a fixed-term full-time role in Macquarie Park, NSW. You will design and maintain BI solutions using Power BI, SQL, and DAX to drive evidence-based decisions across the organisation.

You will collaborate with stakeholders to translate requirements into robust data models, automated reports and reliable BI products, ensuring data quality and end-to-end lifecycle support.

Qualifications

• Power BI Developer with strong experience in designing and delivering BI solutions.
• Experience with dimensional modelling including star schemas and date tables.
• Ability to translate business requirements into reliable reporting and data models.

Responsibilities

• Design, develop and maintain BI solutions using Power BI to support data-driven decisions.
• Transform complex data into clear reports, dashboards and semantic models.
• Collaborate with stakeholders to define reporting logic and deliver fit-for-purpose solutions.

Skills

Power BI

SQL

DAX

Power Query

Dimensional modelling

Stakeholder communication

Tools

Git

Azure DevOps

Power BI Project files

Deployment pipelines

Microsoft Fabric

Azure data services

Job description

BI Developer (Temporary Opportunity until October 2027)

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.

For more information on this role and business unit, please view the role description and information pack.

About you

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.

Flexible work optionsmay be available. Learn more viaFlexible work options and policy

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.