Senior Analyst, Enterprise Data Platform And Datamarts

Singapore, Singapore

Job Description


Company DescriptionRHB Bank was established in Singapore in 1961 as UMBC Bank, prior to the country\'s independence in 1965. We assumed our present name - RHB Bank Berhad Singapore (RHBS) in 1999, after a series of expansions and strategic mergers. As a bank that has been here since the beginning, we have garnered invaluable experiences and insights which we turn into innovative solutions designed to help individuals and businesses grow and progress. Throughout the decades in Singapore, we have formed lifetime relationships with our clients and partners who have made us one of the most trusted financial institutions. Together with our experiences, insights and knowledge, we now cater to a cross-section of clients with requirements ranging from personal banking to corporate financing, offering seamless solutions and growing wealth for people and businesses. Our core businesses are streamlined into Retail Banking, Commercial Banking, Corporate Banking, Asset Management, offered through RHB Bank Berhad and RHB Asset Management Pte. Ltd. As a progressive and growing financial institution, RHB Singapore sees the importance for a strong collaborative and cohesive culture while welcoming diversity in views. As part of RHB\'s aim to become the employer of choice, talent and career development initiatives are put in place to ensure equal opportunities for personal development and growth among our people. We look forward to having on board talented individuals to join our dynamic and engaging team of more than 600 employees.Primary Objectives;Custodian and system expert who can advise, analyze, plan, implement, maintain, support (and retire/refresh where required) all locally hosted (On premise, Cloud) data related platforms inclusive of data lakes, data warehouses, data marts, ETL, reporting, dash boarding and analytics:Common to all Senior Analyst

  • Maintain and ensure data platforms running in production are kept running and supported in a healthy state;
  • Analyze and recommend new application and platform acquisitions to meet evolving Singapore Operation\'s needs based on capturing and documenting business requirements elicited from business stakeholders
  • Where the data platforms are in-house developed do the required coding and development, otherwise engage with 3rd party vendor to get enhancements developed and then deploy into test and prod when ready
  • Ensure IT is operated in a manner that complies with Bank Policies and frameworks, standards, circulars, guidelines and MAS regulated act, notices, circulars, and guidelines applicable to technology (Compliance, Audit, Risk Adherence). - Application and Platforms
  • Ensure IT assets are protected and secure - Applications and Platforms
  • Assist in annual budgeting - Applications and Platforms
  • Be a key stakeholder and technology partner on the bank Digital journey.
  • Foster and champion bank PRIDE values within the technology department and imbue the department with a culture of teamwork, innovation, discipline, resiliency and dedication to how work is approached.
  • Where vendor based solution approach adopted and/or outsourced approach, arrange due diligence and assessment from technology perspective on behalf of users.
  • Provide day-to-day support to business users on any data platform related system issues or constraints
  • Ensure assigned application deployments running on bank managed environments are properly QA and meet conditions.
  • Co-ordinate the setup and manage test environments to ensure business can do their enhancements and new projects testing.
Specific to Enterprise data platform and datamarts
  • Enterprise Data Platform and Datamarts: Next Generation Cloud Data lake platform, theme specific cloud data marts, on premise legacy data warehouse system, on premise staging database, custom developed ETL
Key Responsibilities;Strategy, Planning, Mgmt. Reporting
  • Provide expert advice and support to technology management in the area of expertise
  • Contribute in the formulation a comprehensive Branch IT strategy covering IT policies and procedures, security, architecture, business solutions and operational functional requirements
  • Keep abreast of developments and innovations in the FI IT landscape
  • Provide mentorship, support and guidance to colleagues, share information and facilitate problem solving
  • Contribute in the yearly budgeting for IT expenditures and investments.
IT Operations
  • Ensure data platforms running in production are healthy and functioning per expected.
  • Ensure prompt and efficient provision of IT support based on assigned area of expertise (includes request from Data center operations team)
  • Oversee contingency plans and ensure their adequacy
  • Ensure IT assets are protected and secure
  • Maintain and ensure timely renewal of digital certificates and proper lodgment with IT security team.
  • Ensure IT operations run in a manner consistent with high score from audit, risk, compliance assessments. The following to be operationalized as standard procedure against all IT asset components:
  • Administrative Accounts - All admin accounts lodged into PAM solution per group IT Security guidelines and MAS notice 655 point 4.1
  • Patching - Patch notification process established with vendors and patch calendar updated, upon patch release assessment and implementation as needed Per patching guidelines and MAS notice 655 point 4.2
  • Hardening - Per component definition and enforcement against SG security standard and Group IT Security guidelines and SG addendum/s and MAS notice 655 point 4.3
  • Network Perimeter Defense - Network traffic and segments, firewalls, proxies, dns, vpn access setup in secure manner per group IT security guidelines and MAS notice 655 4.4
  • Malware - IT Security consulted and all required IT security protections installed on IT assets per MAS notice 655 point 4.5
  • Multi-factor Authentication - MFA, where applicable implement MFA of administrative and internet accounts with access to customer information using PAM per MAS notice 655 point 4.6
  • Logging and Monitoring - Security, Capacity, Downtime, Audit
  • Capacity Mgmt. - Pre-emptive monitoring (via monitoring), planning and execution of capacity upgrades as needed
  • EOL/EOS Upgrades - Per group guidelines. Track and execute upgrades and/or do risk assessment and deviation approval.
  • Housekeeping - scripted clean-ups and truncations of logs and temp files after necessary archives executed
  • Backups - Required backup strategy per backup guidelines operationalized to central Backup Platform. Recurring scheduled backup validation activities scheduled and performed ongoing to ensure backups working per need.
  • Work with system stakeholders to ensure proper classification of system criticality and ensure design and architecture can meet the assessed criticality needs:
  • MAS 644 defined Critical system - Ensure DR setup and working and can achieve RTO within 4 hours, RPO within 2 hours and maximum unplanned downtime of not more than 4 hours per rolling 12 months;
  • MAS 644 defined non-critical system - Ensure HA/DR per stakeholder requirement.
  • BCM related activity planning and execution
  • Review and Approve/Reject production change requests as part of TCAB committee
  • Raise CAB CR as necessary
  • Cutover related planning and execution
  • Ensure and maintain adequate test environments in good working order to support enhancements and new projects;
  • Adhere to SDLC for both in-house and 3rd party solution platforms.
  • Take BAU day 2 operational ownership in terms of maintenance, support and minor enhancement ownership of new systems and/or major enhancements delivered by the Digital Delivery and DevOps team
  • Track IT related spend against budget.
  • Write Memos to authorize procurements
  • Write Memos to get deviation approvals where required.
Application and Systems Development / New Platform Acquisition
  • Lead in the requirements gathering and documentation, design and where in-house the coding, test support and implementation of new systems or enhancements of existing systems:
  • Analyze, design, document and develop technical solutions according to business requirements (or in case of off the shelf, co-ordinate with 3rd party vendor)
  • Provide accurate, complete and up to date system documentation
  • Provide training to users to ensure correct usage and proper adoption upon rollout
  • Oversee the QA of software implementation
  • Oversee the deployment and implementation of applications to run on Cloud for existing systems based on end-user needs and business rationale.
  • Assist team lead to write and table committee papers as required to get new systems and/or platforms, or major refreshes approved.
  • Write Memos to authorize procurements
  • Write Memos to get deviation approvals where required
  • Work together with Digital Delivery and DevOps team to support digital and cloud initiatives in terms of initial advisory and then follow-on necessary analysis and co- ordination/implementation related to integration requirements and enhancement required to existing data platforms to enable the digital initiative.
  • Work with Digital Delivery and DevOps team to support migration of workloads running on- premises to Cloud.
Regulatory and Procedural Expertise
  • Keep up to date and refreshed on required reading related to guiding how IT must be run in a regulated Financial institution. Minimum read list:
  • MAS Technology Risk Management Guidelines (TRMG)
  • MAS Notice 644 - Technology Risk Management.
  • MAS Notice 655 - Cyber Hygiene
  • MAS Outsourcing Guidelines
  • RHB Group IT Security Guidelines and SG addendum/s
  • SG Patching Guidelines
  • SG Backup Guidelines
  • SG Technology Department Operational Manual (OM)
  • SG IT Standard Operational Procedures (SOP), and System Manuals (SM)
  • SG Procurement Operational Manual (OM)
Other Responsibilities
  • Participate in Monthly Technology Department meetings.
  • Participate in regular Team meeting.
  • Use Department issue and work tracking platform.
  • Maintain and keep up to date team knowledge base and assist in updating team document assets such as system manual / standard operating procedures (SOP), and operations manuals
Qualifications
  • Bachelor Degree in related fields with TOGAF architecture certification /.Net developer related certification / Java developer related certification / SQL Developer related certification.
  • Minimum 5 years of experience documenting requirements, designing solutions, and coding or configuring data related platforms as part of technology department in a financial institution based in Malaysia or Singapore.
  • Minimum 3 years of experience in providing level 3 IT operations support in a financial institution based out of Malaysia or Singapore.
  • Minimum 3 Experience writing and reviewing Functional specifications, Technical design documents, interface documents.
  • Experience managing vendors.
  • Working knowledge of bank operations and products.
  • Experience in DWH schema design (on oracle, SQL Server, MySQL, PostgreSQL DB platforms), ETL and Reporting platforms.
  • Experience in agile based SDLC methodologies.
  • .Net | Java | SQL | Python | Scripting | ETL platform | Reporting Platforms development skills.
  • Technical experience in industry data management and reporting platforms such as SAP BI, Tableau, Talend, Crystal reports.
  • Hadoop, AWS EMR, Sparks platform experience.
Additional InformationRHB is a dynamic organization that promotes a work culture of high performance, where its biggest asset, the RHB-ians, are continuously developed & nurtured to their fullest potential through its robust talent management practices.At RHB, we take PRIDE in our people and our teams. Great relationships built on trust, a \'leading it right\' environment, challenging assignments and a culture of excellence are the pillars to the dynamic and diversified workplace we call home.

RHB Bank

Beware of fraud agents! do not pay money to get a job

MNCJobz.com will not be responsible for any payment made to a third-party. All Terms of Use are applicable.


Job Detail

  • Job Id
    JD1425362
  • Industry
    Not mentioned
  • Total Positions
    1
  • Job Type:
    Full Time
  • Salary:
    Not mentioned
  • Employment Status
    Permanent
  • Job Location
    Singapore, Singapore
  • Education
    Not mentioned