Business Intelligence Specialist

You see the big picture, you’ve always worked on a grand scale, and now you’re ready to re-focus on grand impact.

Here's your chance to design and deliver efficient, customer-focused services that also enhance accessibility, sustainability and overall quality of living for more people than you've imagined.

In this role, you'll:

• Design, develop and enhance enterprise BI dashboards, reports and data products that support informed decision-making across Transport for NSW.

• Build intuitive, accurate and high-performing Tableau dashboards and visualisations that turn complex data into clear, actionable insights.

• Use SQL to extract, transform, validate and analyse data from multiple sources, including developing efficient queries for reporting and analytics.

• Use Python for data preparation, analysis, automation and solving BI-related data challenges.

• Develop and refine data models and reporting structures using sound dimensional modelling and BI practices.

• Work closely with business and technical stakeholders to understand requirements and translate them into practical, user-focused BI solutions.

• Investigate and resolve data, reporting and data-quality issues while maintaining accuracy and reliability.

• Contribute to BI governance, reporting standards, data quality and continuous improvement across the BI environment.

• Explore emerging analytical technologies and new ways of working to improve efficiency, insights and customer outcomes

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

About you

You are an experienced BI professional who enjoys solving data problems and creating reporting solutions that people can easily understand and use.

To succeed in this role, you will have:

• Strong hands-on Tableau experience, including developing dashboards, calculations, data sources and interactive visualisations.

• Strong SQL skills, with the ability to write and troubleshoot queries for data extraction, transformation, validation and analysis.

• Practical Python experience for data analysis, transformation or automation.

• Strong understanding of data modelling, data visualisation and BI development principles.

• Experience translating business requirements into effective dashboards, reports and analytical solutions.

• Experience identifying and resolving data-quality or reporting issues.

• Strong communication skills and the ability to work effectively with technical and non-technical stakeholders.

• Experience delivering BI solutions within large or complex organisations.

• Relevant tertiary qualifications or equivalent professional experience in business intelligence, data analytics or a related field.

Desirable experience

• Experience with Power BI.

• Experience working with Databricks for data engineering, analytics, data processing or machine learning workloads.

• Experience with AWS Redshift, including data warehousing, SQL-based analytics and performance optimisation.

• Broader experience with enterprise data platforms, data warehousing, analytics and reporting processes.

Who we are

Transport for NSW provides a safe, integrated, and efficient transport system. We connect people, communities and industry every day.

Join us

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 options may be available. Learn more via Flexible work options and policy

Apply today

Applications close 11:59 PM Monday 21 September 2026

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.

Learn more about how to apply via Our recruitment process | Transport for NSW

#LI-Hybrid