Data Modeler

Role Data Modeler Large Commercial InsuranceLocation Remote Primary SkillsDesign and develop Logical Physical Data Models for Data Warehouse Data Mart layers in SnowflakeExperience in translating business requirements into logical and physical data modelAbility to perform data analysis on source data to come up with relevant modelsExperience in developing SCD1SCD2SCD3 Dimension Data models and data warehouseDefine data entities attributes and relationships based on business requirements data sources and analytical needsMap source data structures to target data models and schemas ensuring data consistency integrity and quality during the ingestion processStrong experience working with Erwin Data Modeler for conceptual logical and physical modelsStrong in Snowflake data warehousing concepts staging curated layers martsStrong SQL skills with the ability to validate transformations and model outputsInsurance Domain Expertise Underwriting Policy Administration Claims ReinsuranceSecondary SkillsData Vault ModellingMaster Data Management MDMMetadata Management Canonical Data ModelsData Governance Data Lineage Data Quality FrameworksAWS Azure Cloud PlatformsSoft SkillsCommunication Skills Ability to interact with business users architects analysts and developers to understand and clarify requirementsAnalytical Thinking Ability to understand complex business processes and translate them into structured data modelsStakeholder Management Ability to collaborate effectively with business SMEs project teams and leadership across multiple functionsAttention to Detail Ensuring accuracy in data models relationships naming conventions and data definitionsProblemSolving Skills Ability to identify data issues assess impacts of system changes and recommend effective solutionsQualifying Questions1Do you have Experience in building data model for data warehousing2Do you have experince in building data models for insurance domain3Do you have experince in data profiling4Do you have experience working with Snowflake