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 tra