Data Modeler

Senior erwin Data Modeler / Enterprise Data Modelling Consultant Job Location: Riyadh, Saudi Arabia Full Time Max Compensation: SAR20K/Month Design and maintain enterprise logical, conceptual, physical, and dimensional data models using erwin Data Modeler for large-scale data transformation programs. Build enterprise data models supporting cloud data platforms, data warehouses, data marts, analytics layers, and AI/ML-ready data ecosystems. Perform reverse engineering and forward engineering across databases such as Oracle, SQL Server, PostgreSQL, DB2, Teradata, Snowflake, BigQuery, Redshift, or Azure SQL . Create and optimize 3NF, Data Vault, star schema, snowflake schema, and dimensional models for enterprise reporting, BI, regulatory reporting, and advanced analytics use cases. Define and manage entities, attributes, relationships, keys, constraints, indexes, partitions, naming standards, domains, and reusable model components . Develop and maintain data dictionaries, metadata repositories, lineage mappings, subject areas, business glossaries, and model documentation within erwin. Support source-to-target mapping , data lineage, and impact analysis across legacy systems, ETL/ELT pipelines, cloud platforms, and downstream reporting applications. Work with data architects, cloud engineers, BI teams, and data governance teams to ensure models align with enterprise architecture, integration patterns, and data governance standards . Review and validate DDL scripts, schema migration scripts, data structures, database changes, and deployment artefacts generated from erwin models.

Optimize data models for performance, scalability, query efficiency, storage design, data quality, reusability, and enterprise integration readiness . Senior erwin Data Modeler / Enterprise Data Modelling Consultant Job Location: Riyadh, Saudi Arabia Full Time Max Compensation: SAR20K/Month