Senior Data Modeler: Data Warehousing & Governance

Synechron; Charlotte, Northern (NC, KY); Hybrid; USD 95,000 - 100,000; Full time

Benefits offered by this job

Medical Insurance

Dental Insurance

Vision Insurance

Retirement Plan

Paid Leave

Job summary

Synechron seeks an experienced Data Modeler in Charlotte, NC to design, develop and maintain enterprise data models for data warehouses. You will work with data architects, ETL teams and analytics to ensure scalable structures aligned with business needs.

Responsibilities include building dimensional models, data dictionaries, lineage and governance artifacts, plus profiling and quality assessments to optimize performance.

Qualifications

• Strong experience in Data Modeling and Data Architecture.
• Hands-on with Erwin, ER/Studio or PowerDesigner.
• Expertise in SQL and relational databases.
• Experience with data warehousing, ETL and dimensional modeling.
• Knowledge of data governance and metadata management.
• Experience with cloud platforms such as AWS, Azure or GCP.

Responsibilities

• Design data models for enterprise applications and data warehouses.
• Translate business requirements into effective data structures.
• Create and maintain data dictionaries, metadata, lineage, and governance docs.
• Develop dimensional models including Star and Snowflake schemas.
• Collaborate with data architects, ETL developers, DBAs, and business teams.
• Perform data profiling, quality assessments, and validation.
• Optimize database performance through efficient data modeling.
• Support data migration, integration and modernization efforts.
• Review and improve existing data models and database designs.

Skills

Data Modeling

Data Architecture

SQL

Data Warehousing

ETL

Metadata Management

Tools

Erwin

ER/Studio

PowerDesigner

Snowflake

Oracle

Job description

Synechron seeks an experienced Data Modeler in Charlotte, NC to design, develop and maintain enterprise data models for data warehouses. You will work with data architects, ETL teams and analytics to ensure scalable structures aligned with business needs.

Responsibilities include building dimensional models, data dictionaries, lineage and governance artifacts, plus profiling and quality assessments to optimize performance.