Description

Key Responsibilities:

• Analyze regulatory reporting requirements for reports such as Call Reports, FR Y-9C, and other banking regulatory submissions, and identify required data sourcing, transformations, and business rules.
• Perform detailed analysis of banking source systems to understand data structures, data relationships, and regulatory 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 for regulatory reporting solutions.
• Conduct data profiling to assess data quality, completeness, accuracy, and integrity, and identify data anomalies and gaps.
• Collaborate with Regulatory Reporting, Finance, Risk, Compliance, Business, and Technology teams to gather and clarify reporting requirements.
• Translate business and regulatory requirements into detailed data sourcing specifications, mapping documents, and functional requirements.
• Analyze and resolve data discrepancies, reconciliation breaks, and reporting issues through root cause analysis and data investigation.
• Perform impact analysis for source system changes, business rule modifications, and regulatory reporting enhancements to ensure downstream reporting accuracy.
• Support testing, UAT, production validation, and monthly release activities to ensure accurate and compliant regulatory report submissions.
• Ensure compliance with data governance, audit, and regulatory requirements by maintaining comprehensive documentation, controls, and supporting examination requests.

Preferred Experience

• Strong banking domain knowledge, including Loans, Deposits, Customer, General Ledger, Treasury, Risk, and Financial Reporting data.
• Hands-on experience with Axiom Data Sourcing and Regulatory Reporting.
• Experience supporting regulatory reports such as Call Report (FFIEC 031/041), FR Y-9C, FR Y-14, and other U.S. Banking Regulatory Reports.
• Advanced SQL skills with experience in data profiling, data validation, reconciliation, data quality analysis, and root cause investigation in Data Warehouse and Regulatory Reporting environments.

Key Skills

• Data Sourcing for Regulatory Reports
• Oracle SQL
• Data Profiling & Data Validation
• Data Lineage & Data Governance
• Source-to-Target Mapping
• Data Warehouse Concepts
• Requirements Analysis
• Reconciliation & Control Frameworks
• Stakeholder Management
• Root Cause Analysis
• Documentation & Impact Analysis

Key Skills

Education

Bachelor's degree