Data Analyst / Business Analyst – Portfolio Modeling
Zurich Insurance
full-time
Posted on:
Location Type: Hybrid
Location: Barcelona • Spain
Visit company websiteExplore more
About the role
- Support the delivery of data-centric IT products in the Group Accumulation Management area, with a focus on catastrophe portfolio modeling.
- Design and oversee data ingestion flows and transformation logic, ensuring scalability, traceability, and performance.
- Design, document, and oversee scalable data ingestion and transformation pipelines on cloud platforms (Databricks, Azure), ensuring performance and traceability.
- Collaborate with risk modelers and technical teams to define workflows for exposure data and results from catastrophe models.
- Analyze, interpret, and transform heterogeneous data sources to enable informed decision-making and regulatory compliance.
- Collaborate across functions (risk modelers, data architects, developers, risk governance) to deliver integrated data solutions.
- Facilitate and participate in agile ceremonies (sprint planning, daily stand-ups, backlog refinement, retrospective) and ensure alignment between stakeholders.
- Support development, testing, and release planning, with emphasis on performance, security, and measurable business value.
- Advocate for platform consistency and robust data architecture; liaise with Data Architects and Information Security.
- Provide functional consulting to internal consumers and data providers, driving adoption and value realization.
- Collaborate with experts across technical domains to share best practices.
- Continuously develop skills through real-world projects and contribute creatively to the team.
Requirements
- Expert knowledge of T-SQL (Transact-SQL) for complex querying, data manipulation, and performance tuning.
- Experience with data science software development (e.g., R, Python).
- Experience with data modeling (conceptual, logical, and physical) and data transformation techniques.
- Experience with data pipelines, ingestion frameworks, or ETL tools (e.g., Azure Data Factory, Databricks, Jenkins).
- Strong grounding in data modeling, data transformation, data visualization, and data governance concepts.
- Proven ability to design, document, and support data flows in modern cloud environments; comfortable with end-to-end software lifecycle.
- Experience supporting legacy platforms and running requirement-capture workshops; able to analyze existing systems and translate requirements into clear user stories and migration tasks.
- Excellent interpersonal and stakeholder management skills; able to navigate a matrixed organization and engage senior stakeholders.
- Track record of agile product delivery in technical contexts (Scrum, Kanban, or equivalent).
- Fluency in English.
- Experience coordinating UATs, releases, and performance/security validations.
- Familiarity with risk modeling or exposure data in the insurance domain is desirable.
- Nice-to-Haves: Experience with Apache Spark, Delta Lake, Databricks or similar data-platform technologies.
- Experience with catastrophe modelling platforms: RiskLink, Touchstone
Benefits
- Health Insurance with the flexibility to exchange it for other benefits
- Life and accident insurance
- Collective Life retirement Plan
- 2000 referral bonus if you bring other talented people like you to the company
- Special banking and insurance conditions plus Exclusive Employees discounts
- Functional diversity benefits
- Different social clubs such as hiking, investment, beach volley and many more
- 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.
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
T-SQLdata science software developmentRPythondata modelingdata transformationdata pipelinesETL toolsdata visualizationdata governance
Soft skills
interpersonal skillsstakeholder managementagile product deliverycommunication skillscollaborationproblem-solvingcreativityadaptabilityteamworkanalytical skills