Data Modeler Lead Consultant

IndiaRemoteFull-timelead

Data ModelerData & AI

0 views0 saves0 applied

Apply Now

Quick Summary

Overview

This role is for one of Weekday’s clients Min Experience: 8+ yearsLocation: Remote (India), IndiaJobType: full-time We are looking for an experienced Data Modeler – Lead Consultant to design, develop,

Technical Tools

Data ModelerData & AI

Requirements

~1 min read

Responsibilities

~1 min read

→Design, develop, and maintain conceptual, logical, and physical data models to support enterprise applications, financial reporting, analytics, and data products.
→Apply 3NF Modeling principles to create normalized relational data structures that minimize redundancy and maintain data integrity.
→Develop dimensional data models, including star and snowflake schemas, facts, dimensions, and hierarchies, to support business intelligence and analytical reporting.
→Design and optimize data warehouse structures to enable efficient data integration, storage, transformation, and retrieval.
→Write, review, and optimize complex SQL queries to validate data models, troubleshoot data issues, and improve query performance.
→Collaborate with business stakeholders to understand functional requirements, reporting needs, and data relationships, translating them into effective modeling solutions.
→Establish and maintain data modeling standards, naming conventions, documentation, metadata, and best practices.
→Work closely with data engineering and ETL/ELT teams to ensure seamless implementation of data models across enterprise data platforms.
→Evaluate existing data architectures, identify gaps, and recommend improvements to scalability, performance, data quality, and maintainability.
→Support data governance, master data management, and data quality initiatives while ensuring consistency across business domains.
→Lead design discussions, conduct model reviews, and provide technical guidance to team members and stakeholders.

Strong hands-on experience in 3NF Modeling and relational database design.
Expertise in Dimensional Modeling, including star and snowflake schemas.
Solid understanding of Data Warehousing concepts, architecture, and implementation.
Proficiency in SQL, database structures, data relationships, and query optimization.
Experience translating complex business requirements into scalable enterprise data models.
Strong communication, stakeholder management, analytical, and problem-solving skills.

Experience with Snowflake and enterprise cloud data platforms.
Hands-on knowledge of ERWin and ER/Studio data modeling tools.
Familiarity with Databricks, Microsoft Fabric, and SAP data environments.
Understanding of ETL/ELT processes, data integration, metadata management, and data governance.