Data Warehouse Support Analyst

United Overseas Bank; Kuala Lumpur; On-site; MYR 120,000 - 180,000; Full time

Job summary

Jora Malaysia is seeking an experienced Application Support professional to handle business user queries, incidents, and data-related tasks. You will analyze SQL and ETL processes, ensure timely incident resolution, and collaborate with development on production releases.

The role requires strong ITIL fundamentals, 5+ years in banking/finance IT, and hands-on experience with Teradata, Oracle/MS SQL, Unix/Linux, and Informatica. A keen eye for data quality and regulatory reporting is essential.

Qualifications

• Bachelor’s degree in computer science or related discipline.
• Minimum 5 years in application development and support in Banking/Finance, ETL, Data Warehouse and BI.
• Working knowledge of Unix/Windows, batch scheduling tools, database query skills, and BI tools.
• Strong understanding of banking products, regulatory reporting, and data lineage.
• Proficient in reading technical docs, data dictionaries and ETL job logs.
• Mandatory technical skills: Teradata, Oracle/MS SQL, Unix/Linux, AS400, Control-M, Shell scripting.

Responsibilities

• Provide application support to business users and respond to queries promptly.
• Resolve incidents to meet service level targets and ensure proper closure.
• Reverse‑engineer user queries to identify data logic and source systems.
• Analyze complex SQL, stored procedures and data models for data lineage.
• Review ETL pipelines (Informatica, SSIS) and address data quality issues.
• Support data validation, reconciliation and root-cause analysis for reports.
• Collaborate with development for production releases and change management.
• Participate in DR/BCM activities and capacity management.

Skills

Analytical thinking

Incident management

Communication skills

ITIL knowledge

SQL querying

Education

Bachelor's degree in computer science or related

Tools

Unix/Windows platforms

Control-M

Informatica

SSIS

Teradata

Oracle

MS SQL

Hadoop/Cloudera

Hive

Power BI

SSAS

Job description

Jora Malaysia will close on 9th September 2026. Thank you for being with us, we are cheering you on as you continue your career journey.

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 escape 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