Solution Data Architect

Intact Insurance UK; Liverpool, Manchester, Horsham, Glasgow; Hybrid; GBP 85,000 - 115,000; Full time

Benefits offered by this job

Annual bonus

Hybrid working

Pension contributions 11%

Health & wellbeing

Job summary

Intact Insurance UK is hiring a Solution Data Architect to design robust, scalable data architectures and lead data modelling efforts across strategic systems. Reporting to the Lead Solution Data Architect, you’ll work with enterprise architects, the Chief Data Office, and business stakeholders to ensure alignment with enterprise standards.

You’ll drive solution-level data architecture, governance, and integration patterns while embedding secure-by-design principles and contributing to

Qualifications

• Advanced data modelling and architectural design skills.
• Hands-on experience with data modelling tools (Erwin highly beneficial).
• Excellent understanding of data integration patterns, middleware, and database technologies.
• Knowledge of data protection, governance frameworks and secure design practices.
• Familiarity with Microsoft Purview or other enterprise data catalogue platforms.
• Experience with master and reference data management tools (e.g. Ataccama, Profisee).
• Working knowledge of the Microsoft Azure ecosystem, including Databricks and Power BI.
• Excellent communication, stakeholder management and influencing skills.
• Experience delivering solution-level data architecture across complex projects and programmes.
• Experience producing data impact assessments, guidance and reusable design patterns.

Responsibilities

• Designing and delivering high-quality solution data architectures aligned to enterprise standards.
• Developing and maintaining solution data models, dictionaries and integration designs.
• Supporting canonical data exchange across strategic systems.
• Acting as the project-level data architecture lead, providing trusted guidance to stakeholders.
• Embedding data governance and Data Protection by Design principles.
• Contributing to the continuous improvement of data architecture practices and patterns.

Skills

Data Modelling

Erwin

Data Integration

Data Governance

Purview

Ataccama

Profisee

Databricks

Power BI

Azure

Stakeholder Mgmt

Security by Design

Tools

Erwin

Purview

Databricks

Power BI

Ataccama

Profisee

Job description

Intact Insurance is the new name for RSA in the UK, Ireland, and across Europe. It’s a new name and a new way to do business. Backed by global expertise and a commitment to service that feels different, we’re focused on making insurance simpler, faster, and more responsive.

Intact Insurance is the new name for RSA in the UK, Ireland, and across Europe. It’s a new name and a new way to do business. Backed by global expertise and a commitment to service that feels different, we’re focused on making insurance simpler, faster, and more responsive.

Shape the future

We’re leading a transformation in insurance helping people, businesses and society prosper in good times and be resilient in bad times. When you join us, you’re not just taking a job, you’re stepping into a career where you can make a real difference.

Grow with us

We’re customer-driven, community-focused, and committed to helping our people grow. Whether you’re early in your journey or bringing years of experience, we’ll support you with the tools, flexibility, and opportunities to thrive.

Win as a Team

This role can be based from Liverpool, Manchester, Horsham or Glasgow.

As the Solution Data Architect you will be reporting to the Lead Solution Data Architect, playing a key role in designing robust, scalable and compliant data architectures., working closely with enterprise architects, the Chief Data Office, technology teams and business stakeholders.

You’ll Make An Impact By

• Designing and delivering high-quality solution data architectures aligned to enterprise standards
• Developing and maintaining solution data models, dictionaries and integration designs
• Supporting canonical data exchange across strategic systems
• Acting as the project-level data architecture lead, providing trusted guidance to stakeholders
• Embedding data governance and Data Protection by Design principles
• Contributing to the continuous improvement of data architecture practices and patterns

Your Skills And Experience

• Advanced data modelling and architectural design skills
• Hands-on experience with data modelling tools is essential. Erwin would be highly beneficial
• Excellent understanding of data integration patterns, middleware and database technologies
• Knowledge of data protection, governance frameworks and secure design practices
• Familiarity with Microsoft Purview or other enterprise data catalogue platforms
• Experience with master and reference data management tools (e.g. Ataccama, Profisee - desirable)
• Working knowledge of the Microsoft Azure ecosystem, including Databricks and Power BI
• Excellent communication, stakeholder management and influencing skills
• Experience delivering solution-level data architecture across complex projects and programmes
• Experience producing data impact assessments, guidance and reusable design patterns

Why you’ll love it here

Being Part Of Our Team Means You’ll Have The Support And Freedom To Bring Your Best Self To Work Each Day. As a Permanent Member, Here’s What You Can Look Forward To

• Annual discretionary bonus
• Up to 11% pension contributions
• Hybrid working + flexible hours
• 25 days annual leave + bank holidays + buy/sell options
• Health & wellbeing + virtual GP
• Career development and mentoring
• Inclusive culture + employee networks
• Share investment options

Our DEI commitment

We celebrate individuality and believe our differences make us stronger.

We’re proud to foster a culture where everyone feels respected, valued, and empowered to thrive.

As an Equal Opportunity and Disability Confident Employer, we ensure fair consideration for all applicants and offer interviews to all disabled candidates who meet the essential criteria.

We understand that everyone’s circumstances are different and are happy to explore flexible working options such as reduced hours or job shares to support work-life balance.