Lead Data Modeler – AWS Cloud

Job Title: Lead Data Modeler – AWS CloudLocation: Malvern, PA & Charlotte, NC Duration: Long TermKey ResponsibilitiesDesign enterprise-wide conceptual, logical, and physical data models.Develop dimensional models (Star Schema, Snowflake Schema, Data Vault).Define enterprise data standards and naming conventions.Partner with solution architects and data engineers.Model structured and semi-structured datasets.Optimize Redshift schemas for analytical performance.Design data lake and lakehouse data structures.Support ETL/ELT design and metadata management.Review and approve data models across projects.Mentor developers and modelers on best practices.Maintain enterprise metadata repositories and data lineage.Required SkillsData Modeling (Conceptual, Logical, Physical)ER ModelingStar SchemaSnowflake SchemaData Vault 2.0Normalization / DenormalizationSQLRedshift Schema DesignMetadata ManagementData GovernanceMaster Data Management (MDM)Data LineageAWS SkillsAmazon RedshiftAWS Glue Data CatalogAmazon S3Lake FormationAthenaGlue ETLIAMAWS DMSAmazon RDSEMR (preferred)Preferred Modeling ToolsERwinER/StudioSAP PowerDesignerLucidchartVisioQualificationsBachelor’s or Master’s degree in Computer Science or related field.10+ years of data modeling experience.5+ years designing cloud-native data platforms.Strong experience with enterprise data governance.Nice to HaveWealth Management or Banking domain knowledgeData Mesh or Lakehouse architectureAWS Certified Data Analytics – SpecialtyTOGAF or DAMA certification