NextRaise Logo
NextRaise
JobsDiscover rolesJob TrackerTrack applied positionsMy ResumesBuild & optimize resumes
Tools
Job Match AnalyzerPaste JD, get fit scoreATS ScoreScan for ATS issues
Chrome Extension
ResumesJobsProfile
Jobs
2 days ago
United Overseas Bank (UOB)·BFSI·2 days ago
2 days ago

Data Warehouse Support Analyst, GIPS

The Gardens North TowerMid · 2-5 years

Sign up free to see how well your resume matches this role.

About this role

Company: 6255 UOB Innovation Hub 2 Sdn Bhd

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.

Job Description

Key Responsibilities:

  • Provide application support to various business users.  Attend to business queries and business requests promptly. Follow through the business requests to a proper closure.

  • Work on timely resolution for reported incidents to meet service level targets. Incidents include failures & queries reported by business users and technical staff; event alerts automatically detected and reported by event monitoring tool

  • Reverse-engineer / users queries and reports to identify underlying data logic, source systems, and transformation rules.

  • Analyze and interpret complex SQL queries, stored procedures, and data models to trace data lineage and logic.

  • Review and troubleshoot ETL pipelines (Informatica, SSIS) to identify data quality issues, performance bottlenecks, or logic errors.

  • Support data validation, reconciliation, and root cause analysis for data discrepancies in financial reports.

  • Perform root cause analysis to identify permanent solution to prevent recurring incidents and to minimize the impact of incidents that cannot be prevented

  • Ensure all incidents and problems are proactively managed – Prioritizing numerous issues of varying severity and escalate issues as appropriate to necessary teams and management

  • Collaborate with the development team in identifying resolutions and transitioning of releases into production environment

  • Adopt standard Incident and Problem Management workflow and processes, i.e timely ticket, defect and incidents loggings including proper change management processes and quality issue/impacts emails

  • Participate in DR/BCM activities or infrastructure related upgrade

  • Responsible of capacity management.  To monitor & analyse current performance and capacity data and forecast the capacity required by the applications ahead

  • Aside from day-to-day support duties, there will be requirements to undertake other responsibilities such as management reporting & other centrally driven project initiatives as needed

Key Requirements:

  • Degree in computer science/engineering or related disciplines.

  • Minimum 5 years of experience in application development and support environment in Banking Finance, ETL (Extract, Transform, Load), Data warehouse, and business intelligence

  • Must have working experience in Unix/Windows platforms, batch scheduling tools, Database query skills, BI Tools skillsets

  • Strong understanding of banking products, financial instruments, and regulatory reporting.

  • Ability to read and interpret technical documentation, data dictionaries, and ETL (Extract, Transform, Load) job logs.

  • Mandatory Technical skills: Teradata, Oracle / MS SQL, Unix/Linux, AS400, Control-M, Shell scripting

  • Hands on experiences in Teradata, Hadoop Big Data using Cloudera (CDH 5.8 or above), Hive, MS PBI, SSAS, Informatica.

  • Knowledge of ITIL of similar framework will be advantage.

  • Excellent & proven experience in Incident/Problem Management and organization skills

  • Excellent communication, interpersonal and analytical skills

  • Excellent knowledge of front to back banking business, finance, risk and accounting data across various sectors

Additional Requirements

Be a Part of the 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

BFSIH1B sponsor likely
AI tools
Apply faster with autofillThe NextRaise extension autofills your application in one click.Get the extension

Similar jobs

  • Senior Officer, Engineering Support Analyst (Identity Management) at United Overseas Bank (UOB)Central Region (City Area)
  • PMO Support Analyst at Accenture
  • Customer Service Senior Analyst at Accenture
  • Support Operations Specialist at oneimagingRemote
  • Tech Support Analyst - NYC (onsite) at Accenture
  • Strategy & Consulting - Global Network - SONG - Service - Cloud Contact Center Analyst at Accenture