Lead Data Modeler

Hybrid in Charlotte, NC, US • Posted 9 hours ago • Updated 9 hours ago
Contract W2
Contract Independent
No Travel Required
Hybrid
Depends on Experience
Fitment

Dice Job Match Score™

✨ Finding the perfect fit...

Job Details

Skills

  • data modeler
  • AWS

Summary

Job Title: Lead Data Modeler – AWS Cloud
Location: Malvern, PA & Charlotte, NC
Duration: Long Term
 
Key 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 Schema
  • Data Vault 2.0
  • Normalization / Denormalization
  • SQL
  • Redshift Schema Design
  • Metadata Management
  • Data Governance
  • Master Data Management (MDM)
  • Data Lineage
AWS Skills
  • Amazon Redshift
  • AWS Glue Data Catalog
  • Amazon S3
  • Lake Formation
  • Athena
  • Glue ETL
  • IAM
  • AWS DMS
  • Amazon RDS
  • EMR (preferred)
Preferred Modeling Tools
  • ERwin
  • ER/Studio
  • SAP PowerDesigner
  • Lucidchart
  • Visio
Qualifications
  • Bachelor’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 architecture
  • AWS Certified Data Analytics – Specialty
  • TOGAF or DAMA certification
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 91135097
  • Position Id: 9043591
  • Posted 9 hours ago
Contact the job poster
SV

Sai Vemulapalli

Recruiter @ Globex IT Solutions INC
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Hybrid in Charlotte, North Carolina

14d ago

Easy Apply

Contract

$60 - $65

Charlotte, North Carolina

Today

Easy Apply

Full-time

Depends on Experience

Charlotte, North Carolina

Today

Full-time

USD 160,000.00 - 192,500.00 per year

Remote

20d ago

Easy Apply

Contract

Depends on Experience

Search all similar jobs