Z

Zurich Insurance

Global insurer providing property, casualty, life

Data Operations Specialist - Investment Data

Data EngineeringConfirmed live in the last 24 hours
Full-timeZürich, SwitzerlandNo salary listed

About the Job

Requirements

  • Two to three years of experience working in data operations, business intelligence support, or data warehouse administration, such as supporting existing data platforms, scheduled jobs, and reports.
  • Experience in a production environment, including monitoring daily data loads and interfaces, handling incidents and service requests, and coordinating with users and other team members.
  • Experience in financial services or an industry with similar requirements.
  • Good understanding of investment data, such as securities, issuers, and indices, and related structures, such as portfolios, holdings, and company hierarchies.
  • Strong practical SQL skills for validating data, query optimization and performance tuning, and issue resolution; familiarity with SQL Server environments and data warehouse concepts, including navigating tables and structures.
  • Working knowledge of Azure Data Factory and/or Databricks to monitor pipelines and activities, restart or rerun failed jobs, read logs, and identify issues.
  • Working knowledge of cloud data platforms, such as Databricks or Microsoft Fabric, for running jobs, checking status, and troubleshooting.
  • Hands-on Python scripting skills for automation and operational tasks, such as log parsing and small utilities.
  • Working knowledge of Power BI, including developing and maintaining semantic models, validating data in the model, and implementing dashboards.

Responsibilities

  • Maintain and further develop the investment data warehouse in an SQL Server environment.
  • Monitor daily data pipelines in Azure Data Factory and other solutions.
  • Ensure high data quality using the automated framework and established data quality checks and dashboards; investigate discrepancies and escalate or resolve them systematically; perform data reconciliation.
  • Resolve operational issues and questions, including optimizing queries, addressing missing data, and checking consistency.
  • Interact with users to understand requirements and enhance their data user experience.
  • Maintain technical documentation.

Desired Qualifications

  • R scripting experience is a nice-to-have.

About the Company

Zurich Insurance

Global insurer providing property, casualty, life

Zurich Insurance Group provides global multi-line insurance for individuals, families, small and mid-sized businesses, public entities, and multinational corporations in more than 200 countries. Its Property & Casualty arm covers personal lines like car and home, plus a wide range of commercial coverages (property, casualty, motor fleet, marine, construction, energy, financial lines, international programs); its Life business offers protection, savings, retirement, and unit-linked products. The Farmers Group manages Farmers Exchanges in the United States. The company also provides risk engineering and prevention services to help customers reduce risk and build climate resilience, with products sold through agents, brokers, bank partners, and direct channels. Its goal is to provide financial protection and risk management solutions that help customers manage uncertainty and build resilience over the long term.

Company size
10,001+
Company stage
IPO
Headquarters
Zurich, Switzerland
Founded
1872

Recently Posted Jobs

Explore more opportunities at Zurich Insurance

See more jobs