Data Modeler

We are seeking an experienced Data Modeler to support SQL Database Assessment and Modernization engagements. The candidate will be responsible for analyzing existing SQL Server database structures, evaluating data models, documenting data assets, and defining optimized future-state data models aligned with business, operational, reporting, analytics, and modernization objectives.

The ideal candidate should possess strong expertise in data modeling, database design, metadata management, data governance, and SQL Server environments.

________________________________________

Key Responsibilities

Current State Data Model Assessment

Conduct a detailed assessment of existing SQL Server data models.

Review:

o Database schemas

o Tables and relationships

o Primary and foreign key structures

o Data dependencies

o Referential integrity implementations

o Data storage patterns

Analyze data model effectiveness, scalability, and maintainability.

Data Discovery & Analysis

Inventory critical business entities and data domains.

Identify redundant, obsolete, and duplicate data structures.

Analyze data usage patterns across applications and reporting systems.

Review data lineage and data flow between source and target systems.

Support data quality assessment activities.

Data Modeling & Design

Develop and document:

o Conceptual Data Models

o Logical Data Models

o Physical Data Models

Create enterprise-aligned data structures supporting modernization initiatives.

Design normalized and denormalized data structures where appropriate.

Recommend improvements for performance, maintainability, and scalability.

Requirements Gathering

Collaborate with business stakeholders, architects, developers, DBAs, and application teams.

Understand current business processes and data requirements.

Translate business requirements into data models and design artifacts.

Support data architecture workshops and discovery sessions.

Data Quality & Governance Assessment

Assess data quality standards and governance controls.

Review:

o Data validation rules

o Business rules implementation

o Data ownership

o Data stewardship practices

Recommend governance improvements and standardization opportunities.

Metadata & Documentation

Develop comprehensive data dictionaries.

Document:

o Business definitions

o Data lineage

o Data ownership

o Data transformation rules

o Metadata repositories

Ensure assessment findings are properly documented.

Modernization Readiness Assessment

Identify opportunities to modernize data structures for:

o Cloud migration

o Data warehouse modernization

o Advanced analytics

o AI/ML readiness

Support Data Architects in defining future-state architecture and data strategies.

Provide inputs for migration planning and effort estimation.

________________________________________

Key Deliverables

Current State Data Model Assessment Report

Data Inventory & Entity Mapping

Conceptual Data Model

Logical Data Model

Physical Data Model

Data Dictionary

Data Lineage Documentation

Data Quality Assessment Report

Data Governance Assessment

Future-State Data Model Blueprint

Modernization Recommendations

________________________________________

Required Technical Skills

Data Modeling

Conceptual Data Modeling

Logical Data Modeling

Physical Data Modeling

Dimensional Modeling

Data Normalization & Denormalization

Entity Relationship Modeling (ER Modeling)

SQL & Database Knowledge

Microsoft SQL Server

SQL Querying

Stored Procedures

Database Schema Design

Relational Database Concepts

Data Analysis

Modeling Tools

ERwin Data Modeler

ER/Studio

PowerDesigner

Visio

Lucidchart

Data Modeling Best Practices

Data Governance & Metadata

Data Catalogs

Metadata Management

Data Lineage

Business Glossary

Data Governance Frameworks

Analytics & Reporting (Preferred)

Data Warehousing Concepts

Power BI

ETL/ELT Concepts

Azure Data Services

________________________________________

Soft Skills

Strong analytical and problem-solving skills.

Excellent stakeholder engagement and communication abilities.

Strong documentation and presentation skills.

Ability to facilitate workshops and requirement-gathering sessions.

Collaborative mindset with architects, DBAs, and engineering teams.