Data Modeler Lead

LocationLondon, England, United Kingdom# Data Modeler Lead at N Consulting LtdLocationLondon, England, United KingdomSalary£400 - £450 /dayJob TypeContractDate PostedJanuary 27th, 2026Apply Now Key Responsibilities Analyze and understand existing customer data and analytics models on SQL Server Design and lead development of optimized data models on Snowflake Work closely with Business Analysts and stakeholders to translate reporting and analytics requirements into scalable data structuresDrive best practices in dimensional modeling, normalization, metadata management, and data governance Lead architecture reviews, identify data model gaps, and recommend improvementsMentor junior data modelers and contribute to documentation and knowledge sharingEnsure data models align with enterprise standards, regulatory requirements, and performance needs Mandatory Skills & Experience 10+ years overall experience, with 5+ years in data modeling and database design Strong expertise in SQL Server and Snowflake data modeling Advanced SQL skills for data analysis and validationSolid understanding of data architecture principles and data governance Proven experience in the Insurance domain (London Market, Specialized Insurance, Regulatory Data)Excellent communication and stakeholder management skills Desired Skills Experience with ETL tools and data integration Knowledge of data warehousing concepts and cloud data platforms Exposure to Fivetran, SSIS, or advanced Snowflake features Work Mode Hybrid: 2-3 days working from client office (London) On need basis, work from end-client office Data Modeler Lead (Contract) Location: London, UK (2-3 days WFO depending on business needs) Contract Duration: 6-12 months Industry: Insurance (London Market / Specialized Insurance)We are looking for an experienced Data Modeler Lead to join a high-impact data transformation initiative within the Insurance domain . This role will focus on modernizing enterprise data models by transitioning from SQL Server to Snowflake , enabling scalable analytics and regulatory reporting.