Organisation/Entity: Transport For NSW- Job Category: Information & Communication Technology- Job Location: Macquarie Park, NSW, AU, 2113- Job Ref No: 79027- Employment Type: Permanent Full-Time- Salary Range: $123470.0-$138284.0**About us**
Transport for NSW keeps our State moving by providing safe, integrated and efficient transport systems. We put our customers at the centre of everything we do - and we do a lot. We connect people, communities and industry and manage how they use our road, rail and maritime networks and services, and even active modes like walking and cycling. The work we do connects the journeys you take every day.
We are a state government organisation made up of more than 28,000 people and we're in the middle of delivering the largest transport infrastructure program in Australia's history. We work across planning, policy and procurement, harnessing data and technology to develop smarter and more adaptive transport solutions.
That means job opportunities in metropolitan and regional areas right across NSW - you have the chance to be part of creating a lasting legacy that will benefit generations to come.
**The Division**
We are a trusted partner to our clients, within Customer Strategy and Technology, developing and delivering smart, integrated and sustainable data and analytics solutions which enable evidence-driven decisions to benefit our customers and communities, and leading an uplift in data literacy of use of data insights across the cluster.
**The opportunity**
Right now, we have an exciting opportunity for a Data Modeller to join us in Data Engineering & Architecture team. It is responsible for developing conceptual, logical, and physical data models for databases and data warehouses, and ensure high data quality and less redundancy while also working with data architects and analyse business requirements, implement data strategies as well as optimise, and update data models.
The role requires strong business stakeholder management ability to ensure stability of the AAI team through its growth.
What you will be involved in but not limited to:
- Create, optimise, update, and maintain conceptual, logical and physical data models in various RDBMS, NoSQL and Data Lake environments.
- Analysing and translating the data modelling needs of the branch in terms of Business Intelligence, Analytics and Data Science use cases to understand how teams are leveraging the data models to derive business and customer insights.
- Work collaboratively in a diverse team environment, including data architects and developers as well as understanding and translating business needs into high-level conceptual data models, data strategies and data flows as required.
- Effectively collaborate with database administrators in creating physical data schema from the logical and physical data models by making recommendations, designing referential integrity, and ensuring compliance with business requirements.
- Design and develop data mapping, code and transformation scripts to support and promote Data Lake / Data Warehouse / RDBMS deliverables as well as design effective ELT logic and code as required.
- Define and govern data modelling and design standards, tools, best practices and related development methodologies as required as well as utilising data modelling tools and associated graphical methods to depict and analyse conceptual, logical and physical data schemas.
- Evaluate data models, business data objects and physical databases and troubleshooting or resolving related issues as well as making recommendations for proper usage or re-use of data models in different environments.
**About you**:
- Working with in big data environments with genuine big data challenges and effectively managing the technical trade-offs between Data Lake, OLAP, OLTP with an understanding of scalability, supportability and performance challenges.
- Experience with modelling data for RDBMS using tools such as ERWIN data modeler or Sparx Enterprise Architect or Lean IX.
- Exposure in reverse engineering of physical data models from databases and SQL scripts.
- Deep understanding of AWS S3 Data Lake, Data Warehouse and experience in working with dynamic geospatial data and linear asset management systems.
- Excellent stakeholder engagement and management skills.
- Ability to influence and quickly build relationships.
- Working knowledge of Python and other cloud first scripting languages for the purposes of automation and process scheduling is a big bonus.
**Want to know more?**
Please click here to view a copy of the role description.
**Interested?**
Right now is an exciting time to join our team as we deliver an iconic $72.2 billion investment into future transport infrastructure and services over 40 years.
**Salary and Benefits**
The salary for this position is TfNSW Grade 8 ($118,015 - $132,176) per annum plus superannuation and leave loading.
**How to apply**
**Application Close date: 11:59pm Monday 24