Data Analyst

Description

Queries, analyzes, and interprets complex data stored in DB2 and Oracle databases.o Detects, documents, and recommends approaches for handling data quality issues. Understand the information storage structure in the different System of Records and map them to a structure compatible with target application and prepare the high level data model Data mapping & transformation o Maps data attributes from existing sources to the target reporting data model.o Identifies gaps between the target reporting data model and the required attributes identified by business users.o Articulates data derivation or transformation rules in business terminology. Uses Microsoft Office tools for use in documentation, presentations, etc. Writes SQL queries, using standard query tools such as TOAD and QMF. Detects, documents, and recommends approaches for handling data quality issues. Articulates data derivation or transformation rules in business terminology. Uses Microsoft Office tools for use in documentation, presentations, etc. Understand the information storage structure in the different System of Records and map them to a structure compatible with target application and prepare the high level data model application and prepare the high level data model Data mapping & transformation Maps data attributes from existing sources to the target reporting data model. Database Management Must Have Soft Skills/Experience (i.e. communications, environment) Strong communication, organizational, interpersonal, time management skills. Well presented and ability to work with minimal direction or supervision independently in a team setting and dynamic environment.Strong DB modeling and data analysis skills are the must Nice to Have Skills/Experience Banking Domain knowledge and specifically on the loan processing areas