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:
- Design, create, optimise and maintain conceptual, logical and physical data models across RDBMS, NoSQL and data lake environments.
- Translate business requirements for BI, Analytics and Data Science into effective data models that support insight generation.
- Assess data sources using big data characteristics (volume, velocity, variety, veracity, value) to determine suitable modelling techniques.
- Document and maintain metadata to ensure data consistency, quality and integrity.
- Collaborate with architects, developers and stakeholders to develop conceptual models, strategies and data flows.
- Create physical schemas from logical models, advising on referential integrity and compliance with technical requirements.
- Define and enforce data modelling standards, methodologies and design principles.
- Evaluate and troubleshoot data models, identifying improvements for performance and data quality.
For more information on this position and business unit, view the role description and information pack
About you
- Strong knowledge of data modelling, database design, SQL and technical documentation.
- Deep understanding of schema modelling such as 3NF, dimensional and data vault.
- Ability to translate business needs into scalable long-term data models.
- Experience working in big data environments and balancing trade-offs across OLAP, OLTP and NoSQL.
- Experience with AWS S3, data warehousing, geospatial data and linear asset management systems.
- Hands-on experience using ERWIN or similar modelling tools.
- Skilled in reverse engineering physical models from SQL scripts and databases.
- Working knowledge of Python or cloud-first scripting languages for automation and scheduling.
- Tertiary qualifications in a relevant discipline or demonstrated equivalent experience.
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
Applications close 11:59 PM Tuesday 16th June 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
