Description

Analyze regulatory reporting requirements and source systems to ensure accurate banking regulatory submissions.

This role is on-site.

Responsibilities

• Analyze regulatory reporting requirements for Call Reports, FR Y-9C, and other banking submissions to identify data sourcing, transformations, and business rules.
• Perform detailed analysis of banking source systems to understand data structures, relationships, and reporting requirements.
• Utilize SQL extensively for data analysis, profiling, validation, reconciliation, and investigation of data quality issues.
• Develop and maintain source-to-target mappings, data lineage, data definitions, and business rule documentation.
• Conduct data profiling to assess quality, completeness, and accuracy, identifying anomalies and gaps.

Required Skills

• Advanced SQL skills with experience in data profiling, validation, and root cause investigation.
• Strong banking domain knowledge including Loans, Deposits, General Ledger, Treasury, and Risk.
• Hands-on experience with Axiom Data Sourcing and Regulatory Reporting.
• Experience supporting regulatory reports such as Call Report (FFIEC 031/041), FR Y-9C, and FR Y-14.
• Proficiency in data governance, data warehousing concepts, and source-to-target mapping.
• Ability to translate business and regulatory requirements into detailed data sourcing specifications.
• Experience performing impact analysis for source system changes and business rule modifications.
• Strong stakeholder management and documentation skills.

Preferred Skills

• 5+ years of experience in data analysis within a banking or financial regulatory environment.
• Bachelor's degree in a relevant field.

Key Skills

Education

Bachelor's degree