Data Modeller | Manager | Medallion Architecture | Technology Hub

PwC; Sydney; On-site; AUD 140,000 - 190,000; Full time

Benefits offered by this job

Four weeks' annual leave

Floating public holidays

Professional development

Job summary

PwC Australia is seeking a Data Modeller Manager to lead the Medallion Architecture within Technology Hub. You will guide data modelling initiatives, mentor analysts, and ensure high-quality data insights across the organisation.

This 12-month max-term contract offers exposure to enterprise data warehousing, ETL, and governance, with opportunities to collaborate across business units and platforms within IT.

Qualifications

• Experience designing event and API schemas using registry systems.
• Proficient with modelling tools and schema/version management practices and tools.
• Knowledge of Medallion architectures and data vault concepts.
• Metadata/catalog tools and processes (e.g., Collibra, Alation) and data documentation at scale.
• Understanding of data governance and data quality practices.

Responsibilities

• Lead advanced data analysis projects.
• Lead and develop data models and dashboards.
• Ensure data quality and integrity across sources.
• Collaborate with IT and business units to align data initiatives.
• Support data warehousing and ETL processes.
• Mentor and guide junior analysts in their professional development.
• Deliver timely, actionable data insights.

Skills

Data modelling

Medallion architecture

Stakeholder collaboration

Analytical thinking

Data governance

Tools

ER/Studio

ERwin

PowerDesigner

Git

dbt

Liquibase/Flyway

Collibra

Alation

Job description

Data Modeller | Manager | Medallion Architecture | Technology Hub

Tech Hub enables our company’s businesses to achieve their technology-driven goals. The work undertaken in Tech Hub covers a range of areas from leading and supporting the company through to the build or adoption of new technology, to protecting against risk, and delivering valuable data insights that transform our technology capabilities.The Data Warehousing / Business Intelligence (DW/BI) team is responsible for designing and maintaining data warehouses, integrating and cleansing data from various sources, and optimising data storage and retrieval. The team creates reports, dashboards, and predictive models to provide actionable insights, support decision-making, and drive business performance. We collaborate with cross-functional departments, ensuring data security and compliance, and provide user training and support.As a Data Modeller Manager, you will work with and support the Senior Data Analyst, ensuring the delivery of high-quality data insights and reports. You will manage resources, set priorities, and drive the strategic direction of data initiatives within the organisation.

Why PwC?

At PwC Australia, your skills meet purpose. We tackle big challenges across industries like finance, technology, energy, and health—giving you the chance to make a real impact. Here, your growth is our priority. You’ll work with leading teams, explore new technologies, and unlock your full potential.

Join a global community of more than 370,000 people who value bold ideas, collaboration, and lasting change. Together, we’re building trust and shaping the future.

This role is being offered as a 12-month max term contract

What you’ll do:

• Lead and execute advanced data analysis projects.


• Lead and develop data models and dashboards.


• Ensure data quality and integrity across all data sources.


• Collaborate with business units and other platforms within the IT department to align data initiatives with business goals.


• Support data warehousing and ETL processes.


• Facilitate and implement strategic insights and recommendations based on data analysis.


• Ensure the timely delivery of accurate and actionable data insights.


• Mentor and guide junior analysts in their professional development.

What we’re looking for:

Technology Specific Experience

• Designing event and API schemas (Avro/Protobuf/JSON Schema, OpenAPI), using schema registries, and managing compatibility strategies.


• Proficiency with modelling tools (e.g., ER/Studio, ERwin, PowerDesigner) and schema/version management practices and tools (e.g., Git, dbt, Liquibase/Flyway).


• Designing and optimizing data models for Medallion architectures.


• MDM and reference data management, including golden-record design, identifiers, hierarchies, and integration patterns.


• Metadata and catalog tools and processes (e.g., Collibra, Alation), lineage, and data documentation at scale.

Industry Experience

• Data modelling across conceptual, logical, and physical layers, delivering enterprise-scale models across multiple domains (HR, Finance, Marketing, Sales, Risk etc)


• Establish and enforce modelling standards, naming conventions, and design patterns; maintain the model repository, data dictionary, and metadata.


• Knowledge of multiple modelling paradigms (3NF/normalized, dimensional/Kimball, Data Vault, wide tables) and when to apply each.

Other Specific Role Requirements

• Strong analytical and structured problem-solving skills, with ability to translate between business and technical teams.


• Skilled in assessing and prioritizing AI opportunities based on value and feasibility, balancing ambition, risk, and delivery constraints.


• Experienced in process mapping, requirements definition, stakeholder engagement, and confident collaborating with senior stakeholders.


• Clear communication skills for executive and delivery audiences, supported by formal education in business or related fields and foundational AI training.

What you’ll gain:

• The opportunity to work with leading organisations and cutting-edge technology that challenge and expand your expertise.


• Flexibility means trusting you to choose when, where, and how you work—balancing what’s best for you, your team, and your clients to grow and thrive together.


• Clear paths for career progression supported by continuous learning and leadership development.


• Generous leave entitlements including four weeks’ annual leave and float public holidays to support your work-life balance.

We know that perks are as important as your financial rewards. Explore all the benefits that PwC has to offer here.

Ready to grow here and go further?

We’re committed to treating all our job applicants fairly and with respect, irrespective of their actual or assumed background, disability, neurodivergence, or any other protected characteristic.We want you to have every opportunity to thrive in our selection process. In the application form, you can let us know what adjustments you require during our recruitment process and/or any workplace accommodations you anticipate needing to help you perform your role.