An established financial services organization is seeking a Data Analyst in Atlanta, GA for a hybrid role focused on regulatory reporting data analysis and integration. The position supports banking reporting solutions by sourcing, profiling, validating, and transforming data to help ensure accurate and compliant submissions.
About the Opportunity:
Responsibilities:
Analyze regulatory reporting requirements for banking submissions, including Call Reports and FR Y-9C, and define sourcing and business rules.
Review banking source systems to understand data structures, relationships, and reporting dependencies.
Use SQL to perform data analysis, profiling, validation, reconciliation, and data quality investigations.
Design, develop, enhance, and support ETL workflows and mappings using Informatica PowerCenter.
Create and maintain source-to-target mappings, data lineage, ETL specifications, and documentation for reporting solutions.
Resolve data discrepancies, ETL failures, reconciliation breaks, and reporting issues through root cause analysis and data investigation.
Qualifications:
Experience in banking or financial services data analysis, with strong knowledge of regulatory reporting data processes.
- Advanced SQL skills for data analysis, validation, reconciliation, and issue investigation.
- Experience with Axiom Data Sourcing and Regulatory Reporting.
Hands-on experience with Informatica PowerCenter development.
Experience with ETL design, data profiling, and data integration in a data warehouse environment.
Experience supporting regulatory reporting solutions and related documentation.
Desired Skills:
Knowledge of banking domains such as loans, deposits, general ledger, treasury, risk, and financial reporting.
Experience supporting Basel 3 reporting.
Experience with enterprise data warehouse concepts and dimensional modeling.
Strong root cause analysis, impact analysis, and data governance skills.
