Data Modeler - Contract - Melbourne

Hastha Solutions; City of Melbourne; On-site; AUD 110,000 - 160,000; Full time

Job summary

Hastha Solutions is urgently seeking a Data Modeler for a 12-month contract in Melbourne. You will lead enterprise data modeling, design conceptual, logical and physical models, and collaborate with business SMEs.

The ideal candidate has strong experience in dimensional modelling, Data Vault, 3NF, and hands-on use of ER/Studio or Erwin Data Modeler, plus cloud data modelling in BigQuery and data governance practices.

Qualifications

• Strong experience in Data Modelling and Data Architecture. A Data Architect with hands-on modelling expertise is considered ideal.
• Expertise in data modelling methodologies:
• Dimensional Modelling, Data Vault, 3NF (Third Normal Form)
• Proficiency with enterprise modelling tools: ER/Studio, Erwin Data Modeler
• Experience in Logical and Physical Data Model Design, Metadata Management, Data Lineage, Model Governance

Responsibilities

• Develop and maintain the Enterprise Data Model for Australia Post.
• Work closely with Business SMEs to understand business processes.
• Design enterprise data models.
• Support application and integration design rather than purely data warehousing initiatives.
• Design and build Conceptual/Data Models (Conceptual, Logical, Physical).
• Lead data modelling workshops and solution design discussions with business and technical stakeholders.
• Collaborate with Business Analysts and Data Architects to gather, analyse, and refine data requirements.
• Define and maintain Data entities, Relationships, Attributes, and business-aligned data structures.
• Map source systems to enterprise data models and maintain documentation.
• Design and optimize data models for scalability, performance, data quality, and both operational and analytical platforms.

Skills

Data modelling

Data architecture

Dimensional modelling

Data Vault

3NF

ER/Studio

Erwin Data Modeler

Metadata management

Data lineage

Model governance

Cloud data modelling

BigQuery

Performance optimization

Enterprise data architecture

Application integration design

Python/dbt

CI/CD for data

Tools

ER/Studio

Erwin Data Modeler

SqlDBM

Hackolade

Job description

Urgent requirement of Data Modeler - Contract - Melbourne

Requirements

• Strong experience in Data Modelling and Data Architecture. A Data Architect with hands-on modelling expertise is considered ideal.
• Expertise in data modelling methodologies:
• Dimensional Modelling o Data Vault o 3NF (Third Normal Form)
• Proficiency with enterprise modelling tools:
• ER/Studio o Erwin Data Modeler
• Experience in:
• Logical and Physical Data Model Design o Metadata Management o Data Lineage o Model Governance
• Cloud data modelling and optimization experience, specifically:
• Google BigQuery o Physical model implementation and performance optimization in cloud environments
• Strong understanding of:
• Enterprise data architecture o Application and integration design , Analytical and operational data systems

Must Have

• Strong experience in Data Modelling and Data Architecture. A Data Architect with hands-on modelling expertise is considered ideal.
• Expertise in data modelling methodologies:
• Dimensional Modelling o Data Vault o 3NF (Third Normal Form)
• Proficiency with enterprise modelling tools:
• ER/Studio o Erwin Data Modeler
• Experience in:
• Logical and Physical Data Model Design o Metadata Management o Data Lineage, Model Governance

Good-to-Have

• Collibra Certifications (e.g., Ranger, Data Steward, Governance) and GCP Professional Data Engineer.
• Data modeling tools (e.g., erwin, ER/Studio, SqlDBM, Hackolade).
• Experience with data quality/observability tooling (including Collibra DQ/Observability or equivalents) and Data Catalog/MDE integrations.
• Python/dbt for transformations; CI/CD for data (Git, Terraform for infra is a plus).
• Domain experience in Travel, Transportation & Hospitality (TTH) is advantageous.

Responsibility

• Develop and maintain the Enterprise Data Model for Australia Post..
• Work closely with Business SMEs to:
• Understand business processes
• Design enterprise data models
• Support application and integration design rather than purely data warehousing initiatives.
• Design and build:
• Conceptual Data Models
• Logical Data Models
• Physical Data Models aligned to business and enterprise data strategies
• Lead data modelling workshops and solution design discussions with business and technical stakeholders.
• Collaborate with Business Analysts and Data Architects to gather, analyse, and refine data requirements
• Define and maintain:
• Data entities
• Relationships
• Attributes
• Business-aligned data structures
• Map source systems to enterprise data models and maintain comprehensive documentation
• Design and optimize data models for:
• Scalability
• Performance
• Data Quality
• Operational and Analytical Platforms

Duration: 12 Months

and possible extension

Eligibility: Australian/NZ Citizens/PR Holders only

Email: [e-mail]