ETL Data Analyst

Computer Task Group; Atlanta (GA); On-site; USD 90,000 - 120,000; Full time

Job summary

CTG is seeking an ETL Data Analyst for a 12-month engagement across Atlanta, Charlotte, and Raleigh. The role focuses on regulatory reporting data, source systems analysis, and ETL development using Informatica PowerCenter.

You will support Call Reports, FR Y-9C, FR Y-14, Basel 3, and related submissions. Responsibilities include designing mappings, validating data quality, and performing root-cause analysis while collaborating with Regulatory Reporting, Finance, Risk, and Technology teams.

Qualifications

• Bachelor’s degree or equivalent experience required or preferred.
• Strong banking and financial services knowledge, including regulatory reporting.
• Hands-on Informatica PowerCenter development with complex mappings and production support.

Responsibilities

• Analyze banking regulatory reporting requirements (Call Reports, FR Y-9C, FR Y-14, Basel 3).
• Analyze source systems, data structures, and business rules for regulatory reporting.
• Design, develop, and support ETL workflows using Informatica PowerCenter.
• Develop source-to-target mappings, data lineage, and data definitions.
• Translate regulatory requirements into ETL specs and data sourcing.
• Investigate data discrepancies and ETL failures; perform root cause analysis.
• Support data integration, batch processing, testing, and regulatory reporting enhancements.
• Optimize ETL workflows for performance and reliability.
• Collaborate with Regulatory Reporting, Finance, Risk, Compliance, Business, and Tech teams.
• Maintain controls for data governance, audits, and examinations.

Skills

Informatica PowerCenter

ETL Design & Development

Advanced Oracle SQL

Data Profiling

Data Lineage

Data Warehousing

Regulatory Reporting Data Sourcing

Data Quality

Requirements Analysis

ETL Performance Tuning

Production Support

Data Governance

Axiom Data Sourcing

Basel 3 Standards

Education

Bachelor’s degree in Computer Science, Information Systems, Business, Finance, or a related field preferred, or equivalent experience.

Job description

CTG is seeking to fill an ETL Data Analyst position for our client.

Location: Atlanta, GA / Charlotte, NC / Raleigh, NC – No Remote

Duration: 12 months

Duties:

• Analyze banking regulatory reporting requirements, including Call Reports, FR Y-9C, FR Y-14, Basel 3, and other regulatory submissions.

• Analyze source systems, data structures, relationships, and business rules to identify data required for regulatory reporting.

• Perform advanced SQL-based data profiling, validation, reconciliation, data quality analysis, and root cause investigation.

• Design, develop, enhance, and support ETL workflows, mappings, sessions, and transformations using Informatica PowerCenter.

• Develop and maintain source-to-target mappings, data lineage, data definitions, ETL specifications, and business rule documentation.

• Gather and translate business and regulatory requirements into data sourcing, mapping, and ETL specifications.

• Investigate data discrepancies, ETL failures, reconciliation breaks, and reporting issues; perform root cause and impact analysis.

• Support data integration, batch processing, production validation, testing, releases, and regulatory reporting enhancements.

• Optimize ETL workflows for performance, scalability, and reliability.

• Collaborate with Regulatory Reporting, Finance, Risk, Compliance, Business, and Technology teams.

• Maintain documentation and controls supporting data governance, audits, regulatory compliance, and examination requests.

Skills:

• Informatica PowerCenter

• ETL Design & Development

• Advanced Oracle SQL

• Data Profiling, Validation & Reconciliation

• Source-to-Target Mapping & Data Lineage

• Data Warehousing & Data Integration

• Regulatory Reporting Data Sourcing

• Data Quality & Root Cause Analysis

• Requirements Analysis & Impact Analysis

• ETL Performance Tuning

• Production Support & Release Management

• Data Governance & Regulatory Compliance

• Axiom Data Sourcing / Regulatory Reporting

• Basel 3 Standards

Experience:

• Strong banking and financial services domain experience, including Loans, Deposits, Customer, General Ledger, Treasury, Risk, and Financial Reporting data.

• Hands-on Informatica PowerCenter development experience, including complex mappings, transformations, sessions, workflows, reusable components, performance tuning, and production support.

• Experience supporting Axiom regulatory reporting solutions and banking regulatory reports such as Call Reports (FFIEC 031/041), FR Y-9C, and FR Y-14.

• Advanced SQL experience in data warehouse and regulatory reporting environments, including profiling, validation, reconciliation, and data quality analysis.

• Experience with data warehousing concepts, dimensional modeling, ETL best practices, and enterprise data integration frameworks.

Education:

• Bachelor’s degree in Computer Science, Information Systems, Business, Finance, or a related field preferred, or equivalent experience.

Excellent verbal and written English communication skills and the ability to interact professionally with a diverse group are required.

CTG does not accept unsolicited resumes from headhunters, recruitment agencies, or fee based recruitment services for this role.

About CTG

CTG, a Cegeka company, delivers IT and business solutions that enhance clients’ digital agility, empowering them to seize new opportunities and overcome any challenge. Backed by more than 60 years’ experience and a commitment to being a reliable, results‑driven partner, we work shoulder to shoulder with clients to shape digital together. Our vision is to be an indispensable partner to our clients and the preferred career destination for digital and technology experts. With more than 9,000 team members in over 15 countries, we combine global expertise with local insight to deliver innovative solutions. We operate across the Americas, Europe, and India, working with over 3,000 clients in many of today's highest-growth industries.

Together, we shape what’s next—working shoulder to shoulder to deliver impactful solutions for our clients and society. Our culture is built by the people who work at CTG, the values we hold, and the actions we take. It's a living, breathing thing that is renewed every day through the ways we engage with each other, our clients, and our communities. At CTG, you’ll find a workplace where you are encouraged to grow, supported in your ambitions, and empowered to shape your own career journey. For more information, visit www.ctg.com .

CTG will consider for employment all qualified applicants including those with criminal histories in a manner consistent with the requirements of all applicable local, state, and federal laws.

CTG is an Equal Opportunity Employer. CTG will assure equal opportunity and consideration to all applicants and employees in recruitment, selection, placement, training, benefits, compensation, promotion, transfer, and release of individuals without regard to race, creed, religion, color, national origin, sex, sexual orientation, gender identity and gender expression, age, disability, marital or veteran status, citizenship status, or any other discriminatory factors as required by law. CTG is fully committed to promoting employment opportunities for members of protected classes.