Data Modeler - OLTP/OLAP System

Job Description :

Key Responsibilities :

- 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 Infosphere.

Required Skills & Experience :

- 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 abilities.

Nice to Have :

- Knowledge of Master Data Management (MDM) and Data Vault.

- Programming experience in Python or R