Data Integration Analyst

Computer Task Group, Inc • Beaverton, OR

1d • Onsite

About The Position

CTG is seeking to fill a Data Integration Analyst position for our client. This role involves analyzing and reconciling payroll, enrollment, and contribution data across multiple systems. The analyst will be responsible for designing, mapping, transforming, and integrating data using ETL processes and tools. Additionally, the role includes configuring retirement plans, monitoring automated interfaces, troubleshooting data issues, and utilizing AI tools, Python, SQL, and RPA for automation and data quality improvement. Maintaining integration documentation and ensuring compliance with relevant regulations are also key aspects of this position. Collaboration with business partners and technical teams to resolve data integration challenges is essential.

Requirements

• 5+ years of experience in data integration, ETL, or data engineering.
• Strong SQL and Python skills.
• Experience with Informatica, IBM DataStage, Ab Initio, or similar ETL platforms.
• Knowledge of CSV/XML data formats and enterprise data integration.
• Excellent verbal and written English communication skills and the ability to interact professionally with a diverse group are required.

Nice To Haves

• Experience with 401(k) recordkeeping, FIS Omni, mutual funds, or CITs is highly preferred.

Responsibilities

• Analyze and reconcile payroll, enrollment, and contribution data across multiple systems.
• Design, map, transform, and integrate data using ETL processes and tools such as Informatica, DataStage, or Ab Initio.
• Configure retirement plans, investment options, and contribution rules for onboarding.
• Monitor automated interfaces, troubleshoot data issues, and perform QA/QC validation.
• Utilize AI tools, Python, SQL, and RPA to automate processes and improve data quality.
• Maintain integration documentation and ensure compliance with ERISA, IRS, and DOL regulations.
• Collaborate with business partners and technical teams to resolve data integration challenges.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level