Summer Banking Data Analyst Jobs (NOW HIRING)

Only W2 profiles
Location: Atlanta, GA (Onsite)

We are seeking a highly skilled Data Analyst with expertise in Axiom Regulatory Reporting to support a leading banking client. The ideal candidate will be responsible for analyzing, sourcing, profiling, validating, and reconciling data used in U.S. banking regulatory reports, including Call Reports (FFIEC 031/041), FR Y-9C, FR Y-14, and other regulatory submissions.

This role requires strong experience in banking data analysis, advanced SQL, regulatory reporting, and data warehouse environments. The successful candidate will collaborate with Regulatory Reporting, Finance, Risk, Compliance, Business, and Technology teams to ensure accurate, timely, and compliant regulatory reporting.

• Analyze business and regulatory reporting requirements for reports such as Call Reports (FFIEC 031/041), FR Y-9C, FR Y-14, and other U.S. banking regulatory filings.
• Identify and document data sourcing requirements, business rules, transformations, and reporting logic required for regulatory reporting solutions.
• Perform detailed analysis of banking source systems to understand data structures, relationships, and reporting dependencies.
• Utilize Oracle SQL extensively for data extraction, profiling, validation, reconciliation, and investigation of data quality issues.
• Develop and maintain source-to-target mapping documents, data lineage, business rules, and technical documentation.
• Conduct comprehensive data profiling to assess data quality, completeness, consistency, and integrity.
• Collaborate with Regulatory Reporting, Finance, Risk, Compliance, Business, and Technology teams to gather, analyze, and validate business requirements.
• Translate business and regulatory requirements into functional specifications, mapping documents, and data sourcing requirements.
• Investigate and resolve data discrepancies, reconciliation breaks, and reporting issues through root cause analysis.
• Perform impact analysis for source system changes, regulatory updates, and business rule modifications to ensure downstream reporting accuracy.
• Support System Integration Testing (SIT), User Acceptance Testing (UAT), production validation, and monthly release activities.
• Ensure compliance with regulatory, audit, and data governance standards by maintaining complete documentation and supporting regulatory examinations.

• Strong experience as a Data Analyst within the Banking or Financial Services industry.
• Hands-on experience with Axiom Data Sourcing and Axiom Regulatory Reporting.
• Experience supporting U.S. banking regulatory reports, including:
  • Call Report (FFIEC 031/041)
  • FR Y-9C
  • FR Y-14
  • Other regulatory reporting submissions
• Advanced proficiency in Oracle SQL for:
  • Data analysis
  • Data profiling
  • Data validation
  • Data reconciliation
  • Data quality assessment
  • Root cause investigation
• Strong understanding of Data Warehouse concepts, data modeling, and regulatory reporting environments.
• Experience creating and maintaining:
  • Source-to-Target Mapping
  • Data Lineage
  • Data Definitions
  • Business Rules Documentation
• Excellent analytical, troubleshooting, and problem-solving skills.
• Strong communication and stakeholder management abilities with experience working across business and technology teams.

• Strong knowledge of banking data domains, including:
  • Loans
  • Deposits
  • Customer Data
  • General Ledger
  • Treasury
  • Risk
  • Financial Reporting
• Experience with regulatory reporting control frameworks and reconciliation processes.
• Knowledge of data governance, audit controls, and regulatory compliance requirements.
• Experience supporting enterprise Data Warehouse and Regulatory Reporting platforms.
• Familiarity with Agile project methodologies and SDLC processes.

• Axiom Data Sourcing
• Axiom Regulatory Reporting
• Banking Regulatory Reporting
• Oracle SQL
• Data Analysis
• Data Profiling
• Data Validation
• Data Reconciliation
• Data Lineage
• Data Governance
• Source-to-Target Mapping
• Data Warehouse Concepts
• Requirements Gathering & Analysis
• Root Cause Analysis
• Impact Analysis
• Regulatory Compliance
• Stakeholder Management
• Documentation
• Banking & Financial Services Domain