Job title: Senior Data Modeller
Job type: Contract
Emp type: Full-time
Pay interval: Hourly
Pay rate: negotiable
Job published: 20/11/2026

Job Description

Job Title: Senior Data Modeller

Security Clearance: Must be able to obtain Baseline

Duration: Initial 12 months with 1 x 12-month extension

Industry: Information Technology

Functional Expertise: Data Management and Analytics

Sub-functional Expertise: Enterprise Data Modelling, Data Warehousing and Database Design

Location of work: Canberra, ACT

Working arrangements: Hybrid – Remote and flexible working arrangements may be discussed with the relevant manager upon commencement. A formal Working from Home Agreement is required.

Closing date: 9AM Wednesday, 25 November 2026

Description:

Our client is seeking an experienced Senior Data Modeller to support the design, development and optimisation of enterprise data solutions within a complex IT environment.

The successful candidate will be responsible for developing conceptual, logical and physical data models, translating business requirements into technical data solutions and ensuring data integrity, quality and performance across enterprise data warehouse environments.

This role requires extensive experience in enterprise data modelling, database design, SQL and data warehousing technologies. The successful candidate will collaborate with technical teams and business stakeholders to deliver scalable data solutions, establish modelling standards and support continuous improvement initiatives.

The position also involves providing technical guidance, conducting performance optimisation activities and ensuring data solutions align with established architecture principles and data modelling frameworks.

Responsibilities:

  • Develop conceptual, logical and physical data models for Enterprise Data Warehouse (EDW) core and access layers.

  • Establish peer review processes, data modelling standards and release management practices.

  • Lead the technical implementation of new data solutions, including data dictionary development and modelling best practices.

  • Conduct performance tuning and optimisation activities to improve existing data solutions.

  • Facilitate knowledge transfer sessions covering data modelling methodologies, release processes and technical standards.

  • Drive continuous improvement in development practices, coding standards, documentation and team capabilities.

  • Design and implement enterprise data models using System Development Life Cycle (SDLC) and Agile methodologies.

  • Work with enterprise data warehouse technologies, including Teradata, Informatica, Cloudera, SAS, Cognos, Qlik, Oracle and Power BI.

  • Collaborate with stakeholders to understand business requirements and translate them into detailed data models.

  • Maintain technical standards, performance service level agreements and data quality frameworks.

  • Identify and resolve data quality issues in collaboration with delivery teams.

  • Manage stakeholder relationships and associated delivery risks.

  • Provide technical guidance and communicate complex data modelling concepts to technical and non-technical audiences.

Requirements:

  • Minimum 5 years' relevant experience in data modelling, enterprise data warehousing or related IT disciplines.

  • Demonstrated expertise in conceptual, logical and physical data modelling.

  • Strong understanding of database design, data architecture and enterprise data solutions.

  • Experience working with Enterprise Data Warehouses and associated technologies.

  • Advanced SQL skills, including querying, interpreting and optimising complex datasets.

  • Demonstrated experience delivering solutions using SDLC and Agile development methodologies.

  • Experience with technologies such as Teradata, Informatica, GCP, SAS, Cognos, Qlik and Oracle.

  • Relevant IT qualifications, certifications or equivalent professional experience.

  • Strong communication, stakeholder engagement and problem-solving skills.

  • Ability to work independently and collaboratively within multidisciplinary teams.

  • Must be able to obtain Baseline security clearance.

Key Capabilities:

  • Enterprise Data Modelling: Expertise in designing and implementing conceptual, logical and physical data models within complex enterprise environments.

  • Data Warehousing: Strong knowledge of EDW architecture, data integration and associated technologies.

  • Database Design and SQL: Advanced capability in SQL querying, database optimisation and data management.

  • Technical Leadership: Ability to establish modelling standards, conduct peer reviews and provide technical guidance to development teams.

  • Data Quality and Governance: Experience maintaining data integrity, quality frameworks and technical compliance standards.

  • Agile Delivery: Demonstrated ability to deliver enterprise data solutions using Agile methodologies and SDLC processes.

  • Stakeholder Engagement: Ability to translate complex business requirements into technical solutions and maintain productive stakeholder relationships.

  • Communication: Strong verbal and written communication skills, including explaining technical concepts to non-technical audiences.

  • Problem-Solving: Ability to identify and resolve complex data modelling, integration and performance issues.

Essential Criteria:

  • Demonstrated ability to deliver business solutions through the System Development Life Cycle (SDLC) and Agile development practices and processes (for each of the specific roles defined)

  • 5+ years’ experience working and exhibiting knowledge (for the specific role defined)

  • Demonstrated interpersonal skills and capacity to communicate and work effectively within a multi-disciplined and blended team environment

  • Relevant qualifications/certification/accreditation (for each of the specific roles defined)

  • Experience and knowledge of Enterprise Data Warehouses (EDW) and associated technologies (such as Teradata, Informatica, GCP, SAS, Cognos, Qlik, Oracle etc.)

  • Demonstrated ability to query and interpret data using efficient and effective SQL and provide sound advice on complex data/information related matters to deliver quality solutions.

  • Proven ability to work in a team environment, with the ability to work with limited supervision and achieve results.

  • A high level of organisation and good time management skills, including a demonstrated ability to meet priorities and work to deadlines;

  • A demonstrated ability to engage with requesting business areas and project stakeholders;

  • Ability to discuss technical issues/solutions with both technical and non-technical staff; and

  • Bachelor's degree in IT; or equivalent experience.

Additional Essential Criterion:

- Extent to which the Candidate's response and CV meets the Department's requirement as outlined within the Role Description and Key Duties and Responsibilities.

Applicants must provide a one-page pitch addressing all specified criteria, with a maximum of 5,000 characters.

How to apply:

Please submit your application including your resume and a completed application form addressing the essential and desirable criteria. Ensure your application highlights your experience and any relevant certifications.

File types (doc, docx, pdf, rtf, png, jpeg, jpg, bmp, jng, ppt, pptx, csv, gif) size up to 5MB
File types (doc, docx, pdf, rtf, png, jpeg, jpg, bmp, jng, ppt, pptx, csv, gif) size up to 5MB