Data Modeler

We are hiring for Data Modeler at London, UK - 3 days per week Onsite Job Description: • Expertise in data modelling methodologies, including conceptual, logical, physical, and dimensional modelling (Kimball/Inmon). • Proven experience designing enterprise semantic layers, particularly for lakehouse architectures • Strong understanding of data warehousing principles, star/snowflake schemas, fact/slowly changing dimensions, and canonical data models. • Ability to translate complex business requirements into scalable, well-structured data models that support analytics, BI, ML, and operational use cases. • Experience collaborating with data engineers to guide physical implementation, ensuring alignment with modelling standards and performance requirements. • Working knowledge of modern data platforms and storage patterns, including Delta Lake, Parquet, medallion architectures, and distributed systems. • Proficiency with data modelling tools such as ER/Studio, ERWin, Sparx EA, dbt metrics layer, or similar. • Strong SQL skills for validating data structures, profiling data, and ensuring model accuracy. • Knowledge of metadata management, lineage, and governance frameworks, ensuring that modelled entities align with enterprise standards and regulatory controls. • Experience defining naming standards, modelling conventions, and reusable data artefacts to ensure consistency across data domains. • Ability to assess data quality issues and identify model level improvements to enhance trust and usability of curated datasets. • Strong communication skills, capable of translating technical modelling decisions into clear guidance for engineers, analysts, and business partners. • Familiarity with semantic modelling layers (e.g., dbt Semantic Layer, Power BI, LookML) and how data structures support BI and AI use cases. • Experience working within federated or domain driven data environments, including Data Mesh or similar patterns.