Data Modeller Consultant
Data Modeller
Purpose of the Role
The Data Modeller is responsible for shaping how data is structured, related, and represented across enterprise systems. This role focuses on creating clear, scalable, and business-aligned data models that support analytics, operational reporting, integrations, and system migrations. Acting as a translator between business concepts and technical implementation, the Data Modeller ensures data structures are intuitive, consistent, and future-proof.
Key Responsibilities
Conceptual, Logical & Physical Modelling
- Develop and maintain conceptual, logical, and physical data models aligned to business needs and target architectures
- Translate business processes and requirements into well-defined entities, attributes, and relationships
- Ensure models support both transactional and analytical use cases
Stakeholder Engagement & Requirements Translation
- Work closely with business analysts, product owners, and subject matter experts to understand data meaning and usage
- Challenge ambiguity in requirements and drive clarity in data definitions and structures
- Facilitate workshops to validate models and align stakeholders on data concepts
Standards, Consistency & Governance
- Apply modelling standards, naming conventions, and design patterns consistently across domains
- Ensure alignment with enterprise data architecture principles and governance frameworks
- Contribute to data dictionaries, metadata repositories, and reference models
Integration & Downstream Enablement
- Design models that support system integrations, reporting, BI, and advanced analytics
- Collaborate with data engineers and migration teams to ensure models are implementable and performant
- Support impact analysis for changes to upstream or downstream systems
Quality, Performance & Scalability
- Ensure models minimise redundancy, support data integrity, and enforce appropriate constraints
- Balance normalisation with performance and usability considerations
- Anticipate future growth, extensibility, and evolving business requirements
Key Skills & Experience
- Proven experience designing data models across complex business domains
- Strong understanding of relational modelling principles and dimensional modelling concepts
- Experience producing conceptual, logical, and physical models for enterprise systems
- Solid grasp of data normalisation, denormalisation, and reference data design
- Familiarity with SQL and how models translate into physical database structures
- Experience working alongside ETL, integration, and analytics teams
- Exposure to data governance, metadata management, and data standards
- Experience with modelling tools (e.g. ER/Studio, ERwin, PowerDesigner, or equivalent)