Overview
Skills
Job Details
Job Title: Senior Data Modeler role
Location: Fort Mill ,SC or New York ,NY (2-3 Days Hybrid)
Duration : 12 Months
Sr 15+ years of Experience.
Data Modeller to support enterprise data initiatives across both Data Warehouse (DWH) and Operational Data Store (ODS) environments
Proven experience in designing and developing conceptual, logical, and physical data models for both Data Warehouse (DWH) and Operational Data Store (ODS) environment
Deep understanding of data warehousing concepts, including ETL processes, star/snowflake schemas, SCD (Slowly Changing Dimensions), aggregations, and historical data tracking
Strong grasp of Kimball (dimensional modeling) and Inmon (normalized modeling) methodologies; Data Vault modeling experience is a plus
Proficient with data modeling tools such as Erwin, ER/Studio, or IBM InfoSphere Data Architect to design models across databases like Snowflake, SQL Server, Oracle, and AWS Redshift
Strong problem-solving skills to analyze and resolve data issues, ensure data consistency, and support data governance and metadata management practices