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 is seeking a Senior Data Modeler Consultant to design, implement, and optimize enterprise data architecture and models. The role involves conceptual, logical, and physical modeling for OLTP, OLAP, and Data Lakehouse environments, ensuring data is structured for performance and scalability.
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 (operational), OLAP (analytical), and Enterprise Data Lakehouse environments
- Understand business processes and translate them into robust data requirements and review current report design documents
- Design 3NF for transactional databases, Dimensional Models (Kimball/Star Schema) for data warehousing, and Data Vault 2.0 for scalable enterprise data lakes
- Transform unstructured data into structured data by fixing errors, eliminate redundancies and unnecessary data to optimize data systems
- 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 for data systems and metadata management
- Specify rules and guidelines for ensuring data security and compliance
- Maintain data schemas using modern standards modeling tools and ensure documentation is accessible to both technical and non technical users
Requirements
- B.Sc. Degree with a minimum of 5+ years of dedicated data modeling experience in enterprise relational databases, columnar databases
- SQL Proficiency Write, read, and optimize complex SQL transactional and analytical queries
- Modern Data Stack Familiarity Experience modeling for cloud data warehouses/lakehouses (e.g., SQLSERVER, Hadoop, Snowflake, BigQuery, Databricks), working alongside transformation tools (e.g., dbt), and create ERDs for relational systems and dimensional diagrams
- Tooling Proficiency with ER/Studio, Erwin or similar data modeling software
- NoSQL/Unstructured Data Understanding of when and how to model semi structured data (JSON, Parquet) and NoSQL databases (MongoDB, Cassandra) alongside relational data
- Physical Data Management Understand current data storage constraints and define TO BE needs with growth allocation
- Data Integration Familiar with ETL tools to define the rules for data transformations and prepare data for big data analytics
- Soft Skills: Communication, presentation skills, Business needs, able to lead or mentor a team
- Certificates: W3school SQL Certification, DAMA CDMP Certification, Microsoft: Azure Data Engineer Associate
Full Job Posting
Company Description
- At Devoteam, we believe that technology, combined with strong human values, can actively drive change for the better.
- With over 25 years of passion for technology and a presence in 18+ countries across EMEA and beyond.
Job Description Summary
- Design, implement, optimize enterprise data architecture and models that represent complex data using relational, dimensional, and NoSQL databases, and ensure data is structured for high performance, clarity, and long term scalability across both operational and analytical systems.
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 and how data will be stored, managed and used.
- Business Alignment Understand business processes and translate them into robust data requirements and review current report design documents to understand where data model structures can address business requirements.
- Multi Paradigm Modeling Designing 3NF (Third Normal Form) 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 to optimize data systems.
- 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 for data systems and metadata management.
- Data Security Specify rules and guidelines for ensuring data security and compliance. Define procedures for ensuring data are classified according to their sensitivity.
- Tooling & Documentation Maintain data schemas using modern standards modeling tools and ensure documentation is accessible to both technical and non technical users.
Qualifications
- B.Sc. Degree with a minimum of 5+ years of dedicated data modeling experience in enterprise relational databases, columnar databases.
- SQL Proficiency Write, read, and optimize complex SQL transactional and analytical queries
- Modern Data Stack Familiarity Experience modeling for cloud data warehouses/lakehouses (e.g., SQLSERVER, Hadoop, Snowflake, BigQuery, Databricks), working alongside transformation tools (e.g., dbt), and create ERDs for relational systems and dimensional diagrams.
- Tooling Proficiency with ER/Studio, Erwin or similar data modeling software.
- NoSQL/Unstructured Data Understanding of when and how to model semi structured data (JSON, Parquet) and NoSQL databases (MongoDB, Cassandra) alongside relational data.
- Physical Data Management Understand current data storage constrains and define TO BE needs with growth allocation.
- Data Integration Familiar with ETL tools to define the rules for data transformations and prepare data for big data analytics.
- Soft Skills: Communication, presentation skills, Business needs, able to lead or mentor a team.
Certificates
- W3school SQL Certification, DAMA CDMP Certification, Microsoft: Azure Data Engineer Associate.
Additional Information
- Business Unit: DAIC
- Level: Mid senior level
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