Data Modeler Lead Consultant

Weekday; India; Remote; INR 1,500,000 - 2,700,000; Full time

Job summary

Weekday’s client is seeking an experienced Data Modeler – Lead Consultant to design, develop, and maintain enterprise-grade data models supporting financial reporting and analytics. The role emphasizes 3NF and dimensional modeling, data warehousing, and SQL, with an opportunity to lead modeling initiatives across large environments.

You will collaborate with stakeholders, data architects, and engineers to translate complex requirements into scalable data structures while upholding data

Qualifications

• 8+ years of experience in data modeling and data warehousing design.
• Hands-on experience with 3NF and dimensional modeling techniques.
• Strong SQL and performance-tuning skills in complex data environments.
• Excellent stakeholder management and communication abilities.

Responsibilities

• Design, develop, and maintain enterprise data models to support reporting, analytics, and data products.
• Lead design discussions, model reviews, and establish modeling standards.
• Collaborate with data engineers, ETL/ELT teams, and analytics for scalable solutions.
• Ensure data governance, quality, and metadata practices across domains.

Skills

3NF Modeling

Relational DB Design

Dimensional Modeling

Data Warehousing

SQL

Data Modeling

Stakeholder Communication

Tools

Snowflake

ERWin

ER/Studio

Databricks

Microsoft Fabric

SAP Data Environments

Job description

This role is for one of Weekday’s clients

Min Experience: 8+ years
Location: Remote (India), India
JobType: full-time

We are looking for an experienced Data Modeler – Lead Consultant to design, develop, and maintain enterprise-grade data models that support financial reporting, business analytics, and data-driven products. The ideal candidate will have strong expertise in Third Normal Form (3NF) Modeling, Dimensional Modeling, Data Warehousing, and SQL, along with experience in building scalable, reliable, and high-performance data architectures.

In this role, you will collaborate with business stakeholders, data architects, data engineers, analytics teams, and technology leaders to translate complex business requirements into robust data models. You will ensure data consistency, integrity, accessibility, and alignment with enterprise data governance standards. The candidate should bring strong analytical and problem-solving skills, a structured approach to data design, and the ability to lead data modeling initiatives across complex enterprise environments.

Key Responsibilities

• 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.

Must-Have Skills

• 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.

Good-to-Have 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.