datamodeller

A datamodeller, also called a data modeller, is a professional who designs the data structures that support information systems. They translate business concepts into data models that specify entities, attributes, relationships, and constraints.

Work typically involves creating conceptual, logical, and physical models. Conceptual models describe high-level business concepts and relationships; logical models define attributes, keys, data types, and normalization; physical models map these to database schemas, indexing, and performance considerations. Data modelling often uses techniques such as entity-relationship modeling or UML class diagrams, and for analytics and data warehousing, dimensional modelling with star and snowflake schemas.

Datamodellers collaborate with business analysts, data architects, database administrators, software engineers, and data stewards. They ensure data consistency, integrity, and quality, capture business rules, and support data governance, metadata management, and data lineage.

Deliverables commonly include data models and diagrams, data dictionaries, data lineage diagrams, schema definitions, and documentation of constraints and rules. They may employ modeling tools such as ER/Studio, PowerDesigner, Sparx Systems Enterprise Architect, or open-source options, and languages like SQL or data modeling notations.

In practice, datamodellers work across domains such as finance, healthcare, retail, and technology. Requirements vary by domain, but core skills include abstraction, problem solving, SQL, database design, and familiarity with database management systems and data governance standards. The role is typically part of data management or enterprise architecture teams and complements data engineers and data scientists.