Business Intelligence Specialist

NSW Public Service Commission; Sydney; On-site; AUD 138,000 - 154,000; Full time

Job summary

Transport for NSW is seeking a Business Intelligence Specialist to design and deliver enterprise BI dashboards, reports and data products that support informed decision-making across the organisation. You will develop Tableau dashboards, build accurate visualisations and use SQL and Python to analyse data from multiple sources.

The role focuses on data modelling, governance and collaboration with business and technical stakeholders to translate requirements into practical BI solutions, ensuring

Qualifications

• Strong hands-on Tableau experience with dashboards and visualisations.
• Proficiency in SQL for data extraction, transformation and analysis.
• Practical Python for data analysis or automation.
• Knowledge of data modelling and BI development principles.

Responsibilities

• Design, develop and enhance enterprise BI dashboards and reports.
• Create Tableau dashboards and visualisations for insights.
• Write efficient SQL queries for reporting and analytics.
• Use Python for data preparation and automation.
• Refine data models and reporting structures using dimensional modelling.
• Collaborate with stakeholders to translate requirements into BI solutions.
• Investigate data quality issues and contribute to governance.

Skills

Tableau

SQL

Python

Data modelling

BI development

Stakeholder comms

Data quality

Power BI

Databricks

AWS Redshift

Data warehousing

Education

Relevant tertiary qualification

Tools

Databricks

AWS Redshift

Job description

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

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.