In order to search for jobs specifically for CAIA Charterholders or those pursuing the CAIA Charter please enter “CAIA” in the search panel.
This will enable you to search for CAIA specific roles globally.
Your team You'll be working in the Banker Portal Business Intelligence development team in London. Our role is to provide data integration, analytics and critical reporting to senior management of the UBS Investment Banking business. You will be working very closely with key business sponsors and expected to respond quickly and professionally to varying business requests. Business management uses our products for daily financial and performance management, regulatory reporting and strategic planning.
Your expertise You must have: - Strong experience in designing real time (or close to real time) complex ETL solutions. - Excellent hands-on experience in developing ETL solutions using Informatica PowerCenter (9.x and above) - Experience to methodically identify the performance bottleneck in ETL flows and come up with appropriate solutions - In-depth knowledge of Informatica version management and release management tools - Strong experience in dimensional modelling for new applications and to extend or modify an existing application - Experience in using data modelling tools (e.g. ERWIN) - Excellent knowledge of Oracle SQL including analytic functions (Oracle 11g2 and above) - A clear understanding of Oracle features related to data warehouse, like star transformation, bitmap indexes, partition exchange etc. - Experience in automating batch jobs using scheduling tools (e.g. Autosys) - Knowledge in basic UNIX scripting to support ETL process and batch scheduling - Skill on identifying and setting up appropriate data transfer mechanisms between systems (e.g. setting up SFTP, HTTPS etc.)
Preferred and desired skills include: - Oracle PL/SQL programming - Experience in Oracle 12c or Oracle 19c - Experience in Informatica PowerCenter 10.x - Knowledge in any BI reporting tool. Preferably Business Object - BI 4.x - Experience using GitLab - Experience with Azure Cloud
About us Expert advice. Wealth management. Investment banking. Asset management. Retail banking in Switzerland. And all the support functions. That's what we do. And we do it for private and institutional clients as well as corporations around the world.
We are about 60,000 employees in all major financial centers, in more than 50 countries. Do you want to be one of us?
Join us We're a truly global, collaborative and friendly group of people. Having a diverse, inclusive and respectful workplace is important to us. And we support your career development, internal mobility and work-life balance. If this sounds interesting, apply now.
Disclaimer / Policy Statements UBS is an Equal Opportunity Employer. We respect and seek to empower each individual and support the diverse cultures, perspectives, skills and experiences within our workforce.