Data Modeling & DW Solutions Designer

XPT Software Australia Pty Ltd; Sydney; On-site; AUD 110,000 - 140,000; Full time

Job summary

XPT Software Australia Pty Ltd is seeking a Solution Designer in Sydney to join our data and analytics team. You will gather business needs, craft conceptual/logical/physical data models, and design data flows and database solutions in collaboration with development, ETL, and business teams.

You will ensure data quality, consistency, and performance while preparing solution design and technical documentation; strong SQL and data modelling experience with Oracle/SQL Server/PostgreSQL is essential.

Qualifications

• Proven experience in data modelling and SQL development.
• Experience with relational databases (Oracle, SQL Server, PostgreSQL).
• Understanding of Data Warehousing concepts.
• Experience with data modelling tools like ERwin or Visio.
• Strong communication and analytical skills.

Responsibilities

• Gather and understand business requirements.
• Create conceptual, logical, and physical data models.
• Design data flows and database solutions.
• Work with development, ETL, and business teams.
• Ensure data quality, consistency, and performance.
• Prepare solution design and technical documentation.

Skills

Data Modelling

SQL

Oracle

SQL Server

PostgreSQL

Data Warehousing

ERwin

Visio

Communication

Analytical

AWS

Azure

GCP

Job description

XPT Software Australia Pty Ltd is seeking a Solution Designer in Sydney to join our data and analytics team. You will gather business needs, craft conceptual/logical/physical data models, and design data flows and database solutions in collaboration with development, ETL, and business teams.

You will ensure data quality, consistency, and performance while preparing solution design and technical documentation; strong SQL and data modelling experience with Oracle/SQL Server/PostgreSQL is essential.