DWH Analyst/Developer DWH Analyst/Developer …

Schroders Investment Management
in Zurich, Zurich, Switzerland
Permanent, Full time
Be the first to apply
Schroders Investment Management
in Zurich, Zurich, Switzerland
Permanent, Full time
Be the first to apply
Schroders Investment Management
DWH Analyst/Developer
Schroders, with headquarters in London, employs over 5000 talented people worldwide, operating in 32 different countries across Europe, the Americas, Asia, the Middle East and Africa, close to the markets in which we invest and close to our clients. Schroders has developed under stable ownership for over 200 years and long-term thinking governs our approach to investing, building client relationships and growing our business.

Schroders in Switzerland is a renowned Financial Institution with around 400 employees located in Zurich and Geneva. For our private clients we provide tailor made investment solutions and complementary financial services. On behalf of institutional and retail investors, financial institutions and high net worth clients from around the world, we invest in a broad range of asset classes across equities, fixed income, multi-asset and alternatives. We also specialize in providing high-quality private equity solutions to our clients.

The DWH Analyst/Developer will be part of the Wealth Management IT Team and has the primary responsibility the analysis, design and implementation of systems or components. All focussed on banking and asset management and reporting to the Capability Lead Finance IT. To strengthen the Team we are looking for an

DWH Analyst/Developer

Areas of Responsibility
  • Review architectural plans and contribute to conceptual data modelling and data analysis
  • Analyse, implement, develop and support finance and regulatory / statutory reporting applications
  • Co-design and development of Management Information Systems; specifically Assets under Management and Revenue reporting
  • Perform functional analysis, define business requirements, data modelling, data flow and ETL design
  • Support key transformation and business projects in the context of Business Intelligence and Data Warehouse
  • Participate in the definition of the road map and future of BI & DWH in Finance across the banks and the group; leverage raw data and transform it into smart data and meaningful insights
  • Contribute to control and governance of BI & DWH
  • Work closely with finance, business, operations and development teams
  • From time to time: Take a leading role in large scale data migration projects (Design and development of bespoke ETL processes)
Core Requirements
  • BS or MS in Computing, Computer Science or related technical field (In lieu of degree, relevant skills or equivalent experience)
  • At least 3+ years of relevant work experience in Data Warehousing and Business Intelligence within the banking industry
  • Advanced SQL skills for analytical processing
  • Proficiency in data modelling (UML classes, LDM) and considerable experience with OLAP design and implementation
  • Hands on experience in ETL design and development as well as good knowledge of BI and visualization methodologies; good time management skills (able to manage timelines, dependencies, etc.)
  • Knowledge of MSSQL, SSIS, SSRS and SSAS a plus
  • Fluent spoken and written English
We offer a challenging, diverse and supportive working environment as well as modern employment conditions in an international, dynamic and entrepreneurial environment. The office is located only 5 minutes from Zurich Hardbrücke station. Please apply online with your complete application. Only direct applications will be considered .

Schroder & Co Bank AG
Human Resources
Pfingstweidstrasse 60, CH-8031 Zürich, Schweiz
Tel: +41 (0)44 250 11 11