Enterprise Data Modeler for Warehousing & Analytics

Synechron, Inc._USA Company; Charlotte (NC); On-site; USD 95,000 - 100,000; Full time

Benefits offered by this job

Paid leave

Parental leave

Insurance plan

Retirement plan

Education policy

Commuter benefits

Udemy for Business

Coaching

Challenging projects

Flat structure

Global culture

Job summary

Synechron is seeking an experienced Data Modeler to design, develop, and maintain enterprise data models for analytics and data warehouses. You will collaborate with business stakeholders, data architects, ETL developers, DBAs, and analytics teams to ensure scalable, compliant structures and robust data governance.

The role requires strong SQL, relational database knowledge, and hands-on use of Erwin/ER/Studio/PowerDesigner.

Qualifications

• Strong experience in Data Modeling and Data Architecture.

Responsibilities

• Design and develop conceptual, logical, and physical data models for enterprise applications and data warehouses.
• Analyze business requirements and translate them into effective data structures.
• Create and maintain data dictionaries, metadata, data lineage, and data governance documentation.
• Develop dimensional models including Star and Snowflake schemas for reporting and analytics.
• Collaborate with data architects, ETL developers, DBAs, and business teams.
• Perform data profiling, data quality assessments, and data validation.
• Optimize database performance through efficient data modeling techniques.
• Ensure compliance with data governance, security, and regulatory standards.
• Support data migration, integration, and modernization initiatives.
• Review and recommend improvements to existing data models and database designs.

Skills

Data Modeling

Data Architecture

SQL

ETL

Data Warehousing

Data Governance

Data Lineage

Cloud Platforms

Agile/Scrum

Communication

Tools

Erwin

ER/Studio

PowerDesigner

SQL Server

Snowflake

Oracle

PostgreSQL

Teradata

DB2

Job description

Synechron is seeking an experienced Data Modeler to design, develop, and maintain enterprise data models for analytics and data warehouses. You will collaborate with business stakeholders, data architects, ETL developers, DBAs, and analytics teams to ensure scalable, compliant structures and robust data governance.

The role requires strong SQL, relational database knowledge, and hands-on use of Erwin/ER/Studio/PowerDesigner.