Key skills
CloudERPOracleSQLData EngineeringData LakeAnalyticsSnowflakeSQL Server
About this role
Role Overview
- Area(s) of responsibility JD for the Lead Data Modeler with Snowflake:
- Collaborate with Database administrator and Data Engineers to translate data models into physical database structures, ensuring optimal performance and data integrity.
- Define and enforce data models standard, naming conventions, and best practices to maintain data consistency and quality.
- Experience designing Data Marts and Data Warehouses on Enterprise Scale.
- Demonstrate capabilities in designing and creating data models including Conceptual, Logical and Physical models, as per the requirements.
Requirements
- Min 17+ years of overall experience in data engineering, data modeling, analytics engineering, or related roles, with minimum 8-10 years being Data Modeler or Data Architect.
- Expertise in data modeling, including dimensional modeling, fact table design, conformed dimensions, and Slowly Changing Dimensions (SCD Type 1 and Type 2).
- Demonstrate capabilities in designing and creating data models including Conceptual, Logical and Physical models, as per the requirements.
- Experience in ERWIN, SQL Database Modeler (SQL DBM) or ER/Studio as modeling tool is required, with additional Model Mart management experience preferred (client is using SQL DBM).
- Knowledge in both OLTP and OLAP Modelling.
- Solid understanding of modern data lake and medallion architecture, including bronze, silver, and gold layers.
- Very good hands-on knowledge/experience with complex SQL queries.
- Experience designing Data Marts and Data Warehouses on Enterprise Scale.
- Collaborate with Database administrator and Data Engineers to translate data models into physical database structures, ensuring optimal performance and data integrity.
- Define and enforce data models standard, naming conventions, and best practices to maintain data consistency and quality.
- Data modeling ERP domain experience in at least one platform, such as Oracle EBS, JDE, or Oracle Cloud ERP.
- Experience in Snowflake Data Cloud, including virtual warehouses, roles and security, stages and file formats, tasks and streams, and features such as Time Travel and Fail-safe.
- Additional experience in Oracle and SQL Server Databases preferred.
Tech Stack
- Cloud
- ERP
- Oracle
- SQL