Lead Consultant, Data Modeler

Job not on LinkedIn

🔥 1 hour ago

🇮🇳 India – Remote

⏰ Full Time

🟠 Senior

💼 Consultant

👻 Ghost score 25%

What it means: how likely this posting is sitting open without active hiring.How to read it: 60% or higher means we think this is a ghost. Lower scores are less of a worry.How we score it: age, reposts, open roles vs team size, how fast jobs close, and whether pay is listed.Fine print: an estimate from public data, not a judgment of the company. Real jobs can score high, so treat it as a hint, not a fact.

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Weekday (YC W21)

WebsiteLinkedInAll Job Openings

11 - 50 employees

Founded 2021

💼 Consulting

👥 HR Tech

☁️ SaaS

Consulting • HR Tech • SaaS

Weekday is a modern recruitment platform that combines AI technologies with a vast database of potential candidates, aiming to streamline the hiring process for companies in India. They offer various services, including a proactive outreach approach that helps employers connect with top talent, as well as tools for candidates to easily apply for jobs. Weekday's emphasis on candidate engagement through multiple channels, including email, WhatsApp, and phone calls, sets it apart in the competitive landscape of recruitment agencies.

📋 Description

• Design, develop, and maintain conceptual, logical, and physical data models for enterprise applications, financial reporting, analytics, and data products • Apply 3NF Modeling principles to create normalized relational data structures • Develop dimensional data models using star and snowflake schemas, facts, dimensions, and hierarchies • Design and optimize data warehouse structures for data integration, storage, transformation, and retrieval • Write, review, and optimize complex SQL queries • Collaborate with business stakeholders to translate functional requirements, reporting needs, and data relationships into modeling solutions • Establish data modeling standards, naming conventions, documentation, metadata, and best practices • Collaborate with data engineering and ETL/ELT teams to implement data models across enterprise data platforms • Evaluate data architectures and recommend improvements to scalability, performance, data quality, and maintainability • Support data governance, master data management, and data quality initiatives • Lead design discussions, conduct model reviews, and provide technical guidance

🎯 Requirements

• Minimum 8+ years of experience • 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 (good to have) • Hands-on knowledge of ERWin and ER/Studio data modeling tools (good to have) • Familiarity with Databricks, Microsoft Fabric, and SAP data environments (good to have) • Understanding of ETL/ELT processes, data integration, metadata management, and data governance (good to have)