Data Modeler
Must-have:Data
Your tasks
- Design and implement data models within data lakehouse architectures, including Bronze, Silver, and Gold layers.
- Design data warehouse models using dimensional modeling (Star/Snowflake Schema) and apply SCD mechanisms.
- Design Apache Iceberg tables, including schema evolution, partitioning, and table maintenance.
- Build and maintain data models using data modeling tools such as erwin Data Modeler and ER/Studio.
- Work with Apache Parquet, object storage (MinIO), and Data Lakehouse storage architecture.
- Use SQL query engines such as Trino and Spark SQL to support data modeling work.
- Work with databases including Oracle, PostgreSQL, and MongoDB.
- Ensure data models comply with local data regulations, e-government requirements, and applicable data protection and privacy regulations.
Requirements
- 5 years or more in data modeling, data architecture, or related data engineering roles.
- 3 years or more of experience working on government or public sector projects in Saudi Arabia.
- A deep understanding of local data regulations, e-government requirements, and applicable data protection and privacy regulations.
- Experience using data modeling tools such as Erwin, ER/Studio, or similar tools.
- Experience designing and implementing data models within data lakehouse architectures, including Bronze, Silver, and Gold layers.
- Experience designing data warehouse models using dimensional modeling (Star/Snowflake Schema) and an understanding of SCD mechanisms.
- Good understanding of Apache Iceberg, including table design, schema evolution, partitioning, and table maintenance considerations.
- Knowledge of Apache Parquet, object storage, and Data Lakehouse storage architecture.
- Fluency in written and spoken Arabic and English is required
Skills & Tools
- Data Modeling Tools: such as erwin Data Modeler, ER/Studio
- SQL Query Engines: Trino, Spark SQL
- Data Storage & File Formats: MinIO, Apache Parquet
- Databases: Oracle, PostgreSQL, MongoDB