Business Data Analyst - Loans Transformation


New York, NY
Full Time


MetricsOracleUIOnshoreFinancial servicesData flowBankingStrategyBrandIBM CognosScriptingMicrosoftWritingSQLData warehouseFacility managementDesignAnalytical skillAuditingScreenwritingDocumentationOrganizedVBAGap analysisMIMicrosoft ExcelMarketing intelligenceBusiness intelligenceJIRATransformationOERMiddle officeRisk managementData structureBusiness dataDataReportingFunctional requirementsTableau

Job Details

Grow your career as a Business Data Analyst - Loans Transformation with an innovative global bank working in New York, NY. Contract role with strong possibility of extension. Will require working a hybrid schedule 2-3 days onsite per week.

Join one of the world's most renowned global banks and trusted brand with over 200 years of continuously evolving financial services worldwide. You will work alongside some of the smartest minds in the industry who are excited to share their knowledge and to learn from you.

Contract Duration: 12 Months

Required Skills & 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 organized and easy accessible format.
  • Important Skills: Data, gap analysis, remediation, process re-design.
  • Experience in using Lynx UI, Optima Cognos Reporting Tool, risk management (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
Desired Skills & Experience
  • Tableau (Creator)
  • Understanding of trade booking & transaction lifecycle.
  • Previous experience working in middle office as data and metrics SME in the past.
  • Office VBA
  • MS Access
  • Jira (as user)

About Motion Recruitment