Regulatory Data Assessment Analyst

About This Role

The Regulatory Data Assessment Analyst will research and interpret regulatory requirements for financial reporting, develop and execute test cases using SQL and SAS to validate data accuracy, and document audit-ready findings. This role involves collaborating with stakeholders to communicate issues and contribute to continuous improvement of testing processes.

Responsibilities

• Research and interpret regulatory requirements (FFIEC 031, FR Y-9C, FR Y-14M/Q/A, FR 2052a) to inform testing activities.
• Review reporting logic and system code for alignment with regulatory requirements.
• Develop structured test scripts and design test cases with clear Pass and Fail scenarios to validate data accuracy.
• Write and execute SQL and SAS queries to perform data validation and confirm results.
• Analyze and interpret test results, identify issues, and escalate findings.
• Document results and observations in a clear, detailed, and audit-ready manner.
• Engage with stakeholders to review results and communicate findings.
• Contribute to process improvements to enhance testing accuracy, consistency, and efficiency.

Requirements

• Understanding of statistical methods: classical statistics, probability theory, econometrics, time-series, primary statistical tests.
• 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.
• Understanding of data cleansing and preparation methodologies (regex, filtering, indexing, interpolation, outlier treatment).
• Strong familiarity with data extraction in a variety of environments (SQL, JQuery).
• Working knowledge of Hadoop, Pig, Hive, and/or NoSQL, Spark.
• Experience in managing multiple projects with tight deadlines in a collaborative environment.

Qualifications

• Bachelor's degree in a quantitative field such as Finance, Mathematics, Analytics, Data Science, Computer Science, or Engineering, or equivalent education and related training
• Zero to four or more years of experience in a quantitative field for Level 1; four or more years of experience for Level 2.

Nice to Have

• 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 them into SQL or SAS queries.
• Strong analytical and problem-solving skills with high attention to detail.
• Ability to work independently with minimal supervision.
• Effective communication skills with ability to present findings to stakeholders.
• Master’s degree or PhD in a quantitative field (for Level 2).
• Previous experience in the banking or fin-tech industry (for Level 2).

Skills

* Required skills

Benefits