Data Warehouse Support Analyst – GIPS (Banking BI)

United Overseas Bank

Malaysia

On-site

MYR 90,000 - 140,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Qualifications

  • Minimum 5 years of experience in application development and support environment in Banking Finance.
  • Mandatory Technical skills: Informatica, Oracle / MS SQL, Unix/Linux, AS400, Control-M, Shell scripting.
  • Ability to read and interpret technical documentation, data dictionaries, and ETL (Extract, Transform, Load) job logs.
  • Hands on experiences : Teradata, Hadoop Big Data using Cloudera (CDH 5.8 or above), Hive, MS PBI, SSAS will be added advantage.
  • 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.
  • 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

Responsibilities

  • Provide data support to business users and handle queries promptly.
  • Resolve incidents to meet service level targets and document outcomes.
  • Reverse‑engineer user queries to identify data logic and source systems.
  • Analyze SQL queries, data models, and data lineage.
  • Review ETL pipelines (Informatica, SSIS) for data quality and performance.
  • Support data validation, reconciliation and root-cause analysis.
  • Participate in DR/BCM activities and capacity management.
  • Maintain proactive incident and problem management workflows and change logs.
  • Collaborate with development teams for release transitions into production.
  • Undertake management reporting and other centrally driven project initiatives as needed.

Skills

Informatica
Oracle
MS SQL
Unix/Linux
AS400
Control-M
Shell scripting
Teradata
Hadoop
Cloudera
Hive
Power BI
SSAS
BI Tools

Education

Degree in computer science/engineering

Tools

Teradata
Hadoop
Cloudera
Hive
Power BI
SSAS

Job description

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:
  • Providing data support to various business users. Attend to business queries and business requests promptly. Follow through the business requests to a proper closure.

  • Working 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 elevate 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

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

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

  • Hands on experiences : Teradata, Hadoop Big Data using Cloudera (CDH 5.8 or above), Hive, MS PBI, SSAS will be added advantage.

  • 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.

  • 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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Warehouse Support Analyst, GIPS
Data Warehouse Support Analyst, GIPS

United Overseas Bank • Malaysia

On-site
MYR 90,000 - 140,000
Data, Finance & Compliance Support Analyst
Data, Finance & Compliance Support Analyst

UOB • Kuala Lumpur

On-site
MYR 80,000 - 100,000
Data, Finance & Compliance Support Analyst
Data, Finance & Compliance Support Analyst

United Overseas Bank Limited • Malaysia

On-site
MYR 120,000 - 180,000
Senior Analyst, Data
Senior Analyst, Data

United Overseas Bank Limited • Malaysia

On-site
MYR 120,000 - 180,000
Business Analyst – IDM Engineering, GIS
Business Analyst – IDM Engineering, GIS

UOB • Kuala Lumpur

On-site
MYR 80,000 - 100,000
Technical Delivery Manager (Informatica) , PRO
Technical Delivery Manager (Informatica) , PRO

UOB • Kampung Malaysia Tambahan

On-site
MYR 150,000 - 230,000
Banking Data & ETL Support Analyst
Banking Data & ETL Support Analyst

United Overseas Bank Limited • Malaysia

On-site
MYR 120,000 - 180,000
IDM Engineering Analyst
IDM Engineering Analyst

UOB • Kuala Lumpur

On-site
MYR 120,000 - 180,000
VP2 - Specialist, Application Monitoring & Dashboard Analytics
VP2 - Specialist, Application Monitoring & Dashboard Analytics

United Overseas Bank Limited • Malaysia

On-site
MYR 90,000 - 150,000
IDM Engineering Analyst
IDM Engineering Analyst

UOB • Kampung Malaysia Tambahan

On-site
MYR 120,000 - 180,000