We understand that finding the right opportunity can be tough, but I’ll try to make it easier.You’re reading about Zurich Insurance Group, a general leader in insurance, but this role specifically pertains to our Technology Delivery Center (TDC). Established in Barcelona in 2006, the TDC operates as an integral part of Zurich Insurance Group, providing cutting-edge technological solutions and support to Zurich's local and global business units.In essence, Zurich TDC is where technology meets the vast reach of a multinational company. We specialize in areas such as software development, data analytics, cybersecurity, and IT infrastructure.

Our primary mission is to support Zurich's strategic goals and enhance operational efficiency through innovative technology solutions.If you're considering a role with us, know that you'll be joining a hub of technological excellence dedicated to driving Zurich's success on a global scale.The Solution Architect is the technical authority for feature evolution and platform design across ACE (Actuarial Calculation Engine). The role owns architectural decisions across the data, ETL, integration, and application layers — ensuring new capabilities are built with consistency, scalability, and full alignment to cloud migration objectives.It is a multi-layer calculation and data platform built on Databricks (Delta Lake, DBT, PySpark), Azure Data Factory, and a .Net GUI/orchestration layer. The calculation engine manages seven distinct data classes, applies a formula-driven calculation chain with complex interdependencies across a multi-dimensional calculation grain, and produces a result set consumed by reporting, data sharing, and downstream analytical systems including the ZAAi agentic reporting layer.The platform is migrating from Azure to AWS with a target go-live of Q1 2027.

The Solution

Architect will own target-state architecture design and ensure all new features delivered before the migration are AWS-portable from day one..As a Solution Architect – Actuarial Platform (ACE) you will have the opportunity to:Solution Architecture for Feature DeliveryOwn end-to-end technical design for new features and enhancements across the ACE platform and associated actuarial systems.Translate actuarial business requirements (BRDs) into detailed technical specifications — defining data flows, calculation chain impacts, formula applicability changes, API interactions, and integration patterns.Maintain and evolve the ACE solution architecture reference, ensuring it reflects both current state and target AWS architecture at all times.enforce architectural principles and prevent short-cuts that compromise auditability, idempotency, or data quality.Define non-functional requirements (NFRs) for each feature: performance, scalability, data retention, disaster recovery, and auditability.Actuarial ETL & Data ArchitectureThe ACE data model has seven data classes, each with different volatility, lifecycle, and governance rules:Static (ISO codes, enumerations) — lowest volatility, versioned by default, ad hoc update lifecycleMaster (Forex rates, BDP rates, Counterparty,



Reporting Hierarchy, GroupRe Treaty) — time-series, sourced from SAP and Group systemsLocal Reference (UoA, SUoA, RS, RF, AY, RP, RT) — BU-specific, medium volatilityTransaction (cashflows, actuals, opening balances, reconciliation actuals) — highest volatility, quarterly supplyGroup Reference Data (GRD) — group-wide scaling constants applied uniformly across BUsReport Configuration (formula files in Git repo) — PO-managed, IT-governed, pulled at runtimeResult Set — generated by the calculation engine, written to Delta Lake Gold layerDesign and govern ETL pipelines for all seven data classes with appropriate partitioning, versioning, and data quality controls per class.Design and review the pivot/execute/unpivot ETL pattern used by the calculation engine — ensuring it is performant, correctly scoped, and free of cyclic formula dependencies.Enforce data model standards for ACE result sets: Define data lineage, auditability, and Reverse Traceability Matrix (RTM) standards — every calculation output must be traceable to its input data, formula version, and execution context.Design self-healing pipeline patterns: retry logic, reprocess queues, custom null/NaN exception handling, and fully qualified error logging at calculation grain level.Own the Unity Catalog data sharing architecture — views, access control, and query cluster isolation between the calculation engine and external consumers.Config-as-Code & Deployment ArchitectureDesign and own the Git-based formula deployment pipeline: repository structure, branch strategy, PO-managed formula files, IT release approval gates, and Databricks runtime pickup.Define the Databricks workflow and DBT deployment pipeline via Azure DevOps, including environment promotion policies (Dev SIT UAT Prod) and full deployment auditability.Ensure all new features are designed AWS-portable from day one — no Azure-only dependencies introduced pre-migration.AWS Migration – Target Architecture (Go-Live Q1 2027)Lead architectural planning for the ACE migration from Azure to AWS — mapping current components (ADF, Azure Databricks, Azure Storage, .Net orchestration layer) to AWS equivalents.Work with the Azure Principal Architect and platform engineers to resolve cross-dependency blockers and de-risk the migration timeline.Validate that the AWS target architecture preserves all ACE design principles: idempotency, ACID compliance, self-healing, auditability, and parallel processing capability.Governance, Standards & Team EngagementEstablish and maintain Architectural Decision Records (ADRs) for all significant platform technical choices.Ensure all feature designs comply with Zurich IT governance, Cloud Centre of Excellence (CCoE) standards,



and information security requirements.As a Solution Architect – Actuarial Platform (ACE) your skills and qualifications will ideally include: Core requirements10+ years in solution architecture or data architecture; at least 3 years on data-intensive platforms in financial services, insurance, or similarly regulated industries.Hands-on expertise across the Azure data platform: Databricks (Delta Lake, Unity Catalog, PySpark), Azure Data Factory, and associated Azure storage and compute services.Practical DBT experience — DAG-based dependency resolution, model materialisation strategies, and deployment in a Databricks environment.Experience designing complex ETL pipelines with multi-dimensional data, pivot/unpivot patterns, and formula-driven transformations at scale.Multi-currency ETL — FX conversion chains, currency dimension management, and currency-specific formula handling.Strong data modelling skills: Git-based config-as-code: deploying configuration or formula files via CI/CD pipelines with branch policies, approval gates, and environment promotion.Track record delivering within regulated IT governance frameworks — architecture review boards, CCoE standards, formal change control, and audit trails.Cloud architecture certification: Azure Solutions Architect Expert or equivalent.Nice to haveAWS platform expertise and/or experience leading Azure-to-AWS migrations — directly relevant to the Q1 2027 ACE go-live. AWS Solutions Architect certification preferred.Unit of Account (UoA), Analysis of Change (AoC), valuation approaches (BBA), LRC/LIC, run types (ActClose/Preclose/FP), and BU-to-Group result aggregation.Unity Catalog governance and data sharing architecture experience.Power BI Direct Query connectivity to Databricks, including semantic model design and volumetric testing.Exposure to agentic AI or LLM integration patterns — ACE is a primary data source for Zurich's ZAAi agentic reporting platform.EducationDegree in Computer Science, Software Engineering, Data Engineering, or a related technical discipline — or equivalent demonstrated senior experience.Cloud architecture certification: Azure Solutions Architect Expert required. AWS Solutions Architect preferred.

To support your work-life balance, we have adopted a flexible working model. Over 300 euros to set up your home office and additional monthly home office allowance.Wide range of internal and external trainings, including English, German and Spanish classes depending on the needs.Ticket restaurant and Health Insurance with the flexibility to exchange it for other benefits.Collective Life retirement Plan2000 referral bonus if you bring other talented people like you to the company.Apply by sending your CV in English. We attract and retain the best-qualified individuals available, regardless of race/ethnicity, religion, gender, sexual orientation, age, or disability.

Zurich Technology Delivery

Center – Your Talent, Our StrengthWhy ZurichAt Zurich, we like to think outside the box and challenge the status quo.

Barcelona

Remote working

📌 Solutions Architect (Insurance) - Fully Remote (Barcelona)
🏢 Zurich Insurance Group
📍 Barcelona