Current jobs related to Data Modeller - Macquarie Park - NSW Government -Transport For NSW

  • Senior Data Modeller

    3 weeks ago


    Parramatta Park, Queensland, Australia Aurec Full time

    Aurec Parramatta, New South Wales, AustraliaAurec Parramatta, New South Wales, AustraliaThis range is provided by Aurec. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.Base pay rangeA$150,000.00/yr - A$170,000.00/yrDirect message the job poster from AurecAdding value to my clients, whilst providing a...

  • Data Analyst

    2 days ago


    Macquarie Park, Australia Apprise Consulting Pty Ltd Full time

    Department: Head Office. Remote Employment Type: Full-Time Compensation: $90,000 About Us The Eptec Group is Australasia's leading corrosion mitigation and protection company specialising in all aspects of corrosion prevention. Our Total Asset Protection solutions and services include Corrosion management; Blasting, painting and remediation of concrete...

  • Microsoft Bu Leader

    6 days ago


    Macquarie Park, Australia Tech Data Full time

    A great opportunity now exists at Tech Data ANZ as the Cloud BU Leader specifically for Microsoft. **Job Purpose**: In this role, you will has an overall responsibility for maximizing the sales from specified major customers creating the highest return for both Tech Data and the vendor. Responsibilities will extend to overseeing the Microsoft Cloud...

  • Data Analyst

    2 weeks ago


    Macquarie Park, Australia Metcash Full time

    **Joining the Metcash Family** At Metcash, you’re **_part of something bigger_**. You have all the perks of a small business heart, without missing out on the big business support. Being part of something bigger means you’re part of a strong purpose, where the work you do makes a big difference to independent business and local communities. It opens a...

  • Data Scientist

    5 days ago


    Macquarie Park, Australia Metcash Full time $120,000 - $180,000 per year

    At Metcash, you're part of something bigger. We've got the heart of a small business with the strength and support of a big business.When you join Metcash, your work makes a real difference to independent businesses and local communities, empowering you to:Grow your career with tailored development programsThrive your way with flexible work optionsMake your...


  • Macquarie Park, Australia Brambles Group Full time

    CHEP helps move more goods to more people, in more places than any other organization on earth via our 300 million pallets, crates and containers. We employ 11,000 people and operate in more than 55 countries. Through our pioneering and sustainable share-and-reuse business model, the world’s biggest brands trust us to help them transport their goods more...


  • Macquarie Park, Australia Metcash Full time

    We are seeking an experienced Data Insights & Reporting Analyst on full time basis based at our Macquarie Park office who will be responsible for driving the improvement of reporting provided across the business and increasing the data analysis undertaken to support strategic business operations. This role will require engagement with senior stakeholders...


  • Macquarie Park, Australia DXC Technology Full time

    DXC Technology (NYSE: DXC) - where brilliant people embrace change and seize opportunities to advance their careers and amplify customer success. DXC’s Analytics practice is a growth area and delivers increased capability and an expanded offering to address the critical data, AI and IOT challenges inherent in solving complex customer business...


  • Macquarie Park, Australia VetPartners Full time

    **Your New Chapter** At VetPartners Australia Pty Ltd, we pride ourselves on delivering shared services support that drives success for our veterinary clinics. The Data Analyst - Pricing at VetPartners plays a pivotal role in developing and standardising pricing strategies for veterinary services. This position focuses on building a data-driven pricing...


  • Macquarie Park, Australia Aegros Therapeutics Pty Ltd Full time

    **Who we are** Aegros is Latin for ‘Patient’. We chose this name because it speaks to our focus on the patient. Every day we strive to place the patient first by providing therapeutic plasma products they would not otherwise be able to access. At Aegros we believe access to life saving therapeutic plasma drugs is a human right and not a privilege. In a...

Data Modeller

3 weeks ago


Macquarie Park, Australia NSW Government -Transport For NSW Full time

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