Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Lead data modelling projects and modernise enterprise data structures for scalable analytics.
- Company: Join a leading insurance firm driving data transformation in the London Market.
- Benefits: Competitive contract rate, flexible hybrid work, and opportunities for professional growth.
- Why this job: Make a significant impact on data strategies in a dynamic insurance environment.
- Qualifications: 10+ years experience with strong SQL Server and Snowflake expertise required.
- Other info: Mentor junior team members and contribute to innovative data solutions.
The predicted salary is between 72000 - 108000 £ per year.
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.
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
- 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
- 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.
Data Modeler Lead employer: Natobotics
Contact Detail:
Natobotics Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Modeler Lead
✨Tip Number 1
Network like a pro! Reach out to your connections in the insurance and data modelling sectors. Attend industry meetups or webinars to meet potential employers and get your name out there.
✨Tip Number 2
Showcase your skills! Create a portfolio that highlights your best data models and projects, especially those relevant to SQL Server and Snowflake. This will give you an edge when discussing your experience.
✨Tip Number 3
Prepare for interviews by brushing up on your technical knowledge and soft skills. Be ready to discuss how you've tackled challenges in data modelling and how you can contribute to the team.
✨Tip Number 4
Don’t forget to apply through our website! We’re always looking for talented individuals like you to join our team. It’s a great way to ensure your application gets noticed.
We think you need these skills to ace Data Modeler Lead
Some tips for your application 🫡
Tailor Your CV: Make sure your CV speaks directly to the Data Modeler Lead role. Highlight your experience with SQL Server and Snowflake, and don’t forget to mention your expertise in the insurance domain. 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. Share specific examples of your past work that relate to data modeling and analytics, and show us your passion for the insurance industry.
Showcase Your Communication Skills: Since this role involves working closely with stakeholders, make sure to highlight your communication skills in your application. We love candidates who can translate complex data concepts into easy-to-understand language, so give us some examples!
Apply Through Our Website: We encourage you to apply through our website for a smoother process. It helps us keep track of your application and ensures you don’t miss out on any important updates. Plus, it’s super easy to do!
How to prepare for a job interview at Natobotics
✨Know Your Data Inside Out
Make sure you thoroughly understand the existing customer data and analytics models on SQL Server. Brush up on your knowledge of Snowflake, as you'll need to demonstrate how you can transition these models effectively.
✨Showcase Your Leadership Skills
As a Data Modeler Lead, you'll be expected to mentor junior data modelers and lead architecture reviews. Prepare examples of how you've successfully led teams or projects in the past, especially in the insurance domain.
✨Communicate Clearly with Stakeholders
Excellent communication is key! Be ready to discuss how you've translated reporting and analytics requirements into scalable data structures. Practice explaining complex concepts in simple terms to show your stakeholder management skills.
✨Demonstrate Best Practices
Familiarise yourself with best practices in dimensional modeling, normalization, and data governance. Be prepared to discuss how you've implemented these in previous roles and how they align with enterprise standards and regulatory requirements.
