Job Detail

We're looking for a Senior PL/SQL Developer Reporting to join us in Zurich.

• This is an exciting opportunity for someone interested in working in an international environment, while being able to interact with various stakeholders


• You'll be joining our organisation as it's transforming its architecture, pushing forward with innovative solutions in various technologies


• Work with the latest technologies and share your technical expertise in a collaborative, agile and forward thinking team environment

What you'll do

Our team is works hand-in-hand with our colleagues in Regulatory Control and Risk functions to accurately report the bank’s Financial and Risk positions. Reporting is to RBS Group oversight functions for Finance/Risk and also to various Banking Regulatory Authorities. Our main regulatory reporting logic is implemented in PL/SQL on an Oracle database. There is also a JavaScript-based front end GUI with some workflow logic where users can download reports, input manual adjustments for month-end, etc. Our team is closely involved in core reg. reporting processes and report production each month-end.

Your responsibilities will include:

• Oracle PL/SQL developer in our Regulation Reporting DWH


• Working with data from the Avaloq core banking platform to prepare regulatory returns, for UK banking regulators.


• Change-the-Bank (CtB) and Run-the-Bank (RtB) responsibility, typically in 6-month rotations


• Design including some business analysis for Regulatory Reporting / Risk Reporting projects


• Occasional customisations our Regulatory Reporting Front-end GUI using JavaScript


• Business analysis, specification, implementation of changes in the Oracle DWH for Regulatory Reporting as part of project implementations


• 3rd level support in the regulatory reporting topics


• Technical testing activities during release cycles, test support


• Consulting and support of colleagues in Financial Control

The skills you'll need

We’re looking for a self reliant and goal oriented Senior PL/SQL Developer with a strong knowledge in Oracle SQL and PL/SQL. You’ll need to have excellent analytical / problem solving skills and be quickly in understanding the root cause of issues as well as show intellectual curiosity.

We’ll also expect the role to demonstrate:

• 2+ years Oracle SQL and PL/SQL developer experience


• University degree in Computer Science / Engineering / Mathematics or similar


• Rigorously documents her/his work


• Clear and concise in communication


• Good written and spoken English


• Experience in working in an international team


• Experience of UK regulatory return themes (Central Bank Reporting, FINREP, COREP / Basel3, MLAR, PSD, CCA) is a clear advantage


• Experience of UK banking regulators (Bank of England, FCA, PRA, plus EBA) is an advantage


• Knowledge of JavaScript is an advantage


• Experience of Avaloq GUI and data model is an advantage


• Avaloq Certified Professional (ACP) accreditation is a clear advantage


• Availability to travel to the UK ca. once per year for a short trip (ca. 2 days) is an advantage.

Inclusion

At RBS, we want everyone to feel welcome, regardless of your background or needs. If you need adjustments making to your working environment, we’ll do everything we can to support you. As part of this commitment, we offer flexible working options for some of our roles.

Who we are

RBS Services (Switzerland) Ltd is an IT services and operations processing provider for Private Banking entities of the Royal Bank of Scotland Group. Our experienced teams are dedicated, determined and enthusiastic in using their capability and drive for innovation to design, build, maintain and run the delivery of an exceptional and sustainable service to Private Banking clients.

The RBS Private Banking entities offer high net worth clients a comprehensive range of private banking, wealth planning and investment management services through the Coutts and Adam & Co brands as well as to designated NatWest and RBS clients in the UK and internationally. To anticipate and respond to changing client demand, there is a growing emphasis on delivering a full range of innovative digital services.