Lead Analyst – Transaction Testing (US Regulatory Reporting)

Own and mature a risk-based transaction testing program to ensure accuracy, completeness, and integrity of regulatory and risk reporting.

Analyze large datasets using SQL, Excel, and other tools to identify anomalies, trends, and data quality issues within financial transactions.

Communicate findings, risks, and recommendations to stakeholders and prepare standardized testing reports and workpapers per Enterprise Controls & Assurance standards.

Bachelor's Degree with minimum 4 years experience in banking/financial services analytics, audit testing, regulatory reporting or similar; or High School Diploma/GED with minimum 8 years experience.

Intermediate proficiency in SQL and Microsoft Excel for large dataset analysis.

Experience with transaction-level data profiling, data quality reviews, and regulatory reporting exposure (e.g., FR Y-14, FR Y-9C, FR 2052a).

Work Experience Required: Minimum 4 years (Bachelor's) or 8 years (High School Diploma). Notice Period: Not explicitly mentioned in the JD.

Analytical professional skilled in identifying data patterns, anomalies, and performing investigative reviews in banking transaction data.

Ability to understand and communicate complex data lineage, business logic, and regulatory requirements effectively to technical and non-technical teams.

Experienced in working independently under ambiguity and managing competing priorities within a dynamic banking regulatory environment.