Skip navigation
Risk Data Analyst (12434)

Risk Data Analyst (12434)

Job Description

Bishop & Co. is seeking candidates for a Risk Data Analyst opportunity with a company in Honolulu.
This is a direct hire position with benefits.

**Only in-state applicants will be considered**

Position Summary:

To accomplish data extract, transform, load activities, perform data, manipulation, staging, scrubbing and conversion of data for use in risk modeling. Under the direction of a risk modelers or analysts, prepares requests to extract and format production data for use in risk modeling activities. Maintains the DFAST assemblage spreadsheets and ensures accuracy through financial reconciliation with data sources including, but not limited to the Call Reports, G/L, ECC/RMDW, legacy systems, regulatory reporting templates, and others, as required. Also, under the direction of a Senior Risk Analyst, performs data profiling activities in support of CCAR.


Core Responsibilities:

1. Provide Extract, Transform, and Load (ETL) data management support for risk modeling activities.

  • Collects and organizes data into data vectors as specified by modeling staff.
  • Creates repeatable and documented processes for data collection including data extraction, manipulation, scrubbing, reconciliation, or merging/conversion.
  • Collaborates on the establishment and implementation of internal controls for data stored and used for risk modeling purposes
  • Drafts precise, comprehensive, and auditable documentation regarding data, systems, programs, controls, and resulting outcomes.
  • Ensures all documentation complies with regulations and relevant Bank procedures such as the software development lifecycle standards.
  • Produces output files in Excel, text, CSV or other technical environments, as specified.


2. Maintains and enhances, as approved, the DFAST Assemblage environment.

  • Performs detailed financial level analysis and reconciliation to ensure data accuracy for regulatory reporting and management reporting.
  • Maintains a development, test, and production environment for the Assemblage environment to ensure strict testing and change control.
  • Produces reports, graphs, and charts, and when required, merge these results with their corresponding textual information for reporting purposes.
  • Works with counterparts to install, test, and implement approved changes to the Assemblage environment.
  • When requested, designs, tests, and implements changes requested by project requestors.

3. Conduct data profiling activities in support of CCAR data analysis.

  • Under the direction of a Risk Analyst and within the confines of the CCAR regulation, create and execute data extracts to assist in the analysis of data portfolios in production systems.
  • Performs financial summarization and reconciliation to enable other risk management staff to write specifications for CCAR data extraction for compliance purposes.
  • Prepares documentation in support of CCAR data specifications.

Job Requirements


  • Bachelor’s degree in business, economics, finance, IT or a related field; Master’s degree preferred.
  • Minimum 3-5 years’ IT or related experience, including data management, data administration, relational databases.
  • Experience working with MS SQL Server and/or, MS Access.
  • Ability to write and execute SQL queries for data retrieval.
  • Experience with various industry-standard file types – mainframe and PC including COBOL, CSV, TXT, and SQL.
  • Demonstrable knowledge and experience of software development lifecycle and methodologies spanning development, testing, release and deployment.
  • Experience interacting with enterprise-wide data warehouses, legacy systems, data marts, or business intelligence systems.
  • Deep experience with EXCEL and MS-Access with the demonstrated skill to handle complex data worksheet design, macros, functions, and pivot tables. Experience with linked spreadsheets in a production environment a plus
  • Experience and/or exposure to SAS, Oracle, SQL Server, Informatica, Hyperion, or other industry standard data integration and management tools, a plus
  • Must have experienced multiple full project lifecycles from business development to final delivery.
  • Must have worked with a team of individuals with multi-disciplinary backgrounds.
  • Ability to read code and/or specifications for database, file and record definitions.
  • Sufficient experience to understand large-scale, commercial application packages.
  • Exposure to the R modeling environment preferred, but not required.
  • Experience in the banking/financial industry is preferred, but not required.


Bishop & Company provides recruiting and placement services for client companies and job seekers for opportunities throughout Hawaii, with emphasis on executive search, direct hire, temp to hire, and temporary/contract staffing . We charge no fees to our placed candidates and our temporary/contract employees. Our client services are 100% guaranteed.


Please forward resumes to: [Click Here to Email Your Resumé]
Phone: 808-839-2200
Fax: 808-839-4844

***No relocation, In-state applicants only. Must be available to interview immediately.*** EEO/AA/DISABLED/VETS

Job Snapshot

Employment Type Full-Time
Job Type Banking, Accounting, Information Technology
Education 4 Year Degree
Experience At least 3 year(s)
Manages Others No
Relocation No
Industry Banking - Financial Services
Required Travel Not Specified
CareerBuilder Tip:
For your privacy and protection, when applying to a job online, never give your social security number to a prospective employer, provide credit card or bank account information, or perform any sort of monetary transaction. Learn more.

By applying to a job using you are agreeing to comply with and be subject to the Terms and Conditions for use of our website. To use our website, you must agree with the Terms and Conditions and both meet and comply with their provisions.

Risk Data Analyst (12434)

Enter notes about this job: