Senior Data Modeler

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:

• 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