Senior Data Modeler
Sagar ReddyRemoteSENIORPosted 5d ago
Enterprise Data ModelingNorth Star Data ModelingConceptual Data ModelingLogical Data ModelingPhysical Data ModelingSnowflake Data WarehouseSQLSource-to-Target MappingTransformation RulesDimensional ModelingStar SchemasSnowflake SchemasFact TablesDimension TablesSCDNormalizationSemantic LayerOntologyContext LayerPower BISigmaAIGenAI
About the Role
We are looking for a Senior Data Modeler to join our team and work on enterprise-level data modeling and modern data analytics initiatives.
Key Responsibilities
• Design and implement enterprise-level data models
• Work on conceptual, logical, and physical data modeling
• Utilize Snowflake Data Warehouse for data storage and processing
• Apply strong SQL skills including joins, CTEs, window functions, and aggregations
• Develop source-to-target mapping and transformation rules
• Implement dimensional modeling using star and snowflake schemas
• Manage fact and dimension tables, SCD, and normalization
• Understand and work with semantic layer, ontology, and context layer
Requirements
• 8–12 years of experience in data modeling
• Strong hands-on experience in enterprise data modeling and data warehousing
• Proficiency in SQL, including joins, CTEs, window functions, and aggregations
• Experience with Snowflake Data Warehouse
• Knowledge of source-to-target mapping and transformation rules
• Understanding of dimensional modeling, star and snowflake schemas
• Experience with fact and dimension tables, SCD, and normalization
• Familiarity with semantic layer, ontology, and context layer
Benefits
• Opportunity to work on enterprise-level data modeling and modern data analytics initiatives
• Remote work environment