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
Permanent and Fixed-Term Opportunities Available
Your future role 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.
Experience required to be successful in this role:
* Sound understanding of data modelling methodologies, including Kimball, Inmon, Top-Sdown/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 would be advantageous, particularly within the Microsoft Azure ecosystem, including:
* Azure Data Lake
* Azure Data Factory
* Azure Databricks (SQL and Python)
* Azure SQL Server
* Azure DevOps / Git
Why work for CGI?
Make a difference
From utilities and cybersecurity to government and financial service, we provide high end IT and business consulting to the world's most vital and exciting sectors. We're proud to partner with our clients to bring real business value and contribute to their success by delivering practical innovation that helps them meet their goals.
Your work is what you make it.
We provide a working environment where our CGI Partners are empowered to shape their careers and take on new responsibilities. As owners, we have the opportunity to drive our careers, forge meaningful relationships with our clients, and benefit from a job well done.
We enjoy what we do
As owners, we're invested in creating an environment where we enjoy working together and learning from each other. We work with teams from all across the world and celebrate our CGI Partners' unique differences. We thrive on building strong relationships with our fellow CGI Partners and supporting each other to develop professionally and achieve our potential.
Great benefits and work-life balance
We strongly believe that work-life balance is crucial to our success and the success of our CGI Partners. At CGI, a positive work-life balance is encouraged and supported. We offer flexible work wherever possible and invest in benefits and services that are truly valued by our CGI Partners, such as our world leading health and wellbeing program, Oxygen.
Diversity statement
At CGI, we recognise the richness that diversity brings. We strive to create a work culture where everyone belongs, and we collaborate with clients in building more inclusive communities. As an equal opportunity employer, we empower all our CGI Partners to succeed and grow.
CGI is proud to be a Work180 endorsed employer for all women.
We are committed to providing an inclusive, diverse and equal opportunity workplace. When you apply, please share any reasonable adjustments you may need during the interview process.
Apply today for more information.