View Job

Compliance Test Designer / SQL Specialist

Bank of America | Jersey City NJ 07310 USA | Full Time | Posted: 03/24/2020

Job Descriptiontop

Job Description:

The Sample and Test Designer, under supervision, works in collaboration with the Test Owners, Front Line Units, other Sample and Test Development resources and the Test Execution Teams to design both manual and automated tests.  They will make required changes to new and existing test scripts and the associated sample and data requirements for test populations and samples.

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. 


  • Own and execute the end to end design of new and/or modified test plans, scripts and associated documentation in collaboration with the Test Owner and Test Development Manager, ensuring compliance with enterprise testing standards and policies.
  • Gathering test scripting and data requirements, working with data partners to ensure appropriate sampling requirements are incorporated in to the Test Plans, developing the logic required for providing samples for tests, distribution of sample for testing and resolution of any issues encountered in executing scripts.  Responsible for accessing pertinent databases or acquiring raw data from third party sources along with all associated documentation.
  • Candidate must exhibit an exceptional degree of ingenuity, creativity, and resourcefulness.
  • Often acts independently to uncover and resolve issues associated with procurement of data to be used for testing.
  • Partner with Test Development Manager and Test Owners to interact with Line of Business partners to facilitate test design.
  • Maintain SOR (System of Record) tracking of test status per standards.
  • Provide training to the test execution team on test process including changes and enhancements to the test plan and the test script.
  • Evaluate if pilot testing is required and participate in testing as needed.
  • Participate in other phases of testing (intake, execution, reporting) to provide expertise and feedback on areas assigned.
  • Delivering high-quality results and managing, manipulating and summarizing large quantities of data.
  • Incorporate automation during test development using effective and efficient technologies, where possible

Required Skills and Experience: 

  • Bachelor's degree or equivalent experience
  • 2+ years experience with an internal audit, testing, risk management, process improvement, compliance, or front line control role
  • 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
  • Baseline understanding of SAS/SQL query language and syntax
  • Ability to communicate complex technical concepts with non-technical business partners, in order to develop populations for testing
  • Demonstrated project management skills; Ability to handle multiple competing priorities with demonstrated success at achieving SLA (Service Level Agreements)
  • Strong partnership and influencing skills
  • Strong research and analytical skills
  • Strong verbal and written communication skills as well as interpersonal skills
  • Self-starter, organized, versatile, capable of performing work independently with minimal direction
  • Ability to think independently, solve problems, and develop solutions
  • Demonstrated ability to interface effectively with Senior management
  • Strong team player

Desired Skills and Experience:

  • Experience in Enterprise Control functions and related compliance efforts
  • Risk management, Compliance and/or Audit experience
  • 1+ years working within a financial institution or Big 4 consulting
  • Compliance or Risk certification a plus
  • Diverse experience across multiple lines of business and functions
  • Strong familiarity with sampling business requirements and test design
  • Strong familiarity with data warehousing and mining concepts
  • Intermediate to expert understanding of SAS/SQL query language and syntax
  • Experience building data acquisition routines in a tool such as Trifacta, Alteryx, Microstrategy, Tableau, Cognos (or other similar business intelligence applications)
  • Experience building queries to source data from a variety of different types of data sources such as DB2, Teradata, Oracle, SQL Server, Hadoop, Hive

Enterprise Role Overview

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. 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.


1st shift (United States of America)

Hours Per Week:


Job Detailstop

Location Jersey City, NJ, 07310, United States
Categories Education/Instructor/Training

Location Maptop

Contact Informationtop

Contact Name -
How to apply Employer provided a link where your application will be accepted. Click on the link below and follow instructions.
Apply Click Here (apply to job)
Job Code 19066782

Featured Employers - view all