Position Details

Type Full-Time

Experience mid

Exp. Years 0-4+ years

Education Bachelor's degree in Finance/Mathematics/Analytics/Data Science/CS/Engineering; or equivalent

Category QA & Testing

About this role

Regulatory Data Assessment Analyst - Conformance tests and analyzes FFIEC reporting data for conformance; develops SQL/SAS queries; collaborates with stakeholders to remediate data quality issues.

Key Responsibilities

Develop conformance test cases
Analyze results and identify data quality issues
Collaborate with stakeholders for remediation
Create audit-ready documentation
Expand testing processes

Technical Overview

Uses SQL/SAS/Python/R with Hadoop ecosystem to build test cases, analyzes results, and documents findings for audit readiness; supports risk management and regulatory compliance.

Ideal Candidate

The ideal candidate is a data conformance tester with strong SQL/SAS and data validation skills, able to implement tests for FFIEC-based reporting and communicate issues with stakeholders.

Must-Have Skills

Bachelor's degree and zero to four or more years of experience in a quantitative field such as FinanceMathematicsAnalyticsData ScienceComputer Scienceor Engineeringor equivalent education and related trainingUnderstanding of statistical methodsFamiliarity with linear algebra concepts; calculusData cleansing and preparation methodologies (regexfilteringindexinginterpolationoutlier treatment)Data extraction in SQLJQueryWorking knowledge of HadoopPigHiveNoSQLSparkExperience managing multiple projects with tight deadlines

Nice-to-Have Skills

Strong knowledge of regulatory reporting requirements (FFIEC 031FR Y-9CFR Y-14M/Q/AFR 2052a)Proficiency in SQL and SAS for data validation and test case executionExperience in conformance or data quality testing

Tools & Platforms

SQLSASPythonRHadoopPigHiveNoSQLSparkJQuery

Required Skills

Bachelor's degree in Finance/Mathematics/Analytics/Data Science/CS/Engineering; understanding of statistics; SQL; SAS; Python; R; Hadoop; Pig; Hive; NoSQL; Spark; data cleansing; regex; data extraction; conformance testing

Hard Skills

SQLSASPythonRJQueryHadoopPigHiveNoSQLSparkdata extraction

Soft Skills

regulatory knowledgeanalytical thinkingcommunicationstakeholder collaborationproblem solving

Certifications

Preferred

Six Sigma Green Belt

Industry & Role

Industry Banking

Job Function Develop and execute conformance tests to ensure regulatory data quality for FFIEC reporting

Role Subtype Test Analyst

Tech Domains SQL / PostgreSQL, SAS, Python, R, Hadoop, Spark

Keywords for Your Resume

regulatory data assessmentconformance testingdata validationSQLSASPythonRHadoopPigHiveNoSQLSparkFFIEC 031FR Y-9CFR Y-14MFR 2052adata qualityaudit-readystakeholder collaboration

Deal Breakers

No experience with regulatory reporting frameworks (FFIEC), No SQL/SAS experience, Inability to write SQL/SAS queries, No data validation experience

Apply for this Position →

Get matched to jobs like this

Luna finds roles that fit your skills and career goals — no endless scrolling required.

Create a Free Profile