Job Description
Job Summary:
We are seeking an experienced Senior Data Modeler with strong expertise in Data Warehousing and Insurance domain (or Accord Data Model). The ideal candidate will be responsible for designing scalable data models, ensuring high-quality data structures, and supporting analytical and reporting needs in a Snowflake environment.
Key Responsibilities:
Design and develop logical and physical data models for Data Warehouse and Data Mart layers in Snowflake
Create and maintain Source-to-Target Mapping (STM) documents ensuring accurate data mapping across policy, claims, and financial domains
Define data entities, attributes, and relationships based on business requirements and analytical needs
Validate data transformation logic for downstream layers used by DBT pipelines and Power BI models
Perform data analysis and profiling, including handling complex structures like JSON/XML payloads
Ensure adherence to dimensional modeling techniques (SCD1, SCD2, SCD3, normalization/denormalization)
Collaborate with Data Engineers to design optimized data structures for Snowflake performance
Ensure data quality, consistency, and integrity across systems
Primary Skills & Qualifications:
10+ years of hands-on experience in Data Modeling (DWH)
Strong experience in Insurance domain OR Accord Data Model
Proven experience in data warehouse design and implementation
Expertise in Snowflake data warehousing concepts (staging, curated layers, marts)
Strong proficiency in SQL for data validation and transformation
Hands-on experience with Erwin Data Modeler (conceptual, logical, physical modeling)
Experience in translating business requirements into scalable data models
Strong understanding of data integration, validation, and cleansing techniques
Experience working in Agile environments
Secondary (Good-to-Have) Skills:
Insurance domain expertise in LOBs such as:
Workers Compensation (WC)
Commercial Multi Peril (CMP)
Excess & Surplus (ES)
Excess Casualty / Casualty
Soft Skills:
Strong analytical and problem-solving skills
Ability to interpret complex business logic and data structures
Excellent communication and documentation skills
Ability to work in fast-paced, multi-domain data programs
Preferred Tools & Technologies:
Snowflake
DBT
Power BI
Erwin Data Modeler
