Senior Data Modeler

4 days ago

New Delhi, India ALIQAN Technologies Full time

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.

  • Data Modeler/Senior Data Modeler

    4 weeks ago

    Delhi, Delhi, India INUMELLAS CONSULTANCY SERVICES PRIVATE LIMITED Full time

    Role - Data Modeler/Senior Data ModelerExp - 6 to 9 YrsLocations - Chennai, Hyderabad, Bengaluru, Delhi, PunePosition - PermanentCurious about the role? What your typical day would look like?As a Senior Data Engineer, you will work to solve some of the organizational data management problems that would enable them as a data-driven organization; Seamlessly...

  • Senior Data Modeler

    1 week ago

    Delhi, Delhi, India ALIQAN Technologies Full time ₹ 6,00,000 - ₹ 18,00,000 per year

    Job Title: Senior Data ModelerExperience Required: 6+ YearsLocation: RemoteEmployment 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...

  • Data Modeler

    2 weeks ago

    New Delhi, India Bechtel Full time

    **Requisition ID: 273200** - ** Relocation Authorized: National - Single**: - ** Telework Type: Part-Time Telework**: - ** Work Location: New Delhi** **Company Overview**: Since 1898, we have helped customers complete more than 25,000 projects in 160 countries on all seven continents that have created jobs, grown economies, improved the resiliency of the...

  • Waste Data Modeller

    7 days ago

    New Delhi, India Ricardo Energy & Environment Full time

    Overview: **Role: Waste Data Modeller** **Level : Consultant/Senior Consultant** **Location: New Delhi / Johannesburg** **Our vision is to create a safe and sustainable world** Ricardo plc is a global strategic, environmental, and engineering consulting company, listed on the London Stock Exchange. With over 100 years of engineering excellence and...

  • Senior MongoDB Developer/Data Modeler

    3 weeks ago

    Delhi, Delhi, India Vikgol Full time

    Job Title : Senior MongoDB Developer / Data Modeler (Remote)Experience Required : 5+ yearsJob Type : RemoteScope of Work : We are seeking a highly skilled Senior MongoDB Developer and Data Modeler to provide expert advisory support for a client transitioning their application backend to MongoDB. The ideal candidate will evaluate the suitability of MongoDB...

  • Data Modeler

    7 days ago

    Bengaluru, Chennai, New Delhi, India Evnek Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    We are seeking a highly experienced Data Modeler with expertise in Data Modelling, Data Analysis, and Dimensional ModellingThe ideal candidate should have hands-on experience with Erwin or Erwin Studio, Data Warehousing (DWH), Snowflake, and SQLThe role involves designing and developing data models to support business intelligence and analytics solutions...

  • Data Modeller

    7 days ago

    Bengaluru, Delhi, NCR, Pune, India Infogain Full time ₹ 8,00,000 - ₹ 12,00,000 per year

    Job Summary:We are looking for a Data Modeler to support our Data Engineering team in building and maintaining standardized data models and Single View of Customer models. The role involves preparing and visualizing data models, ensuring compliance with PACS DAWG standards, maintaining data dictionaries, and supporting NoSQL data modelling initiatives.Key...

  • Senior revit bim modeler

    3 weeks ago

    New Delhi, India Simsona CORP Full time

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

  • Senior REVIT BIM Modeler

    2 weeks ago

    New Delhi, India Simsona CORP Full time

    Company DescriptionWE ARE GLOBAL LEADER IN LEVERAGING BIM TECHNOLOGY Simsona 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...

  • Senior REVIT BIM Modeler

    3 weeks ago

    New Delhi, India Simsona CORP Full time

    Company Description WE ARE GLOBAL LEADER IN LEVERAGING BIM TECHNOLOGY Simsona 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...