Sr Data Modeler-Location-Onsite @ Mc Lean , VA-Need Locals Only

Overview

On Site
Depends on Experience
Contract - W2
Contract - 12 Month(s)

Skills

Data Modeler
Data Modeling
Data Architect
sql
OLTP/OLAP
Star/Snowflake

Job Details

Title - Sr Data Modeler

Location-Onsite @ Mc Lean , VA-Need Locals Only

Duration Contract

Job Summary:

We are seeking an experienced Data Modeler to design, develop, and optimize data models that support business intelligence, data warehousing, and enterprise applications.

The ideal candidate will have a strong understanding of data modeling techniques, database design, and data governance principles, with proven experience translating business requirements into efficient and scalable data structures.

Key Responsibilities:

Design and implement conceptual, logical, and physical data models to support business and IT initiatives.

Work closely with business analysts, data architects, and developers to capture requirements and ensure models align with business needs.

Create and maintain data dictionaries, metadata, and data lineage documentation.

Ensure models are compliant with data governance, security, and regulatory standards.

Optimize models for performance, scalability, and maintainability.

Collaborate with ETL and BI teams to design efficient data flows and integrations.

Conduct data analysis, profiling, and validation to ensure data quality and integrity.

Support database design and schema changes in relational and cloud-based data platforms.

Recommend and implement best practices for data modeling and design patterns.

Participate in code reviews, design discussions, and solution architecture sessions.

Required Skills & Qualifications:

Bachelor s degree in Computer Science, Information Systems, Data Analytics, or related field.

10+ years of experience as a Data Modeler, Data Architect, or Database Designer.

Strong expertise in data modeling tools (e.g., ERwin, ER/Studio, IBM Data Architect, PowerDesigner).

Proficiency in SQL and hands-on experience with relational databases (Oracle, SQL Server, PostgreSQL, MySQL).

Knowledge of data warehousing concepts, OLTP/OLAP systems, and dimensional modeling (Star/Snowflake schema).

Familiarity with ETL design principles and collaboration with ETL developers.

Experience with cloud data platforms (Snowflake, AWS Redshift, Google Cloud Platform BigQuery, Azure Synapse) is a plus.

Understanding of master data management (MDM), metadata management, and data governance.

Strong analytical, problem-solving, and communication skills.

Preferred Qualifications:

Experience in Big Data technologies (Hadoop, Spark).

Knowledge of NoSQL databases (MongoDB, Cassandra, etc.).

Domain expertise in Banking, Financial Services, Healthcare, or Insurance.

Certification in data modeling, cloud data engineering, or related fields.

Regards,

Sai Srikar

Email:

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.