Senior Data Analyst

5-7 years
6000 - 7000 SGD monthly
18 days ago 10 Applied
Job Description

My client is an established bank with a comprehensive global network and presence.

Currently, my client is seeking for an experienced Senior Data Analyst with at least 4-5 years working in Banking and finance and with strong experience in Finance GL reconciliation and Regulatory Reporting in IT Datawarehouse Support team.

Job Description

Primary Objective:

Custodian and system expert who can advise, analyse, 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:

  • Maintain and ensure data platforms running in production are kept running and supported in a healthy state.
  • Analyse 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
  • 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.

Key Responsibilities:

Strategy, Planning, Mgmt. MIS & Regulatory 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.

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.
  • Maintain and ensure timely renewal of digital certificates and proper lodgement 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
    • Patching
    • Hardening
    • Logging and Monitoring
    • Capacity Mgmt.
    • EOL/EOS Upgrades
    • Housekeeping
    • Backups & Backup Platform.
    • 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 is working and can achieve agreed RTO & RPO
    • MAS 644 defined non-critical system - Ensure HA/DR per stakeholder requirement.
  • Handle & Support Business Continuity Management related activity planning and execution.
  • Review and Approve/Reject production change requests as part of Technology Change committee.
  • Raise Change Activity Board Change Request as necessary.
  • Cutover related planning and execution
  • Take over operational ownership of BAU in terms of maintenance, support, and minor enhancement ownership of new systems and/or major enhancements delivered by the Projects Delivery and DevOps team.

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:
    • Analyse, 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 AWS 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.
  • Work together with Projects 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.
  • Experience in supporting migration of workloads running on-premises to AWS Cloud or vice versa.

Key Criteria - Qualifications

. Diploma/Bachelor/Master's degree

  • 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.
  • Minimum 3 years of experience in providing level 3 IT operations support in a financial institution.
  • Minimum 3 Experience writing and reviewing Functional specifications, technical design documents, interface documents
  • Working knowledge of bank operations and products and with strong knowledge in Finance GL reconciliation and Regulatory reporting (MAS610, MAS645, MAS649, SDIC, etc )
  • Have experience working on VERMEG products/solutions for MAS regulatory reporting.
  • Regulatory & Procedural Expertise - Keep up to date and refreshed on required reading related to guiding how IT must be run in a regulated financial institution
  • Experience in DWH schema design (on oracle, SQL Server, MySQL, PostgreSQL DB platforms), ETL and Reporting platforms.
  • Experience in working on AWS Cloud Platform
  • Hands on skills on Linux /Unix OS
  • Hands on and strong experience in any ETL(Python, Pentaho, etc ) and BI tool ( Tableau, MS Power BI). For ETL, preferably Python.
  • Hands on experience in AWS Glue, Athena, Python, Pyspark.
  • Must have good knowledge of SQL with Hands on ability to write SQL statements and stored procedures
  • Shell scripting and Vba scripting to automate tasks.

Career Advice to Find Better