Our client, a leading global financial services company, has approximately 200 million customer accounts and does business in more than 140 countries. They provide consumers, corporations, governments and institutions with financial products and services, including consumer banking and credit, corporate and investment banking, securities brokerage, transaction services, and wealth management.

Description:
MELISSA GILES
Max Bill Rate $125/hr
12 mo, possible extension/conversion

Loans Transformation Data Analyst
**data, gap analysis, remediation, process re-design, proactive, independent

Experience
Good knowledge in Table Relationship & Data Structure and experience in writing SQL scripts to extract data from data warehouse on Oracle database Server.
Good data analytical skill and able to grasp large and complex datasets quickly and willing to pro-actively deep diving into data warehouse and systems independently to gain understanding.
Able to comprehend requirements and derive logics based on requirements.
Able to relate business & operation processes and data flow between systems to reporting metrics.
Experience in implementing Tactical solution to create and automate MI tracking metrics in a repeatable format.
Excellent in investigating data issues and propose solutions to the problems.
Able to write and maintain KOPs, data process documents and Business/Functional Requirement Documents (for strategy solutions) and create audit trail by keeping all data sources, working tools and scripts in an organised and easy accessible format.

Additional experience and knowledge for Internal Candidate
Experience in using Lynx UI, Optima Cognos Reporting Tool, CitiRisk (Facility Management, Collateral) and extracting data from Data Globe (especially data schemas: DGSTREAM, DGFU, DGREF & DGLOBE)
Good understanding on Loan data hierarchy (Request/Credit Agreement/Facility/GFRN) in Lynx.

System skills
SQL script writing.
Advanced Excel skill including writing complex formulas and Microsoft Query.
BI Tools preferable Tableau (creator).

Good to have
Understanding of trade booking & transaction lifecycle. Ideally, worked in middle office as data and metrics SME in the past.
Office VBA
MS Access
Jira (as user)

170788

Please see our complete list of jobs at:
www.rmscorp.com