Data Modeler

Experis; Greater London; On-site; GBP 60,000 - 80,000; Full time

Benefits offered by this job

Comprehensive healthcare

Pension

Life assurance

Financial wellbeing benefits

Retail discount schemes

Job summary

Experis is looking for a skilled data architect to design and develop conceptual, logical, and physical data models for data lake and data warehouse solutions. The role emphasizes experience within the insurance data domain, with a preference for candidates familiar with London Market standards.

Successful applicants will benefit from a competitive salary, comprehensive healthcare, and ongoing professional development opportunities. Strong communication and documentation skills are essential for overseeing project requirements and collaborating with diverse teams.

Qualifications

• 5-7 years of experience in technical leadership or management roles.
• Strong experience within the insurance data domain.
• Proven experience with enterprise data modelling tools.

Responsibilities

• Design and develop data models for data lake and warehouse solutions.
• Ensure compliance with London Market standards and regulatory requirements.
• Collaborate with stakeholders to translate business requirements.

Skills

Data analysis

Data modelling

Stakeholder management

Documentation

Problem-solving

Tools

Informatica

ERwin

SQL Server

Oracle

Azure

Job description

• Design and develop conceptual, logical, and physical data models for enterprise‑scale data lake and data warehouse solutions, ensuring consistency across all layers
• Establish and enforce design principles, standards, and naming conventions to promote reusable and well‑governed data assets
• Deliver high‑quality data models for priority domains and support a structured expansion across the enterprise
• Align modelling standards with governance frameworks, including London Market standards (ACORD, CDR, MRC) and regulatory requirements
• Define processes, ownership, and tooling to manage and evolve data assets over time
• Support data integration processes (batch and real‑time) using tools such as Informatica, SSIS, MuleSoft, DataStage, and similar platforms
• Produce clear functional and technical documentation (data models, dictionaries, integration specifications, testing plans)
• Collaborate with business stakeholders to analyse requirements and translate them into technical solutions
• Stay current with evolving technologies and recommend improvements to data architecture approaches
• Lead and contribute to enterprise data architecture strategy, including data movement, tooling, and design standards
• Engage with project managers, business users, and technical teams to ensure best practices in data modelling
• Perform reverse engineering of physical data models from databases and scripts
• Maintain version control and documentation standards to ensure consistency across delivery teams

Experience & Qualifications

• Strong experience within the insurance data domain; London Market experience highly desirable
• Proven experience with enterprise data modelling tools (e.g. ERwin, ER/Studio, PowerDesigner)
• Expertise across database platforms (Oracle, SQL Server, Teradata, Snowflake, and cloud‑native databases)
• Knowledge of data architecture methodologies (Dimensional, ODS, Data Vault, Data Mesh)
• 5–7 years’ experience in technical leadership or management roles
• Consulting experience preferred
• Strong skills in data analysis, profiling, and data quality assessment
• Experience with data warehousing and OLTP systems
• Strong knowledge of data integration patterns and best practices
• Familiarity with SDLC processes and agile delivery methodologies
• Understanding of modern data platforms (cloud, real‑time, streaming, big data)
• Experience with cloud platforms (Azure, AWS, GCP)
• Knowledge of London Market standards and regulatory frameworks desirable

Preferred Skills

• Ability to translate business requirements into enterprise‑level data designs and technical specifications
• Experience running conceptual data modelling workshops
• Strong documentation and presentation skills
• Demonstrated problem‑solving and innovation capabilities
• Ability to work independently and collaboratively across functions
• Comfortable working in fast‑paced, agile environments
• Strong stakeholder management and communication skills
• Experience validating business rules using SQL or BI tools
• Understanding of enterprise data management (EDM) and semantic modelling layers
• Knowledge of modern analytics and reporting frameworks

What’s on Offer

• Competitive salary with bonus and comprehensive benefits package (including healthcare, pension, and life assurance)
• Access to financial wellbeing benefits and retail discount schemes
• Ongoing professional development, training, and learning opportunities
• Inclusive and diverse working environment

Applicants must have the right to work in the United Kingdom.