Lead Data Modeler – AWS Cloud
ARCHIVED
We can't find an active application page for this role right now. It may reopen or be listed elsewhere. Use Next Steps to search for an active apply link and similar live jobs.
Job Title: Lead Data Modeler – AWS Cloud
Location: Malvern, PA & Charlotte, NC Duration: Long TermKey Responsibilities
Design 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 Skills:
- Data Modeling (Conceptual, Logical, Physical)ER Modeling
- Star Schema
- Snowflake SchemaData Vault 2.0Normalization / DenormalizationSQLRedshift Schema Design
- Metadata Management
- Data Governance
- Master Data Management (MDM)
- Data LineageAWS SkillsAmazon RedshiftAWS Glue Data Catalog
- Amazon S3Lake Formation
- AthenaGlue ETLIAMAWS DMSAmazon RDSEMR (preferred)
- Preferred Modeling ToolsERwinER/StudioSAP Power
DesignerLucidchartVisioQualificationsBachelor’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 Have:
Wealth Management or Banking domain knowledge Data Mesh or Lakehouse architectureAWS Certified Data Analytics – SpecialtyTOGAF or DAMA certification