THE POSITION IS DESCRIBED BELOW. IF YOU WANT TO APPLY, CLICK THE APPLY NOW BUTTON AT THE TOP OR BOTTOM OF THIS PAGE. AFTER YOU CLICK APPLY NOW AND COMPLETE YOUR APPLICATION, YOU’LL BE INVITED TO CREATE A PROFILE, WHICH WILL LET YOU SEE YOUR APPLICATION STATUS AND ANY COMMUNICATIONS. IF YOU ALREADY HAVE A PROFILE WITH US, YOU CAN LOG IN TO CHECK STATUS.

Need Help?
If you have a disability and need assistance with the application, you can request a reasonable accommodation. Send an email to Accessibility (accommodation requests only; other inquiries won’t receive a response).

PLEASE REVIEW THE FOLLOWING JOB DESCRIPTION:

Research regulatory requirements (FFIEC 031, FR Y-9C, FR Y-14M/Q/A, FR 2052a) and develop test cases with clear pass/fail scenarios to test reporting logic and data for conformance with the requirements and identify data quality issues. Develops SQL and SAS queries to implement test cases, analyzes results, and documents findings in an audit-ready manner. The analyst collaborates with stakeholders to review results and communicate issues, support remediation, and contribute to continuous improvements and expansion of testing processes.

REQUIRED QUALIFICATIONS:

The requirements listed below are representative of the knowledge, skill and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
1. Bachelor’s degree and zero to four or more years of experience in a quantitative field such as Finance, Mathematics, Analytics, Data Science, Computer Science, or Engineering, or equivalent education and related training
2. Exhibit understanding of statistical methods, including a broad understanding of classical statistics, probability theory, econometrics, time-series, and primary statistical tests
3. Familiarity with linear algebra concepts for optimization, complex matrix operations, eigenvalue decompositions, and principal components; working knowledge of calculus/differential equations, with understanding of stochastic processes
4. Demonstrate understanding of data cleansing and preparation methodologies, including regex, filtering, indexing, interpolation, and outlier treatment
5. Strong familiarity with data extraction in a variety of environments (SQL, JQuery, etc.)
6. Working knowledge of Hadoop, Pig, Hive, and/or NoSQL, Spark
7. Experience in managing multiple projects with tight deadlines in a collaborative environment

PREFERRED QUALIFICATIONS:

• Strong knowledge of regulatory reporting requirements, (FFIEC 031, FR Y-9C, FR Y-14M/Q/A, FR 2052a).
• Proficiency in SQL and SAS for data validation and test case execution.
• Experience in conformance or data quality testing, including test case development and execution
• Ability to interpret requirements and translate requirements into SQL or SAS queries
• Strong analytical and problem-solving skills with a high attention to detail.
• Ability to work independently with minimal supervision.
• Effective communication skills with the ability to clearly present findings to stakeholders.

Following is a summary of the essential functions for this job. Other duties may be performed, both major and minor, which are not mentioned below. Specific activities may change from time to time.
1. Research and interpret regulatory requirements and instructions to inform testing activities.
2. Review reporting logic and system code for alignment with regulatory requirements.
3. Based on regulatory requirements and logic review, develop structured test scripts and design test cases with clear Pass and Fail scenarios to validate data accuracy and identify data quality issues.
4. Write and execute SQL and SAS queries to perform data validation and
confirm results.
5. Analyze and interpret test results, identify issues, and escalate findings as
appropriate.
6. Document results and observations in a clear, detailed, and audit-ready
manner.
7. Engage with stakeholders to review results and communicate findings.
8. Contribute to process improvements to enhance testing accuracy,
consistency, and efficiency.