Key Responsibilities
* 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
* Bachelor’s degree (or equivalent experience); advanced degree desirable
* 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
* Strong SQL skills; scripting experience (PL/SQL, Python) advantageous
* 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
* Flexible hybrid working model supporting work-life balance
* Inclusive and diverse working environment
Eligibility
Applicants must have the right to work in the United Kingdom.