Business Intelligence Specialist

Organisation/Entity: Transport For NSW

Job category: Projects

Job location: Macquarie Park, NSW, AU, 2113

Job reference number: 106373

Employment type: Permanent Full-Time

Salary range: $137551.0-$154055.0

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 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 effective 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

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.
- 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.

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 .

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.

Job Segment:

Business Intelligence, Data Warehouse, Data Analyst, Database, SQL, Technology, Data

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.

#J-18808-Ljbffr

📌 Business Intelligence Specialist (New South Wales)
🏢 Nsw Public Service Commission
📍 New South Wales