Senior Data Analyst
at JOOBPER PTE LTD
Singapore, Southeast, Singapore -
Start Date | Expiry Date | Salary | Posted On | Experience | Skills | Telecommute | Sponsor Visa |
---|---|---|---|---|---|---|---|
Immediate | 26 May, 2024 | USD 7000 Monthly | 29 Feb, 2024 | 3 year(s) or above | Python,Pentaho,Power Bi,Etl,It,Shell Scripting,Regulatory Reporting,Procedural,Athena,Oracle,Sql,Linux,Tableau,Functional Specifications,Design Documents | No | No |
Required Visa Status:
Citizen | GC |
US Citizen | Student Visa |
H1B | CPT |
OPT | H4 Spouse of H1B |
GC Green Card |
Employment Type:
Full Time | Part Time |
Permanent | Independent - 1099 |
Contract – W2 | C2H Independent |
C2H W2 | Contract – Corp 2 Corp |
Contract to Hire – Corp 2 Corp |
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.
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.
How To Apply:
Incase you would like to apply to this job directly from the source, please click here
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.
REQUIREMENT SUMMARY
Min:3.0Max:5.0 year(s)
Information Technology/IT
IT Software - Other
Software Engineering
Trade Certificate
Maintain and ensure timely renewal of digital certificates and proper lodgement with it security team.
Proficient
1
Singapore, Singapore