Senior Data Modeler

About the role

Devoteam is seeking a Senior Data Modeler to design and maintain high‑quality data models that support client analytics initiatives. The role works closely with data architects, engineers, and business stakeholders to translate requirements into scalable, well‑documented structures.

Key responsibilities

• Collaborate with stakeholders to gather and analyse data requirements.
• Translate business needs into conceptual, logical, and physical data models.
• Design and maintain robust data structures for operational and analytical environments.
• Create and maintain ER diagrams and related documentation.
• Apply best practices to ensure data consistency, integrity, and scalability.
• Define entities, relationships, cardinalities, hierarchies, and business rules.
• Design dimensional models (fact and dimension tables) for reporting and analytics.
• Support ETL/ELT teams in implementing approved models.
• Analyze existing structures and recommend optimisations.
• Document data definitions, transformation logic, and model decisions.

Required profile

• Bachelor's degree in Computer Science, Information Systems, Data Management or related field.
• 4–5 years of hands‑on data modeling and database design experience.
• Strong expertise in conceptual, logical and physical modeling.
• Proven ability to design dimensional models using star and snowflake schemas.
• Excellent analytical, problem‑solving and communication skills.

Required skills

• Data modeling tools: Erwin Data Modeler, PowerDesigner.
• SQL for complex data analysis and validation.
• Relational database concepts, normalization and denormalization.
• Dimensional modeling (star, snowflake, Data Vault).
• Metadata management and documentation practices.
• Experience with cloud data platforms: Snowflake, Databricks, Microsoft Fabric, BigQuery.