Job Summary:
HCLTech is looking for a highly talented and self-motivated Data Modeler with Snowflake expertise to design and implement enterprise-grade data models. The role involves defining standards, supporting Snowflake architecture, and optimizing data structures for performance and scalability.
Responsibilities:
• Design and implement enterprise-grade data models (logical & physical), define standards, support Snowflake architecture, and optimize data structures for performance and scalability.
• Conduct impact analysis and ensure model alignment with business needs.
• Engineered scalable ER models (Conceptual, Logical, Physical) for enterprise-grade data platforms.
• Designed high-performance Data Warehouse schemas (Star & Snowflake) for analytics optimization.
• Specialized in Dimensional Modeling (Kimball) and Data Vault 2.0 architecture.
• Developed optimized Fact & Dimension tables to support large-scale reporting and BI workloads.
• Leveraged Snowflake expertise for data modeling, clustering, and performance tuning.
• Utilized advanced SQL for complex transformations, validations, and query optimization.
• Partnered with ETL teams to architect efficient, scalable data pipelines.
• Ensured data integrity, governance, quality, and robust metadata management.
• Translated complex business requirements into scalable, future-ready data models.
• Built end-to-end Data Warehouse architecture (Staging → Core → Presentation/BI layers).
Qualifications:
Required:
• Experience 6 to 10 year Data Modeler with Snowflake experience
• Experience working on Development Projects with Snowflake
• Experience with Data Storing & Data Retrieving & Data Handling
• Must have experience retrieving data from table and migrating data to another source
• Must have Experience with SQL
• Must have Experience with ETL
• Must have Experience with Cloud AWS or Azure
• Primary Skills : Data Modeling, Snowflake, Advanced SQL, Data Warehousing, ER Modeling, ETL Concepts
• Secondary Skills: SAS (Data Analysis Understanding), Data Analysis, Performance Tuning, Data Governance, Cloud Data Platforms
Company:
HCLTech is a global IT company offering digital, engineering, and cloud solutions partnering with businesses for transformation. Founded in 1976, the company is headquartered in Noida, IND, with a team of 10001+ employees. The company is currently Late Stage.