Job description
ERwin Data Modeler - 5+ years of experience.
Location: Onsite Riyadh (Saudi Arabia)
JD as follows:
- Design and maintain conceptual, logical, and physical data models using ERwin Data Modeler
- Develop OLTP and OLAP data models for enterprise data warehouses and applications
- Reverse-engineer and forward-engineer models across Oracle, SQL Server, Snowflake
- Define data definitions, relationships, and constraints to enforce data integrity
- Collaborate with ETL, BI, and application teams to align models with data flow and business logic
- Conduct data profiling, lineage, and impact analysis
- Maintain version control of models and ensure metadata consistency
- Document models, data dictionaries, and entity-relationship diagrams (ERDs)
- Integrate data models with CI/CD pipelines using tools like Git and DB-Deploy
- Optimize model performance for large-scale, distributed data environments