Title Financial Business/ Data Analyst (2 Positions Open)
Start Date 2017-03-17
Location NY/NJ Metropolitan Area
Job Information

POSITION TITLE: Financial Business/ Data Analyst (2 Positions Open)

LOCATION: NY/NJ Metropolitan Area

TYPE OF ROLE: Contract

US Citizens and Green Card Holders Only-No Third Party Agencies

Local Candidates Preferred

(To Apply Please click here)

If you are applicable for this position please contact Diane Katz directly: Diane.katz@primesoftinc.com


New regulatory capital rules require all bank assets to be tracked, monitored and reported in real-time by risk type. This mandated process is complicated and it prevents banks from effectively unlocking the full value of their capital. Failure to comply with capital management and reporting requirements will jeopardize banks’ continuing operations and new business activity. The FR Y-14 and DFAST reports require banks to access, validate and reconcile data from across the enterprise. This data is typically stored in multiple systems, across multiple locations, and represents varying degrees of accuracy and consistency.  Regulatory reporting, risk and finance managers are under pressure to create and deliver the reports in a timely and efficient manner, ensuring the highest levels of accuracy. They are also being challenged to build a more robust and automated framework that streamlines the process, manages ongoing regulatory updates and enhances operational efficiency.  

Summary-Our client has a huge volume of data, and they struggle to get that single source of truth from multiple systems. Their systems drive critical business processes

Job Description

Our client is looking for 2 Financial Business/Data Analysts who understand and can demonstrate their ability to use analytic tools to intelligently mine existing “big data” data sets and unlock their true potential e.g. using the same data for multiple purposes as well as have the capability to build a repeatable process for all CCAR submissions that is well documented, automated and audit-able.  The candidate should have a finance/risk background. The ideal candidate will be conversant of banking products (securities, mortgages) with excellent analytical and problem solving skills.   

The roles require the Financial Business/Data Analysts to assist with our Client’s regulation, compliance, reporting and business needs. The candidates are expected to have hands on experience culling data through advanced computerized models; extrapolating data patterns and reconciliation. The ability to reconcile large data sets using Access and Excel is also required.

In addition, the candidates will be expected to provide expertise and underlying data for various CCAR related reports and deliverables:

Report Name Report Deliverables

  • FR Y -14 M/Q Monthly & Quarterly loan and portfolio level Reports Retail and Wholesale
  • FR Y -14 Q Quarterly Actual Reports
  • Securities, pre-provision net Revenue (ppnR), Basel i, ii & iii, Regulatory Capital, operational Risk, Trading, Mortgage Service Rights (MSR), Fair Value option (FVo), Held for Sale (HFS)
  • FR Y -14 A* Annual Forecast Report Scenario, Summary, Basel i, ii & iii, Regulatory Capital, operational Risk, Counterparty Credit Risk (CCR)

Experience/Skills/Educational Requirements

  • Bachelor’s degree in Accounting/Finance/Economics
  • CPA a plus but not required
  • Knowledge of Risk and Financial Systems
  • Prior CCAR, Basel projects experience
  • Prior Financial Business Analyst/Data Analyst experience
  • Ability to identify data sources, required attribution and mitigation of gaps 
  • Ability to coordinate data sourcing and requirement across reports including FRY-9C and FRY-14 series.
  • Building and testing MS Access and Excel models
  • Constructing reporting packages in VBA
  • Building and performing reconciliations that are repeatable in nature on large datasets.
  • Understanding of databases; SQL
  • Prior Regulatory Reporting experience
  • Strong communication skills with business and technology teams
  • Experience with financial  products and process automation
  • Note: Previous experience supporting and understanding Mortgage Banking Business CCAR Y-14M Regulatory Reporting and Process is a plus

If you are applicable for this position please contact Diane Katz directly: Diane.katz@primesoftinc.com 

(To Apply Please click here)