Lead Data Modeler – AWS Cloud

Hybrid in Malvern, PA, US • Posted 9 hours ago • Updated 9 hours ago
Contract W2
12 Years
No Travel Required
Hybrid
Depends on Experience
Fitment

Dice Job Match Score™

🎯 Assessing qualifications...

Job Details

Skills

  • 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: 9037487
  • 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

Wilmington, Delaware

Today

Full-time

USD 118,750.00 - 190,000.00 per year

Berkeley Heights, New Jersey

19d ago

Easy Apply

Contract

$40 - $60

Remote

Today

Full-time

USD 114,000.00 - 167,000.00 per year

Hybrid in Newark, New Jersey

27d ago

Easy Apply

Full-time

Depends on Experience

Search all similar jobs