Role description
Role Data Modeler Large Commercial Insurance
Location Remote
Primary Skills
Design and develop Logical Physical Data Models for Data Warehouse Data Mart layers in Snowflake
Experience in translating business requirements into logical and physical data model
Ability to perform data analysis on source data to come up with relevant models
Experience in developing SCD1SCD2SCD3 Dimension Data models and data warehouse
Define data entities attributes and relationships based on business requirements data sources and analytical needs
Map source data structures to target data models and schemas ensuring data consistency integrity and quality during the ingestion process
Strong experience working with Erwin Data Modeler for conceptual logical and physical models
Strong in Snowflake data warehousing concepts staging curated layers marts
Strong SQL skills with the ability to validate transformations and model outputs
Insurance Domain Expertise Underwriting Policy Administration Claims Reinsurance
Secondary Skills
Data Vault Modelling
Master Data Management MDM
Metadata Management Canonical Data Models
Data Governance Data Lineage Data Quality Frameworks
AWS Azure Cloud Platforms
Soft Skills
Communication Skills Ability to interact with business users architects analysts and developers to understand and clarify requirements
Analytical Thinking Ability to understand complex business processes and translate them into structured data models
Stakeholder Management Ability to collaborate effectively with business SMEs project teams and leadership across multiple functions
Attention to Detail Ensuring accuracy in data models relationships naming conventions and data definitions
ProblemSolving Skills Ability to identify data issues assess impacts of system changes and recommend effective solutions
Qualifying Questions
1Do you have Experience in building data model for data warehousing
2Do you have experince in building data models for insurance domain
3Do you have experince in data profiling
4Do you have experience working with Snowflake
