P

PricewaterhouseCoopers (PwC)

Global professional services: assurance, tax, consulting

Data Modeller - Medallion Architecture, Technology Hub

Data ManagementPosted on Nov 10
Full-timeSydney NSW, AustraliaNo salary listedIn-person

About the Job

Requirements

  • Experience designing event and API schemas using Avro, Protobuf, JSON Schema, and OpenAPI; using schema registries; and managing compatibility strategies.
  • Proficiency with data modelling tools such as ER/Studio, ERwin, or PowerDesigner, and schema/version management practices and tools such as Git, dbt, and Liquibase or Flyway.
  • Experience designing and optimizing data models for Medallion architectures.
  • Experience with master data management and reference data management, including golden-record design, identifiers, hierarchies, and integration patterns.
  • Experience with metadata and catalog tools and processes such as Collibra or Alation, lineage, and data documentation at scale.
  • Experience in data modelling across conceptual, logical, and physical layers, delivering enterprise-scale models across multiple domains such as HR, Finance, Marketing, Sales, and Risk.
  • Ability to establish and enforce modelling standards, naming conventions, and design patterns, and maintain the model repository, data dictionary, and metadata.
  • Knowledge of multiple modelling paradigms, including 3NF/normalized, dimensional/Kimball, Data Vault, and wide tables, and when to apply each.
  • Strong analytical and structured problem-solving skills, including the ability to translate between business and technical teams.
  • Ability to assess and prioritize AI opportunities based on value and feasibility, balancing ambition, risk, and delivery constraints.
  • Experience in process mapping, requirements definition, and stakeholder engagement, and ability to collaborate with senior stakeholders.
  • Clear communication skills for executive and delivery audiences, supported by formal education in business or related fields and foundational AI training.

Responsibilities

  • 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.
  • Work with and support the Senior Data Analyst to deliver high-quality data insights and reports.
  • Manage resources, set priorities, and drive the strategic direction of data initiatives within the organisation.

About the Company

PricewaterhouseCoopers (PwC)

Global professional services: assurance, tax, consulting

PwC provides assurance (audit), tax, legal services, consulting and deals advisory to organisations worldwide. It uses multidisciplinary teams across accounting, advisory, technology and industry, delivered through a global network of locally established firms that collaborate with technology partners to offer AI, cloud, managed services and digital trust. PwC differentiates itself with an integrated, global-local service model and technology-enabled offerings that address complex client needs across risk, transformation, reporting and sustainability. Its goal is to help clients improve governance, efficiency and value by supporting reporting accuracy, business transformation, risk management and sustainable practices.

Company size
10,001+
Company stage
Early VC
Total funding
$3.3M
Headquarters
London, United Kingdom
Founded
1989

Recently Posted Jobs

Explore more opportunities at PricewaterhouseCoopers (PwC)

See more jobs