AVP, Data Analyst

Maybank; Kuala Lumpur; On-site; MYR 48,000 - 72,000; Full time

Job summary

Maybank is seeking a data analyst responsible for assisting in various data management tasks including SQL troubleshooting, developing shell scripts, and ensuring data quality within financial operations. The ideal candidate will have a Bachelor or Master’s in IT/Computer Science and experience in data warehousing, with strong skills in SQL, UNIX, and knowledge of banking data requirements. This role also requires the effective communication of complex data relationships and results to various stakeholders.

Qualifications

• Good understanding of data warehousing, data modeling, and reporting.
• Working experience in Financial & Banking sector.
• Ability to write and troubleshoot SQL/HQL.

Responsibilities

• Assist data management head with requests through Project Support, URS and BAU fixes.
• Develop jobs in shell scripts in Unix/Linux.
• Perform data mapping based on DWH data design.

Skills

Data Warehousing

Data Modeling

SQL

UNIX

Reporting

Education

Bachelor Degree / Master in IT/Computer Science

Tools

Hadoop

Teradata

Informatica

Job description

Job Purpose:

• Assume responsibility as data analyst to assist data management head for request coming through Project Support, URS and BAU fixes.
• Able to write, understand and troubleshoot complex business logics in SQLs/HQLs And provide RCA and also fixes to issues found.
• Write Stored Procedures, Functions SQLs and Teradata, Oracle , Hive HQLs
• Develop jobs in shell scripts in Unix/Linux
• Team player and strong communication skills in dealing with various departments or stakeholders
• Review BRD to confirm data requirements
• Cross check against Data warehouse (DWH) to confirm data availability or data gaps
• Perform data mapping based on DWH data design and model
• Perform data profiling to identify data quality issues

Accountability:

• All business requirements and necessary details for designing the solution have been capture
• All data requirements are mapped and translated to Functional Specification document (FSD) for delivery

Skills Required:

• Good understanding of data warehousing, data modeling, reporting and other relevant technical skills i.e. SQL, HQL, UNIX, Data Warehouse, Hadoop/Teradata/Informatica.
• Working experience in Financial & Banking sector

Qualifications:

• Bachelor Degree / Master in IT/Computer Science or related discipline
• Working experience in Data Warehouse banking, understanding of FSLDM model, SQL, BI, reporting tools, data modeling and design and etc or equivalent