Senior Data Modeler Consultant📣 Job Ad
| Contract Type | Full-time | |
| Workplace type | On-site | |
| Location | Riyadh |
About the Role
Devoteam is seeking a Senior Data Modeler Consultant to join its team in Riyadh, Saudi Arabia. The company leverages technology and human values to drive positive change, operating in over 18 countries with a culture built on respect, frankness, and passion, fostering collaboration and individual development.
Role Overview
In this role, you will be responsible for designing, implementing, and optimizing enterprise data architecture and models. This involves translating complex business needs into robust data structures for various database types, ensuring data is optimized for performance, clarity, and scalability across operational and analytical systems. You will act as a key liaison between business stakeholders and data engineering teams.
Key Responsibilities
- Assess existing data models to understand the current data environment ("AS-IS").
- Plan, design, and maintain blueprints for future data models ("TO-BE") across OLTP, OLAP, and Enterprise Data Lakehouse environments.
- Translate business processes into data requirements, reviewing existing reports to align data model structures with business needs.
- Design multi-paradigm data models, including 3NF for transactional databases, Dimensional Models (Kimball/Star Schema) for data warehousing, and Data Vault for data lakes.
- Transform unstructured data into structured formats by identifying and rectifying errors, eliminating redundancies, and optimizing data systems for quality.
- Optimize query performance through strategic implementation of indexing, partitioning, and materialization techniques.
- Establish and enforce data governance best practices, including naming standards, definitions, and maintaining data maps and metadata.
- Specify rules and guidelines for data security and compliance, including data classification procedures.
- Maintain data schemas using standard modeling tools and ensure documentation is accessible to all users.
Qualifications and Requirements
- A ** Degree is required.
- A minimum of 5+ years of dedicated data modeling experience in enterprise relational and columnar databases.
- Proficiency in writing, reading, and optimizing complex SQL transactional and analytical queries.
- Familiarity with modern data stacks and experience modeling for cloud data warehouses/lakehouses such as SQL Server, Hadoop, Snowflake, BigQuery, and Databricks.
- Experience working with transformation tools like dbt.
- Proficiency with data modeling software such as ER/Studio, Erwin, or similar tools.
- Strong understanding of modeling semi-structured data (JSON, Parquet) and NoSQL databases (MongoDB, Cassandra) in conjunction with relational data.
- Understanding of current data storage constraints and the ability to define future needs with appropriate growth allocation.
- Familiarity with ETL tools to define data transformation rules for big data analytics.
- Excellent communication and presentation skills.
- Ability to understand business needs effectively.
- Demonstrated ability to lead or mentor a team.
Technical Skills
- Data Modeling, Enterprise Data Architecture, Relational Databases, Dimensional Databases, NoSQL Databases, OLTP, OLAP, Enterprise Data Lakehouse.
- 3NF, Dimensional Models (Kimball/Star Schema), Data Vault *
- Data Quality, Performance Optimization, Data Governance, Data Security, Metadata Management.
- SQL, Cloud Data Warehouses/Lakehouses (SQL Server, Hadoop, Snowflake, BigQuery, Databricks), dbt.
- ERDs, ER/Studio, Erwin, JSON, Parquet, MongoDB, Cassandra, ETL tools.
- Communication, Presentation skills, Business needs understanding, Leadership, Mentoring.
Work Location and Experience
This is a full-time position based in Riyadh, Saudi Arabia. The role is within the DAIC Business Unit and requires 5-10 years of experience. Relevant certifications include W3school SQL Certification, DAMA-CDMP Certification, and Microsoft: Azure Data Engineer Associate.
Requirements
- Requires 5-10 Years experience
Similar Jobs
You may also like
- Related Senior Data Modeler Consultant Opportunities
- Marketing Specialist Jobs in Riyadh
- Chef Jobs in Riyadh
- Branch Supervisor Jobs in Riyadh
- Interior Architect Jobs in Riyadh
- Business Development Supervisor Jobs in Riyadh
- Other Job Fields in Riyadh
- Marketing Specialist Jobs in Riyadh
- Chef Jobs in Riyadh
- Branch Supervisor Jobs in Riyadh
- Interior Architect Jobs in Riyadh
- Business Development Supervisor Jobs in Riyadh
- Barista Jobs in Riyadh
- Receptionist Jobs in Riyadh
- Hairdresser Jobs in Riyadh
- Sales Representative Jobs in Riyadh
- Human Resources Specialist Jobs in Riyadh
- Explore Jobs Across Saudi Arabia
- Operations Supervisor Jobs in Jeddah
- Sales Representative Jobs in Al-Ahsa
- Purchasing Manager Jobs in Taif
- Special Education Specialist Jobs in Tabuk
- Assistant Branch Manger Jobs in Jeddah
- Certified Trainer Jobs in Medina
- Human Resources Coordinator Jobs in Makkah
- Sales Engineer Jobs in Al Khobar
- Certified Trainer Jobs in Dammam
- Human Resources Clerk Jobs in Dammam