Data Operations Specialist - Investment Data 80-100%

Zurich Insurance Group

Rüti (ZH)

On-site

CHF 90,000 - 120,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Healthy food options
Fitness facilities
Bright collaborative spaces
Learning resources and on‑the‑job dev

Job summary

Zurich is seeking a Data Operations Specialist to maintain and enhance the investment data warehouse in a SQL Server environment. You will monitor Azure Data Factory pipelines, ensure data quality and collaborate with business users to improve data accessibility for investment decisions.

You will work with SQL, Python for automations, and Power BI to validate models and dashboards. The role offers a dynamic, collaborative workplace at Zurich Campus in Zurich.

Qualifications

  • 2–3 years working in data operations, BI support or data warehouse administration.
  • Experience in a production environment, including monitoring daily data loads and interfaces, handling incidents and coordinating with users.

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; run data quality checks and dashboards; investigate discrepancies and resolve issues.
  • Perform data reconciliation and resolve operational issues; optimize queries and check data consistency.
  • Interact with users to understand requirements and enhance their data experience; maintain technical documentation.

Skills

SQL
Azure Data Factory
Databricks
Python scripting
Power BI
Data Warehouse
SQL Server

Tools

Databricks
Microsoft Fabric

Job description

Do you want your data skills to have a real impact on investment decisions?

In this role as Data Operations Specialist – Investment Data, you’ll work side by side with three experienced and supportive team members who are passionate about robust, well designed data platforms. You’ll help run and improve our investment data warehouse, monitor and optimize daily data pipelines in Azure, and make sure our users have clean, consistent data at their fingertips.

You’ll get the chance to dig deep into investment data, sharpen your SQL and automation skills, and grow your experience with modern cloud data tools. If you like taking ownership, collaborating closely with business users and continuously improving how things are done, we’d be happy to hear from you

What you will do
  • 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.
    • Using established data quality checks and dashboards
    • Investigating discrepancies and escalating/solving them systematically.
    • Performing data reconciliation
  • Resolve operational issues and questions (e.g. optimize queries, missing data, check consistency)
  • Interact with users to understand the requirements and enhance their data user experience
  • Maintain technical documentation
What you bring
  • 2–3 years working in data operations, BI support or data warehouse administration (e.g. 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
    • Coordinating with users and other team members.
Domain knowledge:
  • Experience in the financial services industry or an industry with similar requirements
  • Good understanding of Investment data (e.g. securities, issuers, indices) and related structures (e.g. portfolios, holdings, company hierarchies)
Technical Skills:
  • Strong practical skills in SQL for validating data, query optimization/ performance tuning, and resolving issues.
    Familiarity with SQL Server environments and data warehouse concepts (comfortable navigating tables and structures).
  • Working knowledge of Azure Data Factory and/or Databricks: monitor pipelines and activities; restart / re-run failed jobs, read logs and identify issues.
  • Working knowledge of cloud data platforms (e.g. Databricks, Microsoft Fabric) for running jobs, checking status, and troubleshooting.
  • Handson scripting skills in Python for automation and operational tasks (e.g. log parsing, small utilities). R is a nice-to-have
  • Working knowledge of Power BI: Developing and maintaining semantic models in Power BI, validating data in the model, and implementing dashboards
You belong here.
  • Imagine working in one of the world’s most sustainable workplaces.
  • At Quai Zurich Campus, you’ll enjoy an environment designed to help you thrive, with benefits that support your well-being and impact, and opportunities to perform at your best, surrounded by top talent and supportive colleagues.
  • You’ll have access to healthy food options, fitness facilities, and bright, collaborative spaces that spark creativity.
  • Located in the heart of Zurich on the shores of Lake Zurich, the campus offers excellent public transportation links, making your commute simple.
  • Grow with us through access to learning resources, on-the-job development, and continuous empowerment and support.
  • Be part of a team that is creating a brighter future together.
About Us

Zurich is a leading multi-line insurer, serving over 82 million customers in more than 200 countries and territories with more than 65,000 employees.
For over 150 years, Zurich has been transforming insurance – offering not just protection, but also prevention services that promote well-being and climate resilience.
Guided by our purpose to ‘create a brighter future together,’ we aim to be one of the most responsible and impactful businesses in the world.

Information for recruitment agencies

Zurich does not accept any applications from recruitment agencies for this position. We refuse any responsibility for unsolicited applications, as well as any associated fees.

Why Zurich

At Zurich, we like to think outside the box and challenge the status quo. We take an optimistic approach by focusing on the positives and constantly asking What can go right?

We are an equal opportunity employer who knows that each employee is unique - that’s what makes our team so great!

Join us as we constantly explore new ways to protect our customers and the planet.

  • Location(s): CH - Zürich
  • Remote working: No
  • Schedule: Full Time
  • Recruiter name: Mélina Carnal
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Operations Specialist - Investment Data 80-100%
Data Operations Specialist - Investment Data 80-100%

Zurich Insurance Group • Zürich

Hybrid
CHF 90,000 - 120,000
Investment Data Operations Engineer
Investment Data Operations Engineer

Zurich Insurance Group • Zürich

Hybrid
CHF 90,000 - 120,000
Investment Data Operations Analyst
Investment Data Operations Analyst

Zurich Insurance Group • Rüti (ZH)

On-site
CHF 90,000 - 120,000
Healthy food options
Fitness facilities
Bright collaborative spaces
+1
Data Engineer
Data Engineer

Vontobel • Zürich

On-site
CHF 110,000 - 150,000
Head of Capital-Light Savings & Retirement 80-100%
Head of Capital-Light Savings & Retirement 80-100%

Zurich Insurance • Zürich

On-site
CHF 260,000 - 380,000
Cross-Line of Business Underwriting Product Owner 80-100%
Cross-Line of Business Underwriting Product Owner 80-100%

Zurich • Zürich

Hybrid
CHF 140,000 - 190,000
Senior Data Engineer
Senior Data Engineer

NZZone • Schlieren

Hybrid
CHF 120,000 - 180,000
Work life blend
Profit share scheme
Global and Diverse Zuhlke community
+1
Actuary - Life Reporting & Analytics 80-100%, Temporary until Sept. 2027
Actuary - Life Reporting & Analytics 80-100%, Temporary until Sept. 2027

Zurich Insurance • Zürich

On-site
CHF 140,000 - 190,000
Data Engineer
Data Engineer

Unchain Data • Zürich

Hybrid
CHF 120,000 - 170,000
International team
Travel opportunities
Flat hierarchies
+3
Investment Data Solution Engineer (m/w/d)
Investment Data Solution Engineer (m/w/d)

Zürich Versicherungs-Gesellschaft AG / Zurich Insurance Company Ltd / Zurich Compagnie d'Assurances SA • Zürich

Hybrid
CHF 120,000 - 180,000
Top locations