Consultant Database Data Modeling Cloud Data Modeler -- W2

Job Title: Consultant Database Data Modeling – Cloud Data Modeler

Work Location: Richardson, TX 75081 (Onsite-Hybrid. Will consider candidates willing to relocate to client’s location)

Contract duration: 12 Months

Must Have Skills:

Data modelling and cloud working experience

Nice to Have Skills:

SQL

Detailed Job Description:

We are seeking an experienced Senior Data Modeler (8+ years) with strong expertise in enterprise data warehousing and cloud-based data platforms. The role involves designing and implementing scalable, high-performance data models to support analytics, reporting, and cloud modernization initiatives.

Key Responsibilities

Design and develop conceptual, logical, and physical data models for enterprise data warehouse and analytics platforms

Implement dimensional models (Star, Snowflake) and Data Vault models

Lead data modeling initiatives on cloud platforms (AWS, Azure, GCP)

Define source-to-target mappings and collaborate with ETL/ELT teams

Ensure data governance, lineage, and metadata standards

Optimize models for performance, scalability, and cost efficiency

Collaborate with business analysts, data engineers, DBAs, and governance teams

Support cloud migration and modernization programs

Drive data quality, validation, and governance frameworks

Required Skills & Experience

8+ years in data modeling, data warehousing, and analytics

Strong expertise in:

1. Dimensional modeling (Star & Snowflake)

2. Data Vault modeling

Experience with cloud platforms:

1. Snowflake (preferred)

2. AWS / Azure data services

Strong understanding of:

1. ETL/ELT processes

2. Data pipelines and transformations

Expertise in:

1. Advanced SQL

2. Database design & performance tuning

Experience with data governance, lineage, and metadata tools

Strong analytical and problem-solving skills

Preferred Skills

Experience with:

1. Cloud-native tools (AWS Glue, Azure Data Factory, Snowpipe)

2. Data cataloging / lineage tools

Understanding of modern architectures (Lakehouse, Data Mesh)

Exposure to Agile / Scrum

Domain experience: Retail, Healthcare, Banking

Soft Skills

Strong stakeholder management and communication

Ability to work in cross-functional and distributed teams

Experience in Agile environments

Minimum Years of Experience:

8+ years