DE&A - Core - Advanced Data Engineering - Data Modeling

We are seeking a Data Modeler to design and implement scalable, enterprise-grade data models for an insurance client building a modern cloud-based data platform. The role focuses on structuring data across Raw, Silver, and Gold layers to support batch and real-time ingestion, enable efficient reporting, and drive report rationalization initiatives.

The ideal candidate will have strong expertise in data modeling (conceptual, logical, physical) and experience working with Snowflake, DBT, and modern data pipelines (AWS Glue, Amazon Kinesis).

Key Responsibilities

Data Modeling & Architecture

• Design conceptual, logical, and physical data models aligned to business needs and insurance domain standards
• Define and implement models across medallion architecture (Raw, Silver, Gold layers)
• Create scalable and reusable data structures optimized for analytics and reporting

Data Transformation & Layer Design

• Collaborate with data engineering teams to implement models using DBT
• Design transformation logic to move data across Raw → Silver → Gold layers
• Ensure consistent data definitions, hierarchies, and business rules

Insurance Domain Data Structuring

• Model data for core insurance functions such as:
  • Policy
  • Claims
  • Billing
  • Customer / Party
• Align data models with industry standards and reporting requirements

Data Integration Alignment

• Work closely with engineers handling:
  • Batch ingestion via AWS Glue
  • Real-time streaming via Amazon Kinesis
• Ensure models support multi-source data ingestion and harmonization

Reporting & Rationalization Support

• Design optimized Gold layer datasets for reporting and self-service analytics (Power BI)
• Support report rationalization initiatives by standardizing and consolidating data models
• Enable consistent KPI definitions across reports

Data Quality & Governance

• Define data standards, naming conventions, and metadata structures
• Ensure data consistency, lineage, and traceability across layers
• Support governance, audit, and reconciliation requirements

Performance & Optimization

• Design models with a focus on query performance and scalability
• Work with engineering teams to optimize pipelines and data structures
• Apply best practices for partitioning, clustering, and efficient joins in Snowflake

Required Skills & Experience

Core Technical Skills

• Strong expertise in:
  • Data Modeling (Dimensional, 3NF, Data Vault – preferred)
  • Snowflake (schema design, performance considerations)
  • DBT (model structuring and transformation logic)
• Advanced proficiency in SQL
• Understanding of medallion architecture (Raw, Silver, Gold layers)

Data Platform & Integration

• Familiarity with:
  • AWS Glue (batch data pipelines)
  • Amazon Kinesis (real-time streaming)
• Experience designing models for multi-source integrated data platforms

Analytics & Reporting

• Understanding of data consumption patterns for reporting and analytics

Domain Expertise (Must)

• Strong understanding of Insurance domain data models (Policy, Claims, Billing, Underwriting)
• Exposure to enterprise data platforms in insurance organizations

Experience

• 5–10 years of experience in Data Modeling / Data Architecture
• Experience in cloud-based data platforms and modern data stack

Data Modeller

Data Modeller