Data Modeller

SUMMARY OF RESPONSIBILITIES

Here at MetLife Australia, we are seeking an experienced Data Modeler/Solution Designer to join our team and help on our building data platform solution (known as the Data Exchange or DAX).

design, build data models, and oversee implementation of data pipelines

data modeling principles

KEY RESPONSIBILITIES

DATA SOLUTION DESIGN

Core Deliverables:

• Develop and deliver Conceptual/Logical/Physical data models
• Develop data mappings and transformation rules document
• Develop business glossaries (metadata) and relevant data model documentation (data dictionaries) for data and analytics solutions.

Responsibilities:

• Work with business SMEs and data stewards to align data models according to business process.
• Ensure data architecture and data management principles are followed during development of new data models.
• Build data modelling standards, naming conventions and follow them during implementation.
• Work with data stewards, data management specialists to ensure metadata, data quality rules are implemented accurately.
• Integrate data from

  various source systems

  (e.g., databases, APIs, flat files) into Snowflake.
• Review and support the whole SDLC till go-live and post-production issues. This includes reviewing technical mapping documents, test cases, test plans and execution. Includes scheduling seamless deployment to go live.

TECHNICAL TROUBLESHOOTING AND OPTIMISATION

• Ability to

  conduct workshops

  with business SMEs and data stewards to understand the business processes.
• Data Profiling and analysis to establish strong hold on data.
• Conduct

  root cause analysis

  and recommend long-term fixes for recurring issues
• Conduct impact assessment for any upstream / downstream changes.

DevOps and Operations

• Collaborate with Data Engineers and Tech BA, ensuring proper

  version control (Git, Bitbucket)

  and

  deployment best practices

  for data models.
• Ensure compliance with

  data governance, security.

QUALIFICATIONS

• Bachelor’s degree in computer science or equivalent with demonstrated experience in delivery of data model and design for Data and analytics project delivery.
• Core SnowPro Certificate is highly desired

EXPERIENCE AND SKILLS

• 8+ years

  of experience as a Data Engineer/Data Modeler, preferably in a

  cloud-based environment

  .
• Strong experience with data modelling and data warehouse and data integration.
• Deep understanding of

  Snowflake

  , including performance optimization and best practices.
• Strong

  SQL

  skill is mandatory
• Solid understanding of

  data modeling concepts

  to build effective pipelines.
• Familiarity with

  DevOps workflows

  and working in environments with

  CI/CD, version control (Git, Bitbucket), and automated deployments

  .
• Strong problem-solving skills and the ability to troubleshoot pipeline issues effectively.

KNOWLEDGE

• Knowledge of data management / governance principles and their importance to dealing with data risk (for MetLife and relationship with regulators).
• Life Insurance or Banking experience including knowledge of financial / actuarial valuation methods and processes (preferred).