Business Intelligence Data Modeller & Analyst (Temporary Opportunity - up to 12 months)
Transport for NSW Sydney, New South Wales, Australia
Government Administration · 10,001+ employees
About the role
You will create scalable data foundations and models to support reporting, analytics, and decision-making across Sydney Metro. Additionally, you will ensure data is structured, governed, and trusted while collaborating with stakeholders and engineers to deliver reliable insights.
What they look for
Requirements
The role requires an experienced BI professional with strong expertise in dimensional and relational data modelling and business analysis. You must possess strong technical skills in SQL, a commitment to data governance, and the ability to translate complex business needs into practical data solutions.
Benefits
Full description
You see the big picture, you’ve always worked on a grand scale, and now you’re ready to re-focus on grand impact.
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:
Help create the data foundations that support reporting, analytics, and decision-making across Sydney Metro. You will work closely with business stakeholders, data engineers, and architects to understand information needs and translate them into clear, scalable, and reusable data models that enable accurate and consistent reporting.
This role is about more than building reports. You'll play a key part in ensuring data is structured, governed, and trusted across the organisation. Your work will help deliver reliable insights that support better decisions on one of New South Wales' largest infrastructure programs, contributing to improved project outcomes and service delivery for the community.
For more information on this position and business unit, view the role description and information pack.
About you
You are an experienced BI professional with a strong background in data modelling and business analysis. You enjoy working with stakeholders to understand their requirements and can translate complex business needs into simple, practical, and maintainable data models that support reporting and analytics.
You bring strong technical skills, a collaborative approach, and a commitment to data quality and governance. You are comfortable working with multiple stakeholders, balancing competing priorities, and partnering with data engineers and architects to deliver effective data solutions that create long-term value for the organisation.
Key Skills and Experience:
- Strong experience designing and maintaining dimensional and relational data models
- Ability to create simple, scalable, and reusable data structures that support reporting and analytics
- Experience gathering business requirements and facilitating stakeholder discussions
- Apply BI expertise to unlock strategic value from data — proactively identifying where models and analytical insight can move the needle for the business
- Knowledge of data governance, data quality, and compliance principles
- Strong documentation and communication skills
- SQL skills to validate, test, and analyse data models
- Ability to work collaboratively with business stakeholders, subject matter experts, data engineers, and architects
- Demonstrated commitment to the NSW Government Five Ways of Leading behaviours
Join Sydney Metro and help build trusted data foundations that enable consistent, reliable insights and support better decision-making across the organisation.
Who we are
Transport for NSW provides a safe, integrated, and efficient transport system. We connect people, communities and industry every day.
Sydney Metro delivers Australia’s biggest public transport project and first driverless railway. We engage with our customers and community, and contribute to vibrant and attractive places through station design, interchanges and precincts.
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, 31 August 2026
For more information about this role, please contact KATHERINE.SWAN@TRANSPORT.NSW.GOV.AU.
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
