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 seeks a Senior Data Modeler Consultant to design, implement, and optimize enterprise data architecture and models. The role requires 5+ years of data modeling experience, SQL proficiency, and familiarity with modern data stacks.
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 (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, eliminating redundancies
- 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 diagrams
- Specify rules and guidelines for ensuring data security and compliance
- Maintain data schemas using modern modeling tools and ensure documentation is accessible
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)
- Proficiency with ER/Studio, Erwin or similar data modeling software
- Understanding of semi structured data (JSON, Parquet) and NoSQL databases (MongoDB, Cassandra)
- Familiar with ETL tools to define rules for data transformations
- Soft Skills: Communication, presentation skills, business needs, able to lead or mentor a team
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, OLAP, 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.
- 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 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.
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).
- 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).
- 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.
- 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