Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Lead the design and development of data models for scalable analytics in the insurance sector.
- Company: Join N Consulting Ltd, a leader in data transformation within the insurance industry.
- Benefits: Competitive daily rate, hybrid work model, and opportunities for professional growth.
- Why this job: Make a significant impact by modernising data models and driving best practices.
- Qualifications: 10+ years experience with strong SQL Server and Snowflake expertise required.
- Other info: Collaborate with stakeholders and mentor junior team members in a dynamic environment.
Location: London, England, United Kingdom
Salary: £400 - £450 /day
Job Type: Contract
Date Posted: January 27th, 2026
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 structures
- Drive best practices in dimensional modeling, normalization, metadata management, and data governance
- Lead architecture reviews, identify data model gaps, and recommend improvements
- Mentor junior data modelers and contribute to documentation and knowledge sharing
- Ensure 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 validation
- Solid 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
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.
Data Modeler Lead employer: N Consulting Limited
Contact Detail:
N Consulting Limited Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Modeler Lead
✨Network Like a Pro
Get out there and connect with people in the industry! Attend meetups, webinars, or even casual coffee chats. You never know who might have the inside scoop on job openings or can put in a good word for you.
✨Show Off Your Skills
When you get the chance to chat with potential employers, don’t hold back! Share your past projects and how you’ve tackled challenges in data modeling. Use real examples to demonstrate your expertise in SQL Server and Snowflake.
✨Tailor Your Approach
Every company is different, so make sure you tailor your conversations to their specific needs. Research N Consulting Ltd and understand their focus on the insurance domain. This will help you align your skills with what they’re looking for.
✨Apply Through Our Website
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, it shows you’re serious about joining the team and ready to take on the challenge of modernising data models.
We think you need these skills to ace Data Modeler Lead
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the Data Modeler Lead role. Highlight your experience with SQL Server and Snowflake, and don’t forget to mention your expertise in data modeling and database design. We want to see how your skills align with what we’re looking for!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you’re the perfect fit for this role. Talk about your experience in the insurance domain and how you’ve driven best practices in data governance. Let us know what makes you tick!
Showcase Your Communication Skills: Since this role involves working closely with Business Analysts and stakeholders, make sure to highlight your communication skills in your application. We love candidates who can translate complex data requirements into clear, actionable insights!
Apply Through Our Website: Don’t forget to apply through our website! It’s the easiest way for us to keep track of your application and ensures you’re considered for the role. Plus, it shows you’re serious about joining our team at StudySmarter!
How to prepare for a job interview at N Consulting Limited
✨Know Your Data Inside Out
Make sure you’re well-versed in SQL Server and Snowflake data modeling. Brush up on your advanced SQL skills and be ready to discuss how you've applied data architecture principles in past projects, especially in the insurance domain.
✨Showcase Your Leadership Skills
As a Data Modeler Lead, you'll need to demonstrate your ability to mentor junior team members and lead architecture reviews. Prepare examples of how you've successfully guided teams or improved data models in previous roles.
✨Understand the Business Context
Familiarise yourself with the specific needs of the insurance industry, particularly the London Market. Be prepared to discuss how your data models can support regulatory requirements and enhance reporting capabilities.
✨Communicate Effectively
Strong communication and stakeholder management skills are crucial. Practice articulating complex data concepts in simple terms, and think about how you can engage with business analysts and stakeholders to translate their requirements into actionable data structures.
