Dabster
Data Architect
Get notified of more jobs like this · No spam, ever
How your CV stacks up
Upload your CV to see how well it fits this job role
?%
🎯 Ideal Candidate
The ideal candidate will be a senior-level Data Architect with strong PostgreSQL/SQL expertise and deep London Market insurance experience. You should be comfortable working across business and technical teams, modernising complex data landscapes, and defining scalable, secure, and governed enterprise data architectures.
📍 Position Details
- Role: Data Architect – Insurance
- Location: London, UK
- Working Model: Hybrid
- Contract: Contract
- IR35: Outside IR35
- Domain: Insurance / London Market
📌 Role Overview
We are looking for an experienced Data Architect with strong SQL/PostgreSQL expertise and a proven insurance domain background to design, modernise, and govern enterprise data platforms. The ideal candidate will have hands-on expertise in relational database architecture, data modelling, performance optimisation, data migration, data governance, and modernisation, along with practical knowledge of insurance data domains such as policy administration, claims, underwriting, billing, customer, broker, risk, and reinsurance.
🔧 Key Responsibilities
- Define and own end-to-end data architecture for SQL/PostgreSQL-based platforms supporting transactional, analytical, and reporting workloads.
- Design logical and physical data models, database schemas, data flows, integration patterns, and data migration strategies.
- Partner with business stakeholders, Product Owners, Data Engineers, application teams, and Enterprise Architects to translate insurance requirements into scalable data solutions.
- Lead database modernisation, optimisation, and migration initiatives involving SQL Server, PostgreSQL, and cloud-native PostgreSQL platforms.
- Establish data architecture standards covering:
- Data quality
- Metadata
- Data lineage
- Retention
- Security and privacy
- Regulatory compliance
- Review and optimise database performance, including indexing, partitioning, query design, stored procedures, and data access patterns.
- Support data governance and master/reference data management initiatives across insurance data domains.
- Provide architectural guidance, conduct design reviews, and provide technical leadership to engineering and delivery teams.
- Assess existing data landscapes and define modernisation, rationalisation, and migration roadmaps.
- Produce high-quality architecture documentation, design specifications, and Architecture Decision Records (ADRs).
Reasons to use Rodeo
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
It searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
✅ Must-Have Skills & Experience
- Strong hands-on experience as a Data Architect, Database Architect, or Senior Data Modeller working on enterprise-scale data platforms.
- Mandatory insurance domain experience, with practical understanding of areas such as:
- Policy lifecycle
- Claims
- Underwriting
- Billing
- Customer / Account data
- Broker / Intermediary data
- Risk and exposure
- Reinsurance
- Advanced SQL expertise, including:
- Complex query design
- Stored procedures
- Functions and views
- Indexing
- Partitioning
- Transaction handling
- Performance tuning
- Strong PostgreSQL experience, including schema design, optimisation, security, backup/recovery concepts, replication, and high-availability considerations.
- Strong experience designing conceptual, logical, and physical data models for operational and analytical use cases.
- Strong understanding of:
- Data warehousing
- Data marts
- ETL/ELT
- Data integration
- Data migration
- Experience with data quality, data governance, metadata management, data lineage, access control, and data security.
- Experience working with large, complex, and highly regulated data environments.
- Strong stakeholder management and communication skills, with the ability to communicate architecture decisions to both technical and business stakeholders.
- London Market / London insurance experience is mandatory.
Get help with your application
Your very own career expert that helps elevate your application to the next level.
⭐ Good-to-Have Skills
- Experience with insurance data standards such as ACORD or equivalent canonical insurance data models.
- Experience with cloud database platforms such as:
- AWS Aurora PostgreSQL
- Amazon RDS
- Azure Database for PostgreSQL
- Google Cloud SQL
- Experience with SQL Server to PostgreSQL migration, database refactoring, or legacy data platform modernisation.
- Exposure to modern data platforms such as:
- Snowflake
- Databricks
- Amazon Redshift
- Azure Synapse
- Microsoft Fabric
- Experience with ETL/ELT and data integration tools such as:
- Informatica
- Talend
- dbt
- Airflow
- SSIS
- AWS Glue
- Understanding of insurance regulatory and compliance requirements relating to data privacy, retention, auditability, and operational resilience.
- Experience with Master Data Management (MDM), Reference Data Management, and golden-source data design.
- Familiarity with DevOps/DataOps practices, including:
- CI/CD for database changes
- Version control
- Automated testing
- Deployment pipelines
- Ability to lead architecture workshops and produce high-quality architecture documentation, ADRs, data standards, and design artefacts.
📩 Apply Now
Interested candidates can share their updated CV with: james.a@dabster.net
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills
Location