Job Description

VP, System Analyst, EDW/FRR, DMO Project

Posting Date: 05-Nov-2022

Location: Singapore, SG

Company: United Overseas Bank Limited

About UOB
United Overseas Bank Limited (UOB) is a leading bank in Asia with a global network of more than 500 branches and offices in 19 countries and territories in Asia Pacific, Europe and North America. In Asia, we operate through our head office in Singapore and banking subsidiaries in China, Indonesia, Malaysia and Thailand, as well as branches and offices.
Our history spans more than 80 years. Over this time, we have been guided by our values - Honorable, Enterprising, United and Committed. This means we always strive to do what is right, build for the future, work as one team and pursue long-term success. It is how we work, consistently, be it towards the company, our colleagues or our customers.

About the Department
The Technology and Operations function is comprised of five teams of specialists with distinct capabilities: business partnership, technology, operations, risk governance and planning support and services. We work closely together to harness the power of technology to support our physical and digital banking services and operations. This includes developing, centralising and standardising technology systems as well as banking operations in Singapore and overseas branches.

Job Responsibilities
You will be directly responsible for the end-to-end software development and support for all work related to projects, quarterly change requests, L3 production fixes. This includes software product implementation and administration, application design, development, implementation, testing and support.
You will also be responsible for quality assurance of the team's delivery in conformance with the Bank-defined software delivery methodology and tools. You will partner with other technology functions to help deliver required technology solutions:

• Create frameworks, technical features which helps in faster operationalisation of Data models, Analytical models (including AI/ML) and user generated contents (dashboards, reports etc)

• Effectively partner with citizen data scientists in enabling faster adoption of AL/ML model based systems

• Independently install, customise and integrate software packages and programs

• Carry out POCs involving new data technologies

• Design and develop application frameworks for data integration

• Create technical documents such as solution design, program specifications for target solutions

• Perform design and development of applications which may not be limited to: Software Applications, Data Integration, User Interfaces, Automation

• Maintain and recommend software improvements to ensure a platform centric management of software applications

• Performance tuning for batch and online user queries

• Work with production support team members to conduct root cause analysis of issues, review new and existing code and/or perform unit testing

• Partner with BAU (L1/L2) support team to ensure system meeting with accepted SLA and continuous monitoring with batch and on-line user query performance

• Perform tasks as part of a cross functional development team using agile or other methodologies and utilising project management software

• Escalate issues that impacts project schedule on timely basis

What will help you succeed in this role

• Adopt an uncompromising attitude when it comes to quality and help raise bar of products and team members

• Be a team player who communicates effectively and professionally with both internal and external customers

• Identify ideas to improve system performance and impact availability

• Embrace tackling and resolving complex technical design issues

• Possess strong problem solving and decision-making skills while exercising good judgment

• Strong analytical and problem-solving skills

• Ability to work on multiple projects at a time

• Be able to work under pressure and manage deadlines or unexpected changes in expectations or requirements

• Good communication skills - ability to convey technical information to non-technical audience

• Ability to understand the big picture

• Ability to develop long lasting relationships with all levels

• Deep understanding and experience in software development cycle, including Agile based rapid delivery

• Collaborate with business and IT to analyse, elicit and review business requirements

• Facilitate communication between vendor, project team, business stakeholders and internal IT team

• Ability to work in a team distributed across multiple locations

Job Requirements
Functional Skills: Data Lake, EDW, Data Mart, Data Integration
Hands-on experience in implementing large scale data warehouse & analytics platforms in financial services industry; with good functional knowledge of products & services offered in Retail bank/Wholesale/Global Markets covering some of the following analytics domains:

• Experience in Data Modeling for Data Warehouse and Data Marts solutions

• Expertise in FSLDM or Dimensional models

• Experience in financial domain - Retail , Wholesale, Compliance, Digital

• Expertise in design of role based fine grained access control

• Integration of BI tools with data stores (EDW, data marts)

Technical Skills: Data Lake, EDW, Data marts, Data Integration

• Expertise in implementing Teradata based EDW and Data mart solution using ETL tool such as (Informatica Power Centre, BDM), GCFR based framework, BTEQ scripts)

• Expertise in implementing Hadoop based Data mart using Spark based framework (Java, Scala, Pyspark)

• Good knowledge and working experience in developing Teradata SQL, BTEQ scripts, data loading into Teradata using different load pattern (TPT, MLOAD, FAST Load), data compression (MVC, BLC)

• Good Knowledge and working experience in of Hadoop languages & tools - Spark, Python, R, Pig, Hue, Impala, Hive, Hbase, Informatica IDL would be an advantage

• Expertise in implementing Data Governance tools; Data Lineage (e.g. Informatica MM, EDC), Business Glossary and Data Quality

• Expertise in implementing Reference data management (Data standardization, Hierarchy maintenance) using tools (e.g. MDM,RDM)

• Good knowledge and working experience in Teradata FSLM or similar industry standard data model

• Expertise in Cloudera CDH / CDP components

• Good knowledge in developing Spark based ingestion framework (Java, Scala, Pyspark)

• Experience in building and operationalising feature pipeline to support AI/ML model execution, data pipelines for supporting large scale data warehouse/data marts

• Exposure to Data Warehouse & Big data tools for Information Management in one/more of the following areas:

• Data governance tools - Informatica EDC, DQ, MM,

• Reference Data & Hierarchy management - Teradata MDM

• RDBMS - Oracle, NoSQL

• Reporting - MS Power BI and Qlik

Technical Skills (Good to have)

• Exposure to financial services data models & data modeling tools and data governance processes would be an advantage

• Knowledge of platforms such as Kubernetes or Openshift for deploying container-based workload would be an advantage

• Experience in cloud-based deployments would be an advantage

Be a part of UOB Family
UOB is an equal opportunity employer. UOB does not discriminate on the basis of a candidate's age, race, gender, color, religion, sexual orientation, physical or mental disability, or other non-merit factors. All employment decisions at UOB are based on business needs, job requirements and qualifications. If you require any assistance or accommodations to be made for the recruitment process, please inform us when you submit your online application.

Apply now and make a difference.