Senior Data Modeller – Commercial Insurance

EXL; Greater London; Hybrid; GBP 85,000 - 110,000; Full time

Benefits offered by this job

Private healthcare

Critical illness life assurance

Pension

Employee stock purchase plan (ESPP)

Cycle scheme

Hybrid working model

Job summary

EXL is seeking a Senior Data Modeller in London to lead enterprise data modelling across data lake and data warehouse initiatives. You will set design principles, govern data assets, and align with London Market standards and regulatory frameworks where applicable.

You will mentor teams, translate business needs into scalable technical solutions, and collaborate with stakeholders to drive data architecture direction in an agile environment.

Qualifications

• Deep understanding of the insurance data domain.
• Experience with London Market standards and regulatory frameworks desirable.
• 5-7 years of management or technical leadership experience.
• Experience with data modelling tools and data warehousing concepts.

Responsibilities

• Design and develop conceptual, logical, and physical data models for enterprise-scale data lake and data warehouse solutions.
• Establish and enforce design principles, standards, and naming conventions.
• Create high-quality data models for priority domains and expand across the enterprise.
• Define data governance processes and ownership.
• Collaborate with business users to translate requirements into scalable technical solutions.
• Lead and support setting the data architecture direction and ensure compliance with standards.

Skills

Data modelling

Data architecture

Leadership

Problem solving

Communication

Tools

ERwin

ER/Studio

PowerDesigner

Informatica PowerCenter

Cloud data platforms

Job description

EXL (NASDAQ: EXLS) is a global data and AI company that offers services and solutions to reinvent client business models, drive better outcomes and unlock growth with speed. Bringing together domain expertise with robust data, powerful analytics, cloud and AI to create agile, scalable solutions and execute complex operations for the world’s leading corporations.

EXL was founded on the core values of innovation, collaboration, excellence, integrity and respect, creating value from data to ensure faster decision-making and transforming operating models. Key industries include Insurance, Healthcare, Banking and Financial Services, Media, and Retail, among others.

Headquartered in New York, our team is over 60,000 strong, with more than 50 offices spanning six continents. For information, visit www.exlservice.com.

Location: London, United Kingdom (Hybrid working)

Employment Type: Permanent

The Senior Data Modeller will provide technical expertise and leadership in analysis, design, development, rollout and maintenance of enterprise data models and solutions. This role establishes a clear, layered approach (conceptual, logical, physical) to ensure consistency, scalability, and alignment across the enterprise.

The position requires deep understanding of the insurance data domain and provides technical expertise in needs identification, data modelling, data movement and transformation mapping (source to target), automation and testing strategies, translating business needs into technical solutions with adherence to established data guidelines and approaches from an enterprise perspective. The Senior Data Modeler creates high-quality data models for priority domains with a structured plan to progressively expand across the enterprise landscape.

The role sets design principles and standards to build trusted, reusable, and well-governed data assets that support business outcomes. This includes implementing consistent, business-friendly naming conventions and aligning with governance frameworks, including London Market and regulatory requirements where applicable.

Leadership not only in the conventional sense, but also within a team we expect people to be leaders. Candidate should elicit leadership qualities such as innovation, critical thinking, optimism, positivity, communication, time management, collaboration, problem solving, acting independently, knowledge sharing and being approachable.

As part of your duties, you will be responsible for:

• Design and develop conceptual, logical, and physical data models for enterprise-scale data lake and data warehouse solutions, along with corresponding metadata, ensuring layered consistency and scalability across the enterprise
• Establish and enforce design principles, standards, and naming conventions to build trusted, reusable, and well-governed data assets that support business outcomes
• Create high-quality data models for priority domains with a structured plan to progressively expand across the enterprise landscape
• Implement consistent, business-friendly naming conventions and align with governance frameworks, including London Market standards (ACORD, CDR, MRC) and regulatory requirements where applicable
• Define processes, ownership, and tooling to maintain, govern, and continuously evolve data assets over time
• Understanding of data integration processes (batch or real-time) using tools such as Informatica PowerCenter and/or Cloud, Microsoft SSIS, MuleSoft, DataStage, Sqoop, and similar platforms
• Create functional and technical documentation including data integration architecture documentation, data models, data dictionaries, data integration specifications, and data testing plans
• Collaborate with business users to analyse and test requirements, translating business needs into scalable technical solutions
• Stay current with emerging and changing technologies to best recommend and implement beneficial technologies and approaches for data architecture
• Lead and support setting the data architecture direction (including data movement approach, architecture and technology strategy, and other data-related considerations to ensure business value), ensuring data architecture deliverables are developed, ensuring compliance with standards and guidelines, implementing the data architecture, and supporting technical developers at an enterprise level
• Coordinate and consult with project managers, client business staff, client technical staff and project developers in data architecture best practices and data-related matters at the enterprise and business unit levels
• Perform reverse engineering of physical data models from databases and SQL scripts
• Maintain rigorous versioning of documentation and models to ensure consistent delivery and understanding between the client and development team

Experience and Education required:

• Deep understanding of the insurance data domain; experience working as a data modeler for a London market insurer is equally valuable to specialized London Market technical expertise
• Experience using major data modelling tools (examples: ERwin, ER/Studio, PowerDesigner, or similar enterprise modelling platforms)
• Experience with major database platforms (Oracle, SQL Server, Teradata, Snowflake, cloud-native databases)
• Understanding and experience with major data architecture philosophies (Dimensional, ODS, Data Vault, Data Mesh)
• 5-7 years of management or technical leadership experience required
• 5-7 years consulting experience preferred
• Experience in data analysis, profiling, and data quality assessment
• Strong data warehousing and OLTP systems experience from a modelling and integration perspective
• Strong understanding of data integration best practices, patterns, and architectural concepts
• Strong development experience under Unix and/or Windows environments
• Strong knowledge of all phases of the system development life cycle including agile methodologies
• Understanding of modern data warehouse capabilities and technologies such as real-time, cloud, Big Data, and streaming architectures
• Understanding of on-premises and cloud infrastructure architectures (Azure, AWS, Google Cloud)
• Knowledge of London Market standards (ACORD, CDR, MRC) and regulatory frameworks is highly desirable but not essential

Preferred Skills & Experience

• Ability to analyse business requirements as they relate to data movement and transformation processes, research, evaluation and recommendation of alternative solutions
• Ability to transform business requirements into technical requirement documents and enterprise-level design patterns
• Ability to run conceptual data modelling sessions to accurately define business processes, independently of data structures and then combine the two together
• Can create documentation and presentations such that they stand on their own with minimal additional context
• Demonstrates ability to create new and innovative solutions to problems that have previously not been encountered
• Ability to work independently on complex projects as well as collaborate effectively across teams and organisational boundaries
• Must excel in a fast-paced, agile environment where critical thinking and strong problem-solving skills are required for success
• Strong team building, interpersonal, analytical, problem identification and resolution skills
• Can effectively utilise SQL and/or available BI tools to validate and elaborate business rules
• Demonstrates an understanding of EDM architectures and applies this knowledge in collaborating with teams to design effective solutions to business problems
• Understands and leverages multi-layer semantic models to ensure scalability, durability, and supportability of analytic solutions
• Understands modern data warehouse concepts (real-time, cloud, Big Data) and how to enable such capabilities from a reporting and analytic standpoint

As part of a leading global Data and AI company, you can look forward to:

• A competitive salary with a generous bonus, private healthcare, critical illness life assurance at 4 x your annual salary, income protection insurance, and a rewarding pension.
• EXL provides everyday financial well-being solutions, such as cash back cards, in which you can earn cashback while enjoying discounts, promotions, and offers from top retailers. We also offer a Cycle Scheme where you can save money on bikes and cycling accessories.
• At EXL, we are committed to providing our employees with the tools and resources they need to succeed and excel in their careers. We offer a wide range of professional and personal development opportunities. We also support a range of learning initiatives that allow our employees to build on their existing skills and knowledge. From online courses to seminars and workshops, our employees have the opportunity to enhance their skills and stay up to date with the latest trends and technologies.
• As an Equal Opportunity Employer, EXL is committed to diversity. Our company does not discriminate based on race, religion, colour, national origin, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, age, or disability status.
• EXL employees are eligible to purchase stock as part of our Employee Stock Purchase Plan (ESPP).
• At EXL, we offer a flexible hybrid working model that allows employees to live a balanced, healthy lifestyle while strengthening our culture of collaboration.

To be considered for this role, you must already be eligible to work in the United Kingdom.