Data Modeller

ClearCompany; City of Melbourne; Hybrid; AUD 120,000 - 150,000; Full time

Job summary

A leading technology provider is seeking an experienced Data Modeller to join their team in Melbourne, VIC. This role involves designing and implementing robust data models while ensuring data quality and governance. The ideal candidate will have extensive experience in data modeling, strong proficiency in SQL, and familiarity with BI tools like Tableau. Candidates should also have excellent problem-solving and communication skills. This is a hybrid role for a 3 to 6 month contract.

Qualifications

• Extensive experience in Dimensional Modeling and Data Vault methodologies.
• Strong experience in Data Modeling across large-scale data environments.
• Proficiency in designing and optimizing relational databases using Advanced SQL.
• Experience with Tableau or other leading BI tools.
• Proficiency in Data Governance and Data Quality practices.
• Skilled in ETL or ELT design.
• Excellent analytical, conceptual, and problem-solving skills.
• Strong communication skills for technical and non-technical audiences.
• Experience with relevant data modeling tools.

Responsibilities

• Design and maintain conceptual, logical, and physical data models.
• Collaborate with DBAs to optimize physical database design.
• Conduct source system analysis and reverse engineering of databases.
• Develop and maintain data dictionaries and metadata repositories.
• Define and implement data standards and quality rules.
• Develop data segmentation strategies for insights.
• Collaborate with stakeholders to understand data needs.
• Provide guidance on ETL/ELT processes.

Skills

Dimensional Modeling (Star/Snowflake Schema)

Data Vault methodologies

Advanced SQL

Tableau

Data Governance

ETL/ELT design

Analytical skills

Communication skills

Data modeling tools

Education

Bachelor's degree in Computer Science

Tools

Erwin

SqlDBM

DataGrip

Job description

Overview

At Sirius, we are looking for an experienced Data Modeller to help our client, which is a large integrated energy industry provider in Australia.

This is a daily rate contract hybrid role for the next 3 to 6 months for a Data Modeller located in Melbourne, VIC, with some work from home flexibility.

The Data Modeller will be responsible for creating, implementing, and managing robust data models (conceptual, logical, and physical), ensuring data quality and rigorous governance across the client's enterprise systems.

Key Duties and Responsibilities

• Model Design and Documentation: Designing and maintaining conceptual, logical, and physical data models using industry best practices (e.g., 3NF, Dimensional, Data Vault) to support transactional, operational, and analytical needs (Data Warehouses, Data Marts).
• Performance Optimization: Collaborating with Database Administrators and Engineers to optimize physical database design for performance, including indexing strategies, partitioning, and storage procedures.
• Reverse Engineering and Analysis: Conducting in-depth source system analysis and reverse engineering of existing databases to understand data structures and identify data lineage.
• Metadata and Dictionary Management: Developing and maintaining comprehensive data dictionaries, glossaries, and metadata repositories to ensure clear understanding and standardisation across the business.
• Quality and Governance: Defining and implementing data standards, naming conventions, and quality rules to uphold data integrity and governance frameworks.
• Data Segmentation and Insights: Developing quality data segmentation strategies to enable targeted customer insights, marketing automation, and business reporting.
• Stakeholder Collaboration: Working closely with business stakeholders, subject matter experts, and data engineers to understand data needs and translate complex requirements into scalable, actionable data solutions.
• ETL/ELT Involvement: Providing technical guidance to the Data Engineering team on ETL/ELT processes, ensuring the data transformation logic aligns with the approved data model design.

Qualifications

• Extensive experience in Dimensional Modeling (Star/Snowflake Schema) and Data Vault methodologies.
• Strong experience in Data Modeling and Data Segmentation across large-scale data environments.
• Proficiency in designing and optimizing relational databases using Advanced SQL (including complex joins, window functions, and stored procedures).
• Experience with Tableau or other leading BI tools (Power BI, Looker) for validating models and building foundational reports.
• Proficiency in Data Governance and Data Quality practices, including defining and tracking key data quality metrics.
• Skilled in Extract, Transform, Load (ETL) or Extract, Load, Transform (ELT) design and pipeline development.
• Excellent analytical, conceptual, and problem-solving skills, with a focus on delivering high-performance solutions.
• Strong communication and presentation abilities to clearly articulate complex data concepts to both technical and non-technical stakeholders.
• Experience with relevant data modeling tools and software (e.g., Erwin, SqlDBM, or DataGrip).
• Bachelor's degree in Computer Science, Information Technology, or a related field.

Ideal Background

• Utilities, Integrated Energy, Telco, and Retail sector experience is highly advantageous.
• Experience in Customer Insights, Customer Segmentation, and AMI (Advanced Metering Infrastructure) data would be beneficial.
• Familiarity with Cloud Data Platforms (e.g., AWS, Azure, or GCP) is a plus.

Should you wish to discuss, please contact Kevin Gonzalez, our IT Principal Consultant (Data, AI and Cyber), via DM or apply to this job advertisement.

Your interest will be treated in the strictest of confidence and our client as well as Sirius Technology are equal opportunity employers and we encourage candidates from all backgrounds to apply.