Senior Data Modeler
1 week ago
Job Title: Senior Data Modeler
Experience Required: 6+ Years
Location: Remote
Employment Type: Full-time / Contract (Remote)
Domain: Data Engineering / Analytics / Data Warehousing
---
Job Summary:
We are seeking an experienced and detail-oriented Data Modeler with a strong background in conceptual, logical, and physical data modeling. The ideal candidate will have in-depth knowledge of Snowflake architecture, data modeling best practices (Star/Snowflake schema), and advanced SQL scripting. You will be responsible for designing robust, scalable data models and working closely with data engineers, analysts, and business stakeholders.
---
Key Responsibilities:
1. Data Modeling:
Design Conceptual, Logical, and Physical Data Models.
Create and maintain Star and Snowflake Schemas for analytical reporting.
Perform Normalization and Denormalization based on performance and reporting requirements.
Work closely with business stakeholders to translate requirements into optimized data structures.
Maintain data model documentation and data dictionary.
2. Snowflake Expertise:
Design and implement Snowflake schemas with optimal partitioning and clustering strategies.
Perform performance tuning for complex queries and storage optimization.
Implement Time Travel, Streams, and Tasks for data recovery and pipeline automation.
Manage and secure data using Secure Views and Materialized Views.
Optimize usage of Virtual Warehouses and storage costs.
3. SQL & Scripting:
Write and maintain Advanced SQL queries including:
Common Table Expressions (CTEs)
Window Functions
Recursive queries
Build automation scripts for data loading, transformation, and validation.
Troubleshoot and optimize SQL queries for performance and accuracy.
Support data migration and integration projects.
---
Required Skills & Qualifications:
6+ years of experience in Data Modeling and Data Warehouse design.
Proven experience with Snowflake platform (min. 2 years).
Strong hands-on experience in Dimensional Modeling (Star/Snowflake schemas).
Expert in SQL and scripting for automation and performance optimization.
Familiarity with tools like Erwin, PowerDesigner, or similar data modeling tools.
Experience working in Agile/Scrum environments.
Strong analytical and problem-solving skills.
Excellent communication and stakeholder engagement skills.
---
Preferred Skills (Nice to Have):
Experience with ETL/ELT tools like dbt, Informatica, Talend, etc.
Exposure to Cloud Platforms like AWS, Azure, or GCP.
Familiarity with Data Governance and Data Quality frameworks.
-
Delhi, Delhi, India dentsu Full time ₹ 6,00,000 - ₹ 18,00,000 per yearAs a Senior Manager for data science, data modelling & Analytics, you will lead a team of data scientists and analysts while actively contributing to the development and implementation of advanced analytics solutions. This role requires a blend of strategic leadership and hands-on technical expertise to drive data-driven decision-making across the...
-
Senior Scientist Modelling
6 days ago
Delhi, Delhi, India Grow Indigo Full time ₹ 20,00,000 - ₹ 25,00,000 per yearJob Overview:Our organization is seeking a highly motivated and data-savvy Senior Scientist to join our modelling & quantification team. This role is a unique opportunity to contribute to groundbreaking research on quantifying carbon sequestration and greenhouse gas (GHG) emissions from agriculture, in the Indian contextDesired Qualification:• PhD...
-
Senior REVIT BIM Modeler
6 days ago
Delhi, Delhi, India Simsona CORP Full time ₹ 5,00,000 - ₹ 15,00,000 per yearCompany DescriptionWE ARE GLOBAL LEADER IN LEVERAGING BIM TECHNOLOGYSimsona BIM Services, use Building Information Modeling tools to create models, which display the complex forms in exteriors and interiors for any type of building. Our models also display the construction sequencing possibility, that helps our clients to visualize the project with...
-
Modelling & Data Analyst- India GDC (Gurugram)
2 weeks ago
Delhi, Delhi, India ERM Full time ₹ 12,00,000 - ₹ 36,00,000 per yearWho is ERM?ERM is a leading global sustainability consulting firm, committed for nearly 50 years to helping organizations navigate complex environmental, social, and governance (ESG) challenges. We bring together a diverse and inclusive community of experts across regions and disciplines, providing a truly multicultural environment that fosters...
-
Data Scientist
3 weeks ago
New Delhi, Delhi, India, Delhi Tatras Data Full timeJD- DATA SCIENTISTWork experience - For Juniors- 0-2 years, For Associates- 2-4 yearsQualification - Master’s/Bachelor’s in Computer science/Data science/Mathematics/Statisticsor related disciplines.Job Brief:In this role, you should be highly analytical with a knack for analysis, math and statistics.Critical thinking and problem solving skills are...
-
Senior Modeler
2 weeks ago
Delhi, Delhi, India Passive Infra Project Pvt Ltd Full time ₹ 5,00,000 - ₹ 7,00,000 per yearStructural Steel Modeler is accountable to create high quality deliverables and outputs on schedule, act independently to manage the assigned work and deliverables, work closely with project lead and project manager to plan project implementation. Indicative Responsibilities include:-Carefully study project documents - drawings, details, RFIs and addendums....
-
Senior Data Scientist
2 weeks ago
Delhi, Delhi, India ETS Full time ₹ 20,00,000 - ₹ 25,00,000 per yearAbout ETSETS is a global education and talent solutions organization enabling lifelong learners worldwide to be future-ready. For more than 75 years, we've been advancing the science of measurement to build benchmarks for fair and valid skill assessment across cultures and borders. Our worldwide impact extends through our renowned assessments including...
-
Senior Data Scientist
2 weeks ago
Delhi, Delhi, India Funding Societies | Modalku Group Full time ₹ 12,00,000 - ₹ 36,00,000 per yearFunding Societies | Modalku is the largest SME digital finance platform in Southeast Asia. We are licensed and operating in Singapore, Indonesia, Thailand, Malaysia and Vietnam, and backed by Sequoia India (Peak XV), Softbank Vision Fund, Khazanah and SMBC bank amongst many others. Funding Societies | Modalku provides business financing to small and...
-
Senior Data Engineer
1 week ago
Delhi, Delhi, India FOSS United Full timeAll JobsSenior Data Engineer at CivicDataLab Pvt LtdSenior Data EngineerApplyPosted on July 22, 2024 | Closed on November 19, 2024CivicDataLab Pvt LtdNew DelhiFull TImeJob DescriptionAt CivicDataLab, we are building robust and automated tools focusing on data analytics, encompassing data curation, data cleansing, data standardization, and sophisticated data...
-
Senior Manager Data Analytics
6 days ago
Delhi, Delhi, India noon Full time ₹ 12,00,000 - ₹ 36,00,000 per yearAbout noonnoon, the region's leading consumer commerce platform. On December 12th, 2017, noon launched its consumer platform in Saudi Arabia and the UAE, expanding to Egypt in February 2019. The noon ecosystem of services now includes marketplaces for food delivery, quick-commerce, fintech, and fashion. noon is a work in progress; we're six years in, but...