Data Architect

Job Title: Data Architect

Location: Paddington – 2 days per week onsite (Tuesday & Thursday)

Work Mode: Hybrid

Domain: Insurance / Financial Services

Experience: 10+ Years

Employment Type: 3months (FTC)

Mandatory Skills

• Azure Databricks (10+years)
• Hands-on experience with dbt, Delta Live Tables (DLT), Prefect, Azure DevOps CI/CD
• Insurance or Finance domain experience

Role Overview

We are seeking an experienced Data Architect to support an insurance client's data transformation initiative. This role combines architectural leadership with hands-on technical execution, focusing on delivering scalable, governed, and high-performance data platforms on Azure Databricks.

Key Responsibilities

• Lead data architecture and platform design on Azure Databricks with Unity Catalog, ensuring scalability, governance, and performance.
• Develop, optimize, and maintain data pipelines using dbt, Delta Live Tables, Spark, and Delta Lake.
• Design and implement insurance data models, particularly for:
• Claims (paid, incurred, case reserves)
• Exposures and reference data
• Actuarial reserving and regulatory reporting
• Incremental vs. cumulative data structures (e.g., triangles)
• Guide engineering teams and client stakeholders on CI/CD best practices, version control, testing, and DevOps pipelines.
• Mentor and coordinate data engineers, analysts, and offshore teams.
• Ensure data quality, lineage, and governance across the platform.
• Collaborate closely with actuaries and business SMEs to validate KPIs, models, and reporting outputs.
• Drive workflow orchestration and automation using Prefect and Azure DevOps.
• Act as a technical escalation point and support successful execution of the data transformation roadmap.

Required Skills & Experience

• Strong background in data architecture and data engineering on Azure Databricks.
• Deep hands-on expertise with:
• Spark, Delta Lake, Unity Catalog
• dbt, Delta Live Tables, Prefect
• Azure DevOps CI/CD pipelines
• Solid understanding of actuarial and insurance data structures, including claims, exposures, and reserving.
• Proven ability to bridge business and technology, working effectively with senior stakeholders.
• Strong leadership, communication, and delivery management skills.

Nice to Have

• Experience in reinsurance or insurance finance.
• Knowledge of actuarial methods and reporting frameworks.
• Exposure to advanced analytics or machine learning for claims and reserving use cases.