Data Warehouse Support Analyst

A leading financial institution is seeking a Data Warehouse Support Analyst to join their highly collaborative and knowledgeable team in KL. This role offers you the opportunity to work at the heart of banking technology, supporting mission-critical data warehouse, finance, and compliance applications. You will be part of a supportive environment that values your analytical skills and technical expertise, while providing flexible working opportunities and ongoing training to help you grow professionally.

What you'll do:

As a Data Warehouse Support Analyst based in KL, you will play a pivotal role in ensuring the seamless operation of critical banking applications related to data warehousing, finance, and compliance. Your day-to-day activities will involve providing expert support to business users by addressing their queries with empathy and efficiency. You will analyse complex technical issues across various platforms—such as Oracle/MS SQL databases, Unix/Linux environments, AS400 systems—and work collaboratively with developers to resolve incidents swiftly. Your responsibilities extend beyond troubleshooting; you will also participate in capacity management by monitoring performance data and forecasting future requirements. In addition to your core support duties, you may be involved in management reporting or centrally driven project initiatives that contribute directly to organisational goals. Success in this role requires a commitment to high-quality service delivery, strong interpersonal communication skills for effective collaboration with cross-functional teams, and a proactive approach towards incident prevention.

• Provide comprehensive application support to business users by responding promptly to queries and requests, ensuring all issues are followed through to proper closure.
• Resolve reported incidents efficiently to meet service level targets, including failures and queries from both business users and technical staff as well as event alerts detected by monitoring tools.
• Reverse-engineer user queries and reports to identify underlying data logic, source systems, and transformation rules for accurate analysis.
• Analyse complex SQL queries, stored procedures, and data models to trace data lineage and logic across multiple platforms.
• Review and troubleshoot ETL pipelines using tools such as Informatica and SSIS to identify data quality issues, performance bottlenecks, or logic errors.
• Support data validation, reconciliation, and root cause analysis for discrepancies found in financial reports to ensure accuracy and reliability.
• Perform root cause analysis on incidents to identify permanent solutions that prevent recurrence and minimise impact on business operations.
• Proactively manage all incidents and problems by prioritising issues of varying severity and escalating them appropriately to relevant teams or management.
• Collaborate closely with development teams to identify resolutions for issues and facilitate smooth transitions of releases into the production environment.
• Adopt standard Incident and Problem Management workflows including timely ticket logging, defect tracking, change management processes, and quality issue communications via email.

What you bring:

To excel as a Data Warehouse Support Analyst in this financial institution’s technology team, you will bring proven experience supporting complex application environments within the banking sector. Your background should include hands-on exposure to ETL tools like Informatica or SSIS; proficiency with major database platforms such as Teradata/Hadoop/Oracle/MS SQL; familiarity with Unix/Linux operating systems; and practical knowledge of batch scheduling tools like Control-M. Your understanding of banking products—including financial instruments and regulatory reporting—will enable you to interpret user requirements accurately while supporting mission-critical systems. Strong communication abilities are essential for collaborating effectively with colleagues across business operations, support functions, development teams, and management. Your analytical approach will help you perform detailed root cause analyses that drive lasting solutions. Experience reading technical documentation further enhances your ability to troubleshoot complex issues quickly. Familiarity with ITIL or similar frameworks is beneficial but not mandatory; what matters most is your commitment to delivering dependable service through empathetic teamwork.

• Degree in computer science/engineering or related discipline is required for foundational understanding of technical concepts.
• Minimum five years’ experience in application development or support within Banking Finance environments ensures familiarity with industry standards.
• Proven hands-on experience with ETL processes (Informatica/SSIS), Data warehouse technologies (Teradata/Hadoop), BI Tools (MS PBI/SSAS), Oracle/MS SQL databases provides essential technical acumen.
• Demonstrated ability working on Unix/Linux platforms as well as batch scheduling tools like Control-M shows versatility across operating systems.
• Strong understanding of banking products, financial instruments, regulatory reporting enables effective support for business-critical applications.
• Ability to read technical documentation such as data dictionaries or ETL job logs supports thorough analysis of system behaviour.
• Excellent communication skills foster clear interactions with business users, operations staff, developers, and other stakeholders.
• Exceptional interpersonal skills promote collaborative problem-solving within diverse teams.
• Analytical mindset allows for effective root cause analysis during incident/problem management processes.
• Knowledge of ITIL or similar frameworks is advantageous for adopting best practices in incident/problem management workflows.

What sets this company apart:

This organisation stands out for its unwavering commitment to creating an inclusive workplace where every team member feels valued. The company invests heavily in training programmes designed not only to enhance technical expertise but also nurture interpersonal skills vital for success in today’s collaborative environments. Supportive leadership encourages open communication so ideas can be shared freely among colleagues who genuinely care about each other’s wellbeing. The culture here is built on trustworthiness: everyone works together towards common goals while respecting diverse perspectives from under-represented backgrounds. By joining this team you’ll have access not just to cutting-edge technology but also a network of knowledgeable professionals eager to share insights that accelerate your career progression.

What's next:

If you’re ready to make a meaningful impact within a supportive team environment while advancing your career in banking technology—apply now!

Apply today by clicking on the link provided.

Do note that we will only be in touch if your application is shortlisted.

Agensi Pekerjaan Robert Walters Sdn Bhd
Business Registration Number : 729828-T
Licence Number : JTKSM 423C