Data Analyst

Position Overview

We are seeking a Data Analyst for a long-term role based in Atlanta, GA, specializing in banking regulatory reporting. This position involves the analysis, sourcing, profiling, and validation of data critical for regulatory submissions through platforms such as Axiom. The analyst will collaborate with various departments including Regulatory Reporting, Finance, Risk, Compliance, Business, and Technology to gather requirements and ensure precise regulatory reporting.

Responsibilities

• Analyze requirements for banking regulatory reports including Call Reports and FR Y-9C, defining necessary data transformations and business rules.
• Thoroughly examine banking source systems to comprehend data relationships and structures relevant to reporting needs.
• Leverage advanced SQL for data analysis, validation, profiling, reconciliation, and investigating data quality challenges.
• Create and maintain detailed documentation such as source-to-target mappings, data lineage, and business rule definitions supporting regulatory reporting.
• Execute data profiling to assess data quality dimensions and detect anomalies or gaps.
• Collaborate with multiple business and technical teams to clarify and finalize reporting requirements.
• Convert business and regulatory needs into actionable data sourcing specifications and mapping documentation.
• Identify and resolve data discrepancies and reporting issues by conducting root cause analyses.
• Perform impact assessments for changes in source systems or reporting requirements to maintain report accuracy.
• Support testing phases including UAT and production validations to ensure compliance and accuracy of regulatory submissions.
• Maintain data governance and audit readiness through comprehensive documentation and controls to support regulatory examinations.

Preferred Experience

• In-depth knowledge of banking domains such as Loans, Deposits, General Ledger, Treasury, Risk, and Financial Reporting.
• Experience with Axiom Data Sourcing and Regulatory Reporting tools.
• Proven history supporting regulatory reports including Call Report (FFIEC 031/041), FR Y-9C, FR Y-14, and other relevant U.S. banking reports.
• Strong expertise in advanced SQL with focus on data profiling, validation, reconciliation, quality analysis, and troubleshooting within data warehouse and regulatory reporting contexts.

Key Competencies

• Data sourcing and transformation for regulatory compliance
• Oracle SQL proficiency
• Robust data profiling and validation techniques
• Understanding of data lineage and governance principles
• Experience in source-to-target data mapping
• Knowledge of data warehouse architecture and concepts
• Requirements gathering and analysis skills
• Reconciliation and control framework expertise
• Effective stakeholder communication and management
• Strong root cause analytical skills
• Comprehensive documentation and impact analysis