Senior Executive, Data Analyst (Data Management)

GoKardz Technologies; Kuala Lumpur; On-site; MYR 50,000 - 70,000; Full time

Job summary

GoKardz Technologies in Kuala Lumpur is seeking a skilled Data Analyst to support various data management initiatives. The role includes writing and troubleshooting complex SQL/HQL business logic, developing scripts in Unix/Linux, and ensuring all data requirements are accurately documented and met.

Ideal candidates should have 3-5 years of experience in data warehousing and a strong understanding of financial and banking data models. Responsibilities also include reviewing BRDs, performing data profiling, and delivering comprehensive documentation.

Qualifications

• 3-5 years of working experience in Data Warehouse banking, BI, and reporting tools.
• Good understanding of data warehousing and data modeling.

Responsibilities

• Assume responsibility as a data analyst to assist data management head.
• Develop jobs in shell scripts for Unix/Linux.
• Perform data mapping and data profiling.

Skills

SQL

HQL

Unix/Linux

Data Warehouse

Teradata

Informatica

Data Modeling

Reporting

Education

Bachelor Degree in IT/Computer Science

Master's Degree in IT/Computer Science

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.

Accountability

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

Supporting Activities

• 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

Outcome/ Deliverables

• Business Requirement Document


• Updated DWH data mapping document and script


• Outputs as per business expectations

Challenges

• Understanding of business demand and target objectives


• Familiarity to the DWH data model and data mapping document

Skills Required

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

Qualifications

Bachelor Degree / Master in IT/Computer Science or related discipline.

3 years – 5 years Working experience in Data Warehouse banking, BI, reporting tools, data modeling and design and etc or equivalent.