Data Warehouse Support Analyst, GIPS
United Overseas Bank Open At a glance
Mid-level Data Engineering role at United Overseas Bank. The Gardens North Tower · full-time.
Pay not stated Data Engineering salary
dataroles summary, based on the employer's posting.
What you'll do
- Resolve user requests and reported data incidents promptly, tracking each issue through to closure and service targets
- Trace report and query logic through SQL, stored procedures, data models, source systems and transformations
- Troubleshoot Informatica and SSIS pipelines, validate financial data, and investigate discrepancies to find root causes
- Prioritize and escalate incidents, coordinate fixes and production releases with developers, and document changes
- Track application capacity and performance, support disaster recovery activities, and contribute to reporting and project work
What you bring
- A degree in computer science, engineering or a related discipline
- At least five years supporting or developing applications across banking finance, ETL, data warehousing and business intelligence
- Hands-on ability with Informatica, Oracle or MS SQL, Unix or Linux, AS400, Control-M and shell scripting
- Experience with Unix or Windows, batch scheduling, database queries and BI tools, plus strong incident and problem management skills
Who this fits
This role suits a mid-level data support professional who can investigate data flows, resolve production issues and work with business users and development teams. You’ll work from The Gardens North Tower in Malaysia.
From the employer
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 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
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.
Apply now and make a Difference
Data Engineering work from LinkedIn, X, Reddit and Upwork, in one list.
Each morning you get everything that fits, strongest first.
Data Engineering
Find me workBy the team behind dataroles.