Description

Design and implement enterprise-grade logical and physical data models, define standards, and optimize data structures for performance and scalability within Snowflake.

This role is on-site.

Responsibilities

• Engineer scalable ER models (Conceptual, Logical, Physical) and Data Warehouse schemas (Star & Snowflake) for analytics optimization.
• Develop optimized Fact & Dimension tables using Dimensional Modelling (Kimball) and Data Vault 2.0 architecture.
• Leverage Snowflake expertise for data modelling, clustering, and performance tuning.
• Utilize advanced SQL for complex transformations, validations, and query optimization.
• Partner with ETL teams to architect efficient, scalable data pipelines and ensure data integrity and governance.

Required Skills

• 5+ years of experience in Data Warehousing and Data Modelling.
• Strong expertise in Snowflake and advanced SQL.
• Proven track record with Kimball methodology and Data Vault 2.0.
• Experience building end-to-end Data Warehouse architectures (Staging → Core → Presentation/BI layers).
• Ability to translate complex business requirements into scalable data models.
• Proficiency in data analysis and robust metadata management.
• Bachelor’s degree in a related field (Any Graduate).

Key Skills

Education

Any Gradute