We are seeking a highly skilled Data Modeling Specialist to play a key role in designing and maintaining high-quality data models that support our clients' data and analytics initiatives.
The ideal candidate combines strong technical expertise in data modeling with the ability to understand business processes and translate requirements into scalable, maintainable, and well-documented data structures.
You will work closely with data architects, data engineers, business analysts, and business stakeholders to define data requirements, establish modeling standards, and deliver conceptual, logical, and physical data models that enable reliable reporting, analytics, and operational processes.
Key Responsibilities :
- Collaborate with business stakeholders, data architects, analysts, and engineering teams to gather and analyze data requirements.
- Translate business requirements into conceptual, logical, and physical data models.
- Design and maintain robust data structures for both operational and analytical environments.
- Develop and maintain entity relationship diagrams (ERDs) and associated documentation.
- Apply data modeling best practices to ensure data consistency, integrity, scalability, and maintainability.
- Define entities, relationships, cardinalities, hierarchies, and business rules in accordance with business needs.
- Design dimensional models, including fact and dimension tables, to support reporting and analytical use cases.
- Ensure adherence to enterprise naming conventions, modeling standards, and metadata requirements.
- Work closely with ETL/ELT and data engineering teams to support the implementation of approved data models.
- Analyze existing data structures and recommend improvements or optimizations where necessary.
- Document data definitions, transformation logic, assumptions, and model decisions.
- Support data governance initiatives by contributing to metadata management and the identification of critical data elements.
- Participate in model reviews and validate that implemented solutions accurately reflect approved designs.
- Communicate complex data concepts effectively to both technical and non-technical stakeholders.
Required Qualifications :
- Bachelor's degree in Computer Science, Information Systems, Data Management, Engineering, or a related field.
- 4–5 years of hands-on experience in data modeling and database design.
- Strong expertise in creating conceptual, logical, and physical data models.
- Solid understanding of relational database concepts, including normalization and appropriate denormalization techniques.
- Proven experience designing dimensional models using star and snowflake schemas.
- Strong SQL skills with the ability to analyze and validate complex datasets.
- Hands-on experience with data modeling tools such as Erwin Data Modeler or PowerDesigner.
- Experience working with data warehouse initiatives and collaborating with ETL/ELT teams.
- Strong understanding of metadata management and documentation practices.
- Ability to identify and document business rules and translate them into effective data models.
- Excellent analytical, problem-solving, and communication skills.
- Ability to work effectively with cross-functional teams and stakeholders.
Preferred Qualifications :
- Experience working within regulated environments and familiarity with Saudi NDMO and NDI requirements.
- Exposure to data governance concepts, including business glossaries, critical data elements, and data quality principles.
- Familiarity with modern cloud data platforms such as Snowflake, Databricks, Microsoft Fabric, BigQuery, or similar technologies.
- Understanding of alternative modeling approaches such as Data Vault.
- Experience using repository-based modeling environments and version control practices.
What We Are Looking For:
We are looking for someone who is passionate about the discipline of data modeling and takes pride in producing clear, accurate, and scalable designs. The ideal candidate challenges assumptions, uncovers hidden business rules, asks the right questions, and delivers data models that provide a solid foundation for trusted data and analytics solutions.
Fluency in Arabic & English is highly desirable