Bank of America Testing Specialist in Dallas, Texas

Testing Specialist


The Testing Specialist , under supervision, conducts independent transactional and process testing on a team in support of needs identified by Compliance and Operational Risk Officers. A test is defined in the Independent Testing Enterprise Policy as “an independent point-in-time examination of one or more processes, controls, policies and procedures or data sources utilized for managing risk to assess the effectiveness of the control environment. A test is focused on answering a specific objective and has a pre-defined pass/fail criteria.” Compliance testing may include activities such as automated surveillance and transaction level testing and may be performed onsite.

The Testing Specialist is accountable for quality testing execution, reporting and analysis of results. This role may participate in test script development and test design. The Testing Specialist contributes to the identification of themes and trends at the front line unit, control function and enterprise level. This role is an individual contributor in the Test Execution function.

Responsibilities include:

Candidate must exhibit an exceptional degree of ingenuity, creativity, and resourcefulness. They will apply and/or develop highly advanced data access routines to extract data from source systems for monitoring operations compliance to banking Laws, Rules and Regulations. Often acts independently to uncover and resolve issues associated with finding data that can be used by Compliance Testers to monitor operational compliance. Serves as a consultant to Test Designers to ensure appropriate data filters are applied based on business/product needs. Expert with Visual Basic Apps (VBA), SQL Server SSIS, SAS and SQL.

Provides analytical support in EIT activities related to multiple Compliance Control Functions. Gathers and organizes data in order to track, report and monitor effectiveness of controls and tracking, monitoring, and escalation of risk related issues to management. Investigates data attributes within various operational and reporting databases. Builds logics for automated data extraction and validation for EIT testing. Acts as subject matter expert on data mining, code development, quantitative tools, and automated reporting. Works within the policies and standards regarding sampling methodologies. Thoroughly documents operating procedures for sampling execution.


Required skills

Minimum 2 years experience with SQL Server Management Studio, SAS or similar database query/data mining tool

Proficiency with MS Office suite with an emphasis on Excel to perform data analytics, pivot tables, lookups and external data source connections

Strong familiarity with data warehousing and mining concepts

Ability to deliver high-quality results in a stressful environment and comfortable managing, manipulating and summarizing large quantities of data

Excellent verbal and written communication as well as interpersonal skills

Strong research and analytical skills

Self starter, organized, versatile, capable of performing work independently with minimal direction. Ability to think independently, solves problems, and develops solutions

Minimum 5 years business and functional experience

Bachelor's degree or equivalent

Desired skills

Proficiency in SQL, Transact SQL, SAS, writing stored procedures, functions and statements for data transformation and manipulation

Proficiency designing and developing Extract, Transform and Load (ETL) packages preferably in SQL Server Integration Services

Bachelor's degree preferably in a business, financial or computer science discipline

Risk management, Compliance and/or Audit experience

Systems experience (iSeries DB2, Teradata, Oracle etc.)

Job: KC-Compliance

Primary Location: US-TX-Dallas

Work Locations: TX1492 901 MAIN ST Dallas 75202

Organization: 7037-GLOBAL COMPLIANCE

Travel: No

Job Posting Date: Oct 25, 2016

Unposting Date: Oct 26, 2016

Full/Part-time: Fulltime

Hours Per Week: 40.00

Shift: 1st Shift

Req ID: 16050358