Senior Data Modeler Consultant

Senior Data Modeler Consultant – Devoteam – الرياض, S01, SA

Position type:
Full‑time, on‑site.

Design, implement, and optimize enterprise data architecture and models that represent complex data using relational, dimensional, and No

SQL databases. Ensure data is structured for high performance, clarity, and long‑term scalability across operational and analytical systems. The Data Modeler serves as the translator between business stakeholders and data engineering teams.

• Assessment – Review current data models to understand the AS‑IS environment.
• Conceptual, Logical, and Physical Modeling – Plan, design, and maintain blueprints of the TO‑BE data models for OLTP (operational), OLAP (analytical), and Enterprise Data Lakehouse environments, including how data will be stored, managed, and used.
• Business Alignment – Understand business processes, translate them into robust data requirements, and review existing report designs to identify where data model structures can address business requirements.
• Multi‑Paradigm Modeling – Design 3NF for transactional databases, dimensional models (Kimball/Star Schema) for data warehousing, and Data Vault 2.0 for scalable enterprise data lakes.
• Data Quality – Transform unstructured data into structured data by fixing errors, eliminating redundancies, and removing unnecessary data to optimize data systems.
• Performance Optimization – Improve query performance through intelligent indexing, partitioning, and materialization strategies.
• Data Governance – Establish, enforce, and implement best practices, data naming standards, definitions, and maintain data maps and relevant diagrams for metadata management.
• Data Security – Specify rules and guidelines for ensuring data security and compliance, and define procedures for classifying data according to sensitivity.
• Tooling & Documentation – Maintain data schemas with modern standards‑based modeling tools and ensure documentation is accessible to both technical and non‑technical users.

B.Sc. degree with at least 5+ years of dedicated data modeling experience in enterprise relational and columnar databases.

SQL proficiency – Write, read, and optimize complex transactional and analytical queries.

Modern Data Stack familiarity – Experience modeling for cloud data warehouses/lake houses such as SQL Server, Hadoop, Snowflake, Big Query, Databricks; work with transformation tools like dbt; create ERDs for relational systems and dimensional diagrams.

Tooling proficiency – ER/Studio, Erwin, or similar data modeling software.

No

SQL/Unstructured data knowledge – Understand how to model semi‑structured data (JSON, Parquet) and No

SQL databases (MongoDB, Cassandra) alongside relational data.

Physical data management – Assess current storage constraints and define TO‑BE requirements with growth planning.

Data integration – Familiar with ETL tools to define transformation rules and prepare data for big data analytics.

Soft skills – Communication and presentation skills; ability to lead or mentor a team; strong business orientation.

• W3
  
  Schools SQL Certification
• DAMA‑CDMP Certification
• Microsoft Azure Data Engineer Associate

Business Unit: DAIC. Level: Mid‑senior.