Data Modeler Lead Consultant
This is the employer's own posting, not a copy on a job board.
What we know
Is it still open?
Confirmed still open
Last checked 2d ago — checked against the employer's own applicant tracking system, which is the company answering directly.
We re-read the employer's own applicant tracking system and the posting was still there. That is the company answering directly.
How old is it?
Posted 6d ago
The date the source published, not the day we noticed it (2026-10-27). Last seen at its source 3h ago.
We have tracked this listing since 27 Oct 2026 (6 days). The employer's own board has carried it every time we have read it, most recently 3 hours ago.
Is it remote?
Marked remote on the employer's board
Their board carries a remote setting on this posting — a field they filled in, not wording we read. The location field names somewhere specific, which is usually where the team or the entity sits.
Who may apply?
India
The description agrees: it names India.
What the ad says
…Location: Remote (India), India…
…Remote (…) India…
Skills named in the ad
Recognised terms only, from a fixed vocabulary — this is what CV matching compares against.
Carried by 1 source
-
Workable employer's own board first seen 6d ago · last seen 3h ago
The listing
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.
Requirements
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.