Senior Data Modeller - Commercial Insurance

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.

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.

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).
• 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.

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.