Senior Data Modeler

Job Title: Senior Data Modeler
Work Location & Reporting Address: Richardson, TX 75081 (Onsite-Hybrid. Will consider candidates willing to relocate to client's location)

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

Interview Process (Is face to face required?)
Virtual