At a Glance
- Tasks: Lead the design and transformation of enterprise data models for scalable analytics.
- Company: Join Infosys, a global leader in digital services and consulting.
- Benefits: Competitive salary, inclusive culture, and opportunities for professional growth.
- Other info: Collaborative environment with a focus on diversity and sustainability.
- Why this job: Make an impact by optimising data models and supporting strategic decision-making.
- Qualifications: 5+ years in data modelling, strong SQL Server and Snowflake expertise.
The predicted salary is between 72000 - 88000 £ per year.
Role – Data Modelling Lead
Technology – Snowflake, SQL Server, Postgre SQL, Data Warehousing, Data Lake, Medallion, Data Vault, Data Fabric, Semantic modelling
Location – London, UK
Job Description
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.
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.
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.
- Overview
Infosys is a global leader in next-generation digital services and consulting.
We enable clients in 59 countries to navigate their digital transformation.
With over four decades of experience in managing the systems and workings of global enterprises, we expertly steer clients, in 59 countries, as they navigate their digital transformation powered by cloud and AI.
We enable them with an AI-first core, empower the business with agile digital at scale and drive continuous improvement with always-on learning through the transfer of digital skills, expertise, and ideas from our innovation ecosystem.
We are deeply committed to being a well-governed, environmentally sustainable organization where diverse talent thrives in an inclusive workplace.
All aspects of employment at Infosys are based on merit, competence and performance.
We are committed to embracing diversity and creating an inclusive environment for all employees.
Infosys is proud to be an equal opportunity employer.
Principal Consultant_ Data Modelling in London employer: Infosys
Infosys is an exceptional employer, offering a dynamic work culture that fosters innovation and collaboration within the Strategic Technology Group. Employees benefit from continuous learning opportunities and the chance to lead transformative projects in the manufacturing sector, all while being part of a global leader in digital services. Located in London, the role provides access to a vibrant city known for its diverse professional landscape and networking potential, making it an ideal environment for career growth and impactful contributions.
StudySmarter Expert Advice🤫
We think this is how you could land Principal Consultant_ Data Modelling in London
✨Get Involved in Data Science Meetups
Tap into local data science meetups or workshops to connect with fellow enthusiasts and professionals. These events are goldmines for networking, and sometimes even lead directly to job openings at companies like Infosys!
✨Show Off Your Projects
Start building a public portfolio showcasing your data science projects on platforms like GitHub or personal websites. Highlight unique analyses or models you've developed. This not only demonstrates your skills but also gets your name out there for roles like Principal Consultant_ Data Modelling at Infosys.
✨Leverage Professional Networks
Join professional bodies related to data science, like the Data Science Society or similar organisations. Getting involved can lead to mentorship opportunities and insider knowledge about full-time positions at companies like Infosys.
✨Apply Directly through Our Website
When you find a suitable opening like Principal Consultant_ Data Modelling at Infosys, make sure to apply directly through our website. It gives you an edge and shows you're keen to join our team. Plus, who doesn’t love a direct application? It’s easier than navigating through job boards!
We think you need these skills to ace Principal Consultant_ Data Modelling in London
Some tips for your application 🫡
Show Off Your Projects:In the world of data science, your projects can speak volumes about your skills. Make sure to showcase a few key projects in your CV or portfolio, especially those that highlight your ability to work with data sets, build models, or use relevant tools like Python, R, or SQL. Don’t forget to include links to any GitHub repositories if applicable!
Quantify Your Achievements:Employers love numbers! When drafting your CV, highlight your achievements with quantifiable results. For instance, mention how your data analysis led to a certain percentage increase in efficiency or revenue at a previous job or project. These details can really make your application pop!
Craft a Tailored Cover Letter:For a full-time role at Infosys, your cover letter should reflect your passion for data science and your excitement about the specific projects or values of the company. Dive into why you’re a good fit, how your skills align with their needs, and any unique perspectives you can bring to the team.
Stand Out with Relevant Courses and Certifications:Although experience talks, relevant courses or certifications can be your ticket to impressing hiring managers at Infosys. Mention any standout courses you've completed that equipped you with essential skills, such as machine learning certifications or data visualisation courses. This shows your commitment to continuously developing your skills in the field!
How to prepare for a job interview at Infosys
✨Brush Up on Your Statistics
For a data science role, we need to seriously sharpen our statistics skills. Get ready to tackle technical questions on probability distributions, hypothesis testing, and regression analysis. These are often the bread and butter of data science interviews, so don't just skim over them!
✨Showcase Your Projects
Prepare a killer portfolio showcasing your data science projects. We should include details about the datasets used, the tools and techniques applied, and the impact of your findings. If we can walk them through a particularly challenging project or a cool visualisation that had real-world implications, it’ll really make us stand out!
✨Get Comfortable with Python and R
Most data science positions require us to be proficient in programming languages like Python and R. We should practice common libraries like pandas, NumPy, and scikit-learn, and be ready for live coding exercises or algorithm questions. Showing off our coding chops can really impress the interviewers at Infosys!
✨Prepare for Case Studies
Expect to encounter real-world case studies during the interview. We might be asked how we’d approach a data problem or analyse a dataset to extract insights. It's essential to think out loud and demonstrate our problem-solving process so that the interviewer can see our logical thinking in action.
