Impress employers and recruiters.
Choose from hundreds of resume examples.

Target Resume Now

About the Role

The Senior Data Modeller will provide technical expertise and leadership in the 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 a deep understanding of the insurance data domain and provides technical expertise in needs identification, data modelling, data movement and transformation mapping, automation and testing strategies, and translating business needs into technical solutions with adherence to established data guidelines.

Responsibilities

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.
Understand 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.

Requirements

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 SQL skills required; scripting (PL/SQL, Python) preferred.
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.
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.
Must already be eligible to work in the United Kingdom.

Skills

Data Modelling
Data Lake
Data Warehouse
Metadata Management
Scalability
Informatica PowerCenter
Cloud Data Integration
Microsoft SSIS
MuleSoft
DataStage
Sqoop
Data Integration Architecture
Data Dictionaries
Data Testing
Agile Methodologies
Unix
Windows
SQL
PL/SQL
Python
Azure
AWS
Google Cloud
ERwin
ER/Studio
PowerDesigner
Oracle
SQL Server
Teradata
Snowflake
Cloud-Native Databases
Dimensional Modelling
ODS Modelling
Data Vault Modelling
Data Mesh Architecture
Data Analysis
Data Profiling
Data Quality Assessment
Data Warehousing
OLTP Systems
Business Intelligence Tools
EDM Architectures
Multi-layer Semantic Models
Big Data
Streaming Architectures

Location

London, United Kingdom

Work Type

Hybrid working
Permanent

Experience Level

Senior
5-7 years of management or technical leadership experience
5-7 years consulting experience preferred

Education Level

Bachelor's degree or equivalent experience
Master's degree preferred

Benefits

Competitive salary
Generous bonus
Private healthcare
Critical illness life assurance at 4 x your annual salary
Income protection insurance
Rewarding pension
Everyday financial well-being solutions, such as cash back cards
Cycle Scheme
Professional and personal development opportunities
Support for a range of learning initiatives
Employee Stock Purchase Plan (ESPP)
Flexible hybrid working model

About the Company

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.

Equal Opportunity

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.