Job Descriptions
· 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)
Required Skills
Data Modeling, Snowflake, SQL (Advanced), SAS (data analysis understanding), ETL Concepts, Data Warehousing, ER Modeling