Senior Data Modeler Consultant
Job Fit Check
Base Career helps you apply smarter for this job.
Key skills for this role
About the Role
Devoteam International seeks a Senior Data Modeler Consultant to design and optimize enterprise data architecture in Riyadh. The role involves conceptual, logical, and physical modeling for OLTP, OLAP, and Data Lakehouse environments, ensuring data quality, performance, and governance.
Key Skills for This Role
Responsibilities
- Review current data models to understand the AS IS environment
- Design and maintain blueprints for TO BE data models for OLTP, OLAP, and Data Lakehouse environments
- Translate business processes into robust data requirements
- Design 3NF, Dimensional Models, and Data Vault 2.0
- Transform unstructured data into structured data and fix errors
- Optimize query performance through indexing, partitioning, and materialization
- Establish and enforce data governance best practices and naming standards
- Specify rules for data security and compliance
- Maintain data schemas using modern modeling tools and documentation
Requirements
- Experience in enterprise data architecture and modeling
- Expertise in relational, dimensional, and NoSQL databases
- Ability to translate business processes into data requirements
- Knowledge of data governance and security best practices
Full Job Posting
Introduction
- Design, implement, optimize enterprise data architecture and models using relational, dimensional, and NoSQL databases.
- Ensure data is structured for high performance, clarity, and long term scalability across operational and analytical systems.
- Data Modeler will be the translator between business stakeholders and data engineering teams.
Key Responsibilities
- 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, OLAP, and Enterprise Data Lakehouse environments.
- Business Alignment: Understand business processes and translate them into robust data requirements.
- Multi Paradigm Modeling: Designing 3NF, Dimensional Models (Kimball/Star Schema), and Data Vault 2.0.
- Data Quality: Transform unstructured data into structured data by fixing errors and eliminating redundancies.
- Performance Optimization: Optimize query performance through smart indexing, partitioning, and materialization strategies.
- Data Governance: Establish, enforce and implement best practices, data naming standards, and metadata management.
- Data Security: Specify rules and guidelines for ensuring data security and compliance.
- Tooling & Documentation: Maintain data schemas using modern standards modeling tools and ensure documentation is accessible.
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at Devoteam International
Cybersecurity GRC Consultant
Riyadh, KSA
Support the design and implementation of cybersecurity governance, risk, and compliance initiatives while ensuring alignment with Saudi regulations and best practices.
Business Architect
Riyadh, KSA
The Business Architect serves as the strategic link between business vision and enterprise execution. This role is responsible for developing, governing, and continuously enhanc...
Cybersecurity GRC Consultant
Riyadh, KSA
The Cybersecurity GRC Consultant supports the design, implementation, and continuous improvement of cybersecurity governance, risk, and compliance initiatives. The role contribu...
Smart City Application Architect
Riyadh, KSA
Devoteam International is seeking a Smart City Application Architect to lead the design and development of digital applications for smart city services. The role requires experience architecting enterprise and citizen-fa
PPP Business Modelling Consultant
Riyadh, KSA
Devoteam International is seeking a PPP Business Modelling Consultant to develop business, commercial, and investment models for Public-Private Partnership initiatives. The role requires strong analytical skills and expe
Smart City Solution Architect
Riyadh, KSA
Lead the architectural design of integrated smart city solutions that span across domains such as mobility, energy, environment, governance, and digital services. Translate busi...
Technology Architect
Riyadh, KSA
We are looking for a skilled Technology Architect to lead our initiatives in enterprise architecture, digital and cloud transformation, and technology consulting. As a pivotal p...
Oracle Fusion ERP Project Manager
Riyadh, KSA
Lead Oracle Fusion ERP implementation, manage project scope, budget, and risks, ensuring compliance and stakeholder engagement with strong ERP governance.
Cybersecurity GRC Consultant
Riyadh, KSA
Business Architect
Riyadh, KSA
Cybersecurity GRC Consultant
Riyadh, KSA
Smart City Application Architect
Riyadh, KSA
PPP Business Modelling Consultant
Riyadh, KSA
Smart City Solution Architect
Riyadh, KSA
Technology Architect
Riyadh, KSA
Oracle Fusion ERP Project Manager
Riyadh, KSA