Data Architect (Databricks)

Location: Manchester, with hybrid working and attendance required 2 days per week

Salary: Up to £85,000 per annum, plus a 15% bonus.

Company

Work with a global insurance firm and leading insurer in the Lloyd's of London market.

What you will do

• Own the end-to-end architecture of the enterprise Databricks Lakehouse platform.
• Define conceptual, logical, and physical data models, information models, data dictionaries, and source-to-target mappings.
• Develop future-state data architecture and transition roadmaps while rationalising legacy assets, duplicated capabilities, and technical debt.
• Set data architecture principles, governance guardrails, reusable patterns, and canonical business definitions.
• Define insurance data models covering underwriting, policy, claims, finance, actuarial, and regulatory use cases.
• Specify security, privacy, metadata, lineage, retention, access control, data quality, integration, and data-sharing requirements.

Requirements

• Hands-on Databricks Lakehouse architecture experience is essential.
• Strong enterprise data modelling experience across conceptual, logical, and physical layers.
• Strong knowledge of SQL, relational modelling, JSON, Azure data platform services, REST APIs, and interface specifications.
• Experience defining architecture principles, reusable patterns, metadata, lineage, and data quality monitoring requirements.
• Experience designing data architecture in regulated environments, including security, privacy, access control, and insurance data requirements.
• Strong stakeholder management skills with the ability to align senior business and technology stakeholders.

Nice to have

• Data modelling or data management experience in underwriting, policy administration, or claims delivery projects.
• Understanding of London or Lloyd's Market insurance data models and standards.
• Experience with Erwin, Sparx EA, or Bizzdesign Horizzon.

Culture & Benefits

• Hybrid working arrangement.
• 15% annual bonus.
• 10% non-contributory pension.
• Family health and dental cover.