Regulatory Reporting Data Analyst

CTG is seeking to fill a Regulatory Reporting Data Analyst position for our client. Location: Atlanta, GA Duration: Ongoing Contract Job Summary The Regulatory Reporting Data Analyst will analyze, source, validate, and integrate data supporting banking regulatory reporting, including Axiom, Call Reports, FR Y-9C, and FR Y-14. This role will work closely with Regulatory Reporting, Finance, Risk, Compliance, Business, and Technology teams to ensure accurate, compliant, and reliable regulatory reporting. Key Responsibilities • Analyze regulatory reporting requirements and define data sourcing, transformation, and business rules. • Perform advanced SQL data analysis, profiling, validation, reconciliation, and data quality investigations. • Design, develop, and support Informatica PowerCenter ETL mappings, workflows, sessions, and transformations. • Develop and maintain source-to-target mappings, data lineage, data definitions, and ETL documentation. • Analyze source systems and data warehouse structures to identify required regulatory reporting data. • Investigate data discrepancies, reconciliation breaks, ETL failures, and reporting issues through root cause analysis. • Perform impact analysis for system changes, ETL modifications, and regulatory reporting enhancements. • Support production validation, batch processing, releases, and ongoing regulatory reporting activities. • Collaborate with business and technology stakeholders to gather requirements and deliver data integration solutions. • Ensure data governance, audit, regulatory compliance, and documentation requirements are met. Required Skills & Experience • Strong banking and regulatory reporting domain knowledge. • Experience with Axiom Data Sourcing and Regulatory Reporting preferred. • Experience supporting Call Reports (FFIEC 031/041), FR Y-9C, FR Y-14, or similar U.S. banking regulatory reports. • Advanced Oracle SQL skills. • Hands-on Informatica PowerCenter development experience. • Experience with ETL development, complex mappings, transformations, workflows, sessions, and performance tuning. • Strong understanding of data profiling, data validation, reconciliation, data quality, data lineage, and source-to-target mapping. • Knowledge of data warehousing, dimensional modeling, and enterprise data integration. • Strong analytical, problem-solving, documentation, and communication skills. • Ability to collaborate effectively with business and technical stakeholders This is a contract W2 role, CANNOT do C2C, C2H or 1099