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