Seeking a seasoned Data Modeler with extensive AWS data engineering expertise. This role focuses on architecting and maintaining enterprise data models crucial for analytics, reporting, and data integration. A deep understanding of data modeling principles, cloud data warehousing, metadata, and governance is essential.

Design and implement enterprise data models (Conceptual, Logical, Physical) supporting analytics and integration. Develop dimensional models including Star Schema, Snowflake Schema, Data Vault, and Hybrid approaches. Optimize scalable data models for Amazon Redshift and cloud analytics. Establish data standards, naming conventions, and metadata best practices. Analyze and profile data to understand source systems and business needs. Collaborate with architects on target-state data architecture. Design models for AWS platforms like Amazon Redshift and RDS. Maintain enterprise data dictionaries, business glossaries, and metadata repositories. Ensure adherence to data governance standards.

Minimum 8-12 years of experience in Data Modeling. Proficiency in designing Conceptual, Logical, and Physical Data Models. Experience with Star Schema, Snowflake Schema, Data Vault, and Hybrid Modeling. Skilled in creating scalable models for Amazon Redshift. Experience defining data standards, metadata, and best practices. Ability to perform data analysis and profiling. Experience with data modeling for AWS-based platforms (Amazon Redshift, Amazon RDS). Mandatory hands-on experience with Erwin Data Modeler. Familiarity with metadata repositories and lineage documentation.