Senior Data Modeler

4 weeks 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.

  • Senior Data Modeler

    5 days ago

    New Delhi, India Tata Consultancy Services Full time

    Role: Senior Data Modeler Location: Kolkata Experience: 8 Plus Years Role**Senior Data Modeler Required Technical Skill Set**Kimball, Inmon, Data Vault and Dimensional Modelling Desired Competencies (Technical/Behavioral Competency) Must-Have**Data Modelling Expertise Proficient in designing conceptual, logical and physical data models Skilled in...

  • Senior Data Modeler

    1 week ago

    New Delhi, India Tata Consultancy Services Full time

    Role: Senior Data ModelerLocation: KolkataExperience: 8 Plus YearsRole**Senior Data ModelerRequired Technical Skill Set**Kimball, Inmon, Data Vault and Dimensional ModellingDesired Competencies (Technical/Behavioral Competency)Must-Have**- Data Modelling Expertise - Proficient in designing conceptual, logical and physical data models - Skilled in...

  • Senior Data Modeler

    1 week ago

    New Delhi, India Philodesign Technologies Inc Full time

    Position: Senior Data ModelerExperience: 7+ YearsShift: General ShiftLocation: RemoteRole OverviewWe are seeking an experienced Senior Data Modeler to design, develop, and maintain conceptual, logical, and physical data models that support business and analytical requirements. The ideal candidate will translate complex business needs into efficient and...

  • Senior Data Modeler

    1 week ago

    New Delhi, India Info Services Full time

    Title: Senior Data Modeler Location: Financial District, Hyderabad or Navalur, Chennai Mode: Full TimeRole Overview We are seeking an experiencedData Modelerto design, develop, document, and manage logical and physical data models supporting Oracle databases, data warehouse environments, and BI reporting tools such as MicroStrategy and Business Objects. The...

  • Senior Data Modeler

    2 weeks ago

    New Delhi, India Neutrino Advisory, an Inc 5000 Company Full time

    Role Overview:We are seeking a Senior Data Modeler with over 12 years of IT experience, including 8–10 years in data modeling and database design. The role involves designing and optimizing data models across transactional, analytical, and cloud environments using platforms such as SQL Server, Oracle, Snowflake, and Azure Synapse. The ideal candidate will...

  • Senior Data Scientist

    5 days ago

    New Delhi, India Crayon Data Full time

    Role: Sr Data ScientistExperience level: 5 to 7 yearsLocation: ChennaiWhy Crayon? Why now?Crayon is transforming into an AI first company, and every Crayon (that’s what we call ourselves!) is undergoing a journey of upskilling and expanding their capabilities in the AI space.We're building an organization where AI is not a department—it’s a way of...

  • Data Modeler

    1 week ago

    New Delhi, India Tata Consultancy Services Full time

    TCS has been a great pioneer in feeding the fire of Young techies like you. We are global leaders in the technology arena and there's nothing that can stop us from growing together.TCS Hiring for skill " Senior Data Modeler ".Role:Senior Data Modeler Required Technical Skill Set:Kimball, Inmon, Data Vault and Dimensional Modelling Experience:8-10 years Work...

  • Data Modeler

    7 days ago

    New Delhi, India Tata Consultancy Services Full time

    Job Title: Senior Data ModelerExp Range: 8- 14 yearsJob Location: Kolkata OnlyJob Description:Required skill: Kimball, Inmon, Data Vault and Dimensional ModellingData Modelling Expertiseo Proficient in designing conceptual, logical and physical data modelso Skilled in methodologies such as Kimball, Inmon, Data Vault and Dimensional Modellingo Experience with...

  • Data Modeler

    5 days ago

    New Delhi, India Optimum Solutions Pte Ltd Full time

    Role: Senior/Lead Data ModellerExperience: 6+ YrsLocation: PuneNotice Period: Immediate to 15 days onlyInterview: Virtual discussionMode: Hybrid – 4 days a weekAbout the RoleWe are looking for an experienced Data Modeler to join our data engineering team for a leading banking project. The ideal candidate will have hands-on experience in data modeling using...

  • Senior Data Modeler

    1 week ago

    Delhi, India Philodesign Technologies Inc Full time

    Position: Senior Data ModelerExperience: 7+ YearsShift: General ShiftLocation: RemoteRole OverviewWe are seeking an experienced Senior Data Modeler to design, develop, and maintain conceptual, logical, and physical data models that support business and analytical requirements. The ideal candidate will translate complex business needs into efficient and...