← Back to Jobs

Other

Lead Data Modeler

Globex IT Solutions INCCharlotte, NC🇺🇸United StatesPosted 3 Aug 2026

Quick Overview

Work Type

Hybrid

Level

Mid Senior

Job Description

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

Skills

SQL

AWS

ETL

Snowflake

EMR

Redshift

SAP

Vault

Similar jobs