Organisation/Entity: Transport For NSW
Job category: Projects
Job location: Macquarie Park, NSW, AU, 2113
Job reference number: 106689
Employment type: Permanent Full-Time
Salary range: $137,551 - $154,055
Role Overview
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.
Responsibilities
* 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.
Qualifications
* 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.
EEO Statement
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.
Applications close 11:59 PM Tuesday 16th June 2026.
For more information about this role, please contact CHANDINI.NANDRA@TRANSPORT.NSW.GOV.AU.
#J-18808-Ljbffr