Senior Data Modeler Consultant

Overview

Devoteam Culture & Values

Culture

3. Passion

**Job Description** **Summary Introduction:**

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**