Senior Data Modeler
"Senior Data Modeler
• Analyze and assess existing enterprise data models, SSIS EDW schemas, and source system structures.
• Develop conceptual, logical, and physical data models for assigned business domains.
• Identify reusable entities, attributes, relationships, business keys, and reference data.
• Perform fit-gap analysis between the existing EDW models and target enterprise data model.
• Define and document business entities, relationships, cardinality, hierarchies, and conformed dimensions.
• Create and maintain ER diagrams, data dictionaries, metadata, and business glossary documentation.
• Collaborate with Enterprise Architects, Lead Data Modelers, Business Analysts, and Data Engineers to align data models with business requirements and target architecture.
• Support cross-domain integration by identifying shared entities and enterprise-wide relationships.
• Review source-to-target mappings and validate alignment between Bronze, Silver, and Gold data structures.
• Participate in design reviews, incorporate feedback, and maintain version-controlled data models.
• Ensure adherence to enterprise data modeling standards, naming conventions, and governance guidelines.
• Support testing activities by validating data structures, business rules, and model consistency.
Mandatory Skill - Enterprise Data Modeling, Conceptual/Logical/Physical Data Modeling, ERwin/ER Studio (or equivalent), SQL, Relational Database Design, Dimensional Modeling (Star Schema/Snowflake), Data Warehousing, Data Dictionary and Metadata Management.
Preferred Skills - AWS Databricks, Delta Lake, Data Vault, Insurance/P&C domain, Azure DevOps/Jira, Data Governance, Unity Catalog."
"Senior Data Modeler
• Analyze and assess existing enterprise data models, SSIS EDW schemas, and source system structures.
• Develop conceptual, logical, and physical data models for assigned business domains.
• Identify reusable entities, attributes, relationships, business keys, and reference data.
• Perform fit-gap analysis between the existing EDW models and target enterprise data model.
• Define and document business entities, relationships, cardinality, hierarchies, and conformed dimensions.
• Create and maintain ER diagrams, data dictionaries, metadata, and business glossary documentation.
• Collaborate with Enterprise Architects, Lead Data Modelers, Business Analysts, and Data Engineers to align data models with business requirements and target architecture.
• Support cross-domain integration by identifying shared entities and enterprise-wide relationships.
• Review source-to-target mappings and validate alignment between Bronze, Silver, and Gold data structures.
• Participate in design reviews, incorporate feedback, and maintain version-controlled data models.
• Ensure adherence to enterprise data modeling standards, naming conventions, and governance guidelines.
• Support testing activities by validating data structures, business rules, and model consistency.
Mandatory Skill - Enterprise Data Modeling, Conceptual/Logical/Physical Data Modeling, ERwin/ER Studio (or equivalent), SQL, Relational Database Design, Dimensional Modeling (Star Schema/Snowflake), Data Warehousing, Data Dictionary and Metadata Management.
Preferred Skills - AWS Databricks, Delta Lake, Data Vault, Insurance/P&C domain, Azure DevOps/Jira, Data Governance, Unity Catalog."