Senior Data Analyst

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 capture

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