Senior Data Modeler Consultant
Job Fit Check
Base Career helps you apply smarter for this job.
Key skills for this role
About the Role
Design, implement, and optimize enterprise data architecture and models for complex data using relational, dimensional, and NoSQL databases.
Key Skills for This Role
Responsibilities
- Review current data models to understand the AS IS environment
- Plan, design and maintain blueprints of the TO BE data models for OLTP, OLAP, and Enterprise Data Lakehouse environments
- Understand business processes and translate them into robust data requirements
- Design 3NF for transactional databases, Dimensional Models for data warehousing, and Data Vault 2.0 for scalable enterprise data lakes
- Transform unstructured data into structured data by fixing errors, eliminating redundancies and unnecessary data
- Optimize query performance through smart indexing, partitioning, and materialization strategies
- Establish, enforce and implement best practices, data naming standards, data definitions, maintain data maps and relevant diagrams
- Specify rules and guidelines for ensuring data security and compliance
- Maintain data schemas using modern standards modeling tools and ensure documentation is accessible
Requirements
- B.Sc. Degree
- Minimum of 5+ years of dedicated data modeling experience in enterprise relational databases, columnar databases
Full Job Posting
Summary Introduction
- Design, implement, optimize enterprise data architecture and models that represent complex data using relational, dimensional, and NoSQL databases.
- Ensure data is structured for high performance, clarity, and long term scalability across both 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 (operational), OLAP (analytical), and Enterprise Data Lakehouse environments.
- Business Alignment Understand business processes and translate them into robust data requirements.
- Multi Paradigm Modeling Designing 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, eliminate redundancies and unnecessary data.
- Performance Optimization Optimize query performance through smart indexing, partitioning, and materialization strategies.
- Data Governance Establish, enforce and implement best practices, data naming standards, data definitions, maintain data maps and relevant diagrams.
- 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.
Qualifications
- B.Sc. Degree with a minimum of 5+ years of dedicated data modeling experience in enterprise relational databases, columnar databases.
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
Cybersecurity GRC Consultant
Riyadh, KSA
Devoteam seeks a Cybersecurity GRC Consultant to support governance, risk, and compliance initiatives. The role involves developing frameworks, policies, and regulatory compliance activities aligned with Saudi regulation
Cybersecurity GRC Consultant
Riyadh, KSA
Devoteam seeks a Cybersecurity GRC Consultant to support governance, risk, and compliance initiatives. The role involves developing frameworks, policies, and regulatory compliance activities aligned with Saudi regulation
Cybersecurity GRC Consultant
Riyadh, KSA
Devoteam is seeking a Cybersecurity GRC Consultant in Riyadh to support governance, risk, and compliance initiatives. The role involves developing frameworks, policies, and ensuring alignment with Saudi regulations. Cand
Business Architect
Riyadh, KSA
Devoteam seeks a Business Architect to serve as the strategic link between business vision and enterprise execution. The role involves developing and governing business architecture, conducting gap analysis, and enabling
Technology Architect
Riyadh, KSA
Devoteam is looking for a Technology Architect to lead enterprise architecture, digital and cloud transformation initiatives in Riyadh. Requires a Bachelor's/Master's in CS/IT, proven experience as a Technology Architect
Smart City Solution Architect
Riyadh, KSA
Devoteam is seeking a visionary Smart City Solution Architect to design integrated smart city solutions across mobility, energy, environment, governance, and digital services. The role requires 8+ years in ICT architectu
Smart City Application Architect
Riyadh, KSA
Devoteam seeks a Smart City Application Architect to lead the design and development of digital applications for smart city services. The role requires 8+ years in software development and application architecture, with
PPP Business Modelling Consultant
Riyadh, KSA
Devoteam is seeking a PPP Business Modelling Consultant to develop business, commercial, and investment models for Public-Private Partnership and digital transformation initiatives. The role requires 6-8+ years of experi
Cybersecurity GRC Consultant
Riyadh, KSA
Cybersecurity GRC Consultant
Riyadh, KSA
Cybersecurity GRC Consultant
Riyadh, KSA
Business Architect
Riyadh, KSA
Technology Architect
Riyadh, KSA
Smart City Solution Architect
Riyadh, KSA
Smart City Application Architect
Riyadh, KSA
PPP Business Modelling Consultant
Riyadh, KSA