Do you want your data skills to have a real impact on investment decisions? In this role, you’ll work alongside 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 ensure users have clean, consistent data at their fingertips. You’ll have the opportunity to deepen your investment data expertise, 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 processes, we’d be happy to hear from you.
Tasks
- 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, established data quality checks, and dashboards.
- Investigate discrepancies and escalate or solve them systematically.
- Perform data reconciliation.
- Resolve operational issues and questions, such as optimizing queries, handling missing data, and checking consistency.
- Interact with users to understand requirements and enhance their data user experience.
- Maintain technical documentation.
Requirements
- 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, and coordinating with users and other team members.
- 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).
- 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.
- Hands-on 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, validating data in the model, and implementing dashboards.
Benefits
- Work in one of the world’s most sustainable workplaces at Quai Zurich Campus.
- Enjoy benefits that support your well-being and impact.
- Opportunities to perform at your best, surrounded by top talent and supportive colleagues.
- Access to healthy food options and fitness facilities.
- Bright, collaborative spaces that spark creativity.
- Excellent public transportation links for a simple commute.
- Access to learning resources, on-the-job development, and continuous empowerment and support.
Bist du Teil dieses Unternehmens?
Dieses Unternehmensprofil wurde automatisch erstellt. Wenn du für Zürich Versicherungs-Gesellschaft AG arbeitest, kannst du das Profil jetzt beanspruchen und verifizieren – kostenlos und in wenigen Minuten.
Über uns
Das Team
You’ll work side by side with three experienced and supportive team members who are passionate about robust, well-designed data platforms.