Bank of America Testing Specialist in Dallas, Texas
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.
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.
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
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.)
Primary Location: US-TX-Dallas
Work Locations: TX1492 901 MAIN ST Dallas 75202
Organization: 7037-GLOBAL COMPLIANCE
Job Posting Date: Oct 25, 2016
Unposting Date: Oct 26, 2016
Hours Per Week: 40.00
Shift: 1st Shift
Req ID: 16050358