Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Lead the design and transformation of enterprise data models for high-performance analytics.
- Company: Join Infosys, a global leader in digital services and consulting.
- Benefits: Competitive salary, bonus opportunities, and a commitment to diversity and inclusion.
- Why this job: Make a real impact by optimising data structures in a dynamic environment.
- Qualifications: 5+ years in data modelling, strong SQL Server and Snowflake expertise required.
- Other info: Collaborate with cross-functional teams and mentor junior data modelers.
The predicted salary is between 48000 - 84000 £ per year.
We are seeking an experienced Data Modeler who can analyse and understand the existing customer data and analytics models on SQL Server, and design efficient data models for Snowflake. This individual will work closely with multiple Business Analysts to gather requirements and translate them into optimized data structures, ensuring scalability and compliance with industry standards.
A strong understanding of Insurance domain concepts—including Specialized Insurance, London Market, and Regulatory Data—is essential for success in this role.
Your role
In the role of a Data Modelling Lead, you will be responsible for leading the design and transformation of enterprise data models to support scalable, high-performance analytics and reporting solutions. You will analyse existing data models built on SQL Server and guide the development of optimized structures on Snowflake, ensuring alignment with business requirements and enterprise standards.
You will collaborate with Business Analysts and cross-functional teams to translate complex reporting and analytics needs into efficient, well-governed data models. Your leadership will be key in identifying gaps, driving improvements, and implementing best practices in dimensional modelling, normalization, and metadata management.
A strong understanding of the Insurance domain—including Specialized Insurance, London Market operations, and Regulatory Data—is essential. You will apply this domain expertise to ensure that data models accurately reflect business processes and regulatory obligations.
As a lead, you will contribute to architecture reviews, mentor junior data modelers, and support data governance initiatives. You will also play a role in documentation, knowledge sharing, and capability building across the data modelling practice.
Your work will enable the organization to build a robust foundation for analytics, improve data quality, and support strategic decision-making through well-structured, scalable, and domain-aligned data models.
Responsibilities
- Analyse and document the current data model in SQL Server for customer data and analytics.
- Design and implement new data models or modify existing ones for Snowflake.
- Ensure models adhere to best practices for normalization, performance, and scalability.
- Collaborate with data engineering teams to implement models effectively.
- Work closely with Business Analysts to understand business requirements.
- Translate functional requirements into logical and physical data models.
- Provide impact analysis for changes to existing models and propose efficient solutions.
- Apply knowledge of Insurance domain, including: Specialized Insurance products, London Market practices, Regulatory and compliance data requirements.
- Ensure data models align with industry standards and regulatory guidelines.
Required
- 5+ years of experience in data modeling and database design.
- Strong expertise in SQL Server and Snowflake data modeling.
- Proficiency in SQL for data analysis and validation.
- Experience in data architecture principles and data governance.
- Solid understanding of Insurance domain concepts (Specialized Insurance, London Market, Regulatory Data).
- Excellent communication and stakeholder management skills.
Preferred
- Experience with ETL tools and data integration processes.
- Familiarity with data warehousing concepts and cloud data platforms.
- Exposure to Fivetran, SSIS, or Snowflake advanced features.
Personal
- High analytical skills
- A high degree of initiative and flexibility
- High customer orientation
- High quality awareness
- Excellent verbal and written communication skills
Senior Consultant_ Data Modelling in London employer: Infosys Limited
Contact Detail:
Infosys Limited Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Senior Consultant_ Data Modelling in London
✨Tip Number 1
Network like a pro! Reach out to your connections in the industry, especially those who work with data modelling or in the insurance sector. A friendly chat can lead to insider info about job openings that aren't even advertised yet.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your best data models and projects. This is your chance to demonstrate your expertise in SQL Server and Snowflake, and how you’ve tackled real-world problems in the insurance domain.
✨Tip Number 3
Prepare for interviews by brushing up on your knowledge of industry standards and regulatory requirements. Be ready to discuss how your experience aligns with the needs of the role, especially in terms of data governance and compliance.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets noticed. Plus, we love seeing candidates who take the initiative to connect directly with us.
We think you need these skills to ace Senior Consultant_ Data Modelling in London
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to highlight your experience with data modelling, especially with SQL Server and Snowflake. We want to see how your skills align with the specific requirements of the role, so don’t be shy about showcasing your relevant projects!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you’re passionate about data modelling and how your background in the insurance domain makes you a perfect fit for us. Keep it concise but impactful!
Showcase Your Technical Skills: Don’t forget to highlight your technical expertise in SQL and data architecture principles. We’re looking for someone who can hit the ground running, so make sure we can easily spot your relevant skills and experiences.
Apply Through Our Website: We encourage you to apply through our website for a smoother application process. It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it shows you’re keen on joining our team!
How to prepare for a job interview at Infosys Limited
✨Know Your Data Modelling Inside Out
Make sure you brush up on your data modelling skills, especially with SQL Server and Snowflake. Be ready to discuss specific projects where you've designed or transformed data models, and how you ensured they met business requirements and industry standards.
✨Understand the Insurance Domain
Since this role requires a strong grasp of the Insurance domain, do your homework! Familiarise yourself with concepts like Specialized Insurance, London Market practices, and regulatory data requirements. Being able to speak confidently about these topics will set you apart.
✨Prepare for Collaboration Questions
Expect questions about how you work with Business Analysts and cross-functional teams. Think of examples where you've successfully translated complex requirements into efficient data models. Highlight your communication skills and ability to mentor others in the process.
✨Showcase Your Problem-Solving Skills
Be prepared to discuss how you've identified gaps in existing data models and proposed improvements. Share specific instances where your analytical skills led to better data governance or enhanced performance in data structures. This will demonstrate your initiative and flexibility.
