Data Modeller

About the Role

Title: Data Modeller

Location: Melbourne, Victoria, Australia

Hybrid

Full-time

Job Description:

Position Description:

Recognised as one of the world's largest IT and business consulting firms, CGI has offices across Australia, supporting local public and private sector clients to solve real business problems.

We are looking to hire a Data Modeller who will focus on translating complex business requirements into clear, scalable, conceptual, logical, and physical data models that support analytics, reporting, and operational needs. Working closely with data engineers, analysts, and business stakeholders, the Data Modeller ensures that data is well-organized, standardized, and aligned with governance and quality frameworks to enable efficient data-driven decision making across the organization.

Flexible work is available including hybrid work from client's site at Port Melbourne

Your future duties and responsibilities:

• Contribute to the design, development, and continuous refinement of conceptual, logical, and physical data models within the Data Transformation team.

• Create and maintain SQL DDL scripts, along with detailed mapping and ETL documentation, to support Data Engineers in constructing and loading data models.

• When required, carry out reverse engineering of existing data models from databases or SQL code to ensure alignment with current architecture and standards.

• Develop and update business documentation, including process maps, taxonomies, and ontology diagrams, to provide clarity and traceability of data flows.

• Maintain a strong emphasis on conceptual and business data modelling, ensuring that structures align with organisational objectives.

• Interpret and translate business requirements into scalable data models that support long-term analytical and operational needs.

• Assist in managing and maintaining controlled vocabularies and the corporate data catalogue to promote consistency and reuse of data assets.

• Participate in modelling workshops and collaborative sessions with other Data Modellers to align on best practices and design approaches.

• Adhere to existing Data Quality and Data Governance frameworks, contributing to their ongoing enhancement and ensuring compliance with modelling standards.

• Build and maintain effective working relationships with subject matter experts and business stakeholders across the organisation.

• Keep stakeholders and senior management informed of prioritisation decisions, project progress, and delivery timelines, managing expectations clearly and proactively.

Required qualifications to be successful in this role:

• Sound understanding of data modelling methodologies, including Kimball, Inmon, Top-down/Bottom-up, Relational and Dimensional Modelling, Data Warehousing, and 3NF approaches.

• Ability to think conceptually and apply modelling techniques such as generalisation, subtyping, and super-typing to create efficient and flexible models.

• Skilled in producing Entity Relationship Diagrams (ERDs) using a range of notations, such as Crow's Foot and UML.

• Strong technical understanding of databases, ETL/ELT pipelines, and programming languages (typically SQL), with the ability to connect these technologies to data modelling practices. (This is a hands-on role involving active work with data.)

• Solid comprehension of business processes, with the ability to capture requirements accurately and translate them into effective technical designs.

• Confident communicator, capable of engaging in technical discussions with both technical and non-technical audiences across all organisational levels.

• Experience with cloud-based data technologies, particularly within the Microsoft Azure ecosystem, including:

• Azure Data Lake

• Azure Data Factory

• Azure Databricks (SQL and Python)

• Azure SQL Server

• Azure DevOps / Git

Skills:

• GIT

• GIT

• SQLite

What you can expect from us:

Together, as owners, let's turn meaningful insights into action.

Life at CGI is rooted in ownership, teamwork, respect and belonging. Here, you'll reach your full potential because…

You are invited to be an owner from day 1 as we work together to bring our Dream to life. That's why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our company's strategy and direction.

Your work creates value. You'll develop innovative solutions and build relationships with teammates and clients while accessing global capabilities to scale your ideas, embrace new opportunities, and benefit from expansive industry and technology expertise.

You'll shape your career by joining a company built to grow and last. You'll be supported by leaders who care about your health and well-being and provide you with opportunities to deepen your skills and broaden your horizons.

Come join our team-one of the largest IT and business consulting services firms in the world.