Data Modeler - OLTP / OLAP System

Job Description :

Key Responsibilities :

• Design and maintain enterprise-level data models (conceptual, logical, physical).
• Work extensively with Snowflake (clustering, partitioning, schema design).
• Support data warehousing (OLAP / OLTP), ETL / ELT pipelines, and performance tuning.
• Collaborate with cross-functional teams to deliver high-quality, scalable data solutions.
• Optimize SQL queries and database structures for efficient data processing.
• Ensure compliance with data governance and architectural best practices.
• Leverage Azure Data Factory, Synapse, and Databricks for data integration and analytics.
• Use enterprise modeling tools such as Erwin, PowerDesigner, or Skills & Experience :
• 10+ years of experience in Enterprise Data Architecture & Data Modelling.
• Proven expertise in OLAP / OLTP systems, data warehousing, ETL / ELT design.
• Advanced knowledge of Snowflake architecture and performance optimization.
• Strong experience with Azure Data Factory, Synapse, and Databricks.
• Hands-on experience with Enterprise Modelling tools (Erwin, PowerDesigner, Infosphere).
• Excellent SQL optimization skills and strong communication to Have :
• Domain experience in Asset Management / Security Servicing.
• Knowledge of Master Data Management (MDM) and Data Vault.
• Programming experience in Python or R

(ref : hirist.tech)