ETL Data Analyst

Computer Task; Atlanta, Charlotte, Raleigh (GA, NC, NC); On-site; USD 85,000 - 110,000; Full time

Job summary

CTG seeks an ETL Data Analyst to support client regulatory reporting, including Call Reports, FR Y-9C, and FR Y-14. The role covers data sourcing, mappings, data lineage, and ETL design using Informatica PowerCenter.

You will partner with Regulatory Reporting, Finance, Risk, Compliance, and Tech teams to optimize ETL performance and ensure data quality and governance.

Qualifications

• Experience with banking regulatory reporting (Call Reports, FR Y-9C, FR Y-14).
• Hands-on Informatica PowerCenter development with complex mappings.
• Strong SQL, data profiling, validation, reconciliation and data quality analysis.

Responsibilities

• Analyze regulatory reporting requirements and source systems.
• Develop and maintain ETL workflows, mappings, and data lineage.
• Collaborate with multiple business and tech teams to support regulatory reporting.

Skills

Informatica PowerCenter

ETL Design

Advanced Oracle SQL

Data Profiling

Source-to-Target Mapping

Data Warehousing

Regulatory Reporting

Data Quality

Education

Bachelor’s degree in Computer Science, Information Systems, Business, Finance, or related field

Tools

Oracle SQL Developer

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.