A Data Engineer with expertise in Data Integration is responsible for designing and building solutions to transfer data from operational and external environments to the business intelligence environment. They utilize tools such as Informatica, Ab Initio software, and DataStage (formerly Ascential) - ***'s WebSphere Data Integration Suite. This role involves creating and implementing Extract, Transform, and Load (ETL) processes, ensuring the seamless flow of data throughout the business intelligence solution's lifecycle.
Analyze/validate payroll, contribution, and enrollment data; reconcile discrepancies across systems
Map, transform, and integrate data for recordkeeping platforms; manage file formats (CSV/XML)
Detect errors using AI tools (pattern recognition, anomaly detection)
Support plan onboarding: configure plans, investments, and contribution rules
Monitor data flows, interfaces, and automated feeds; troubleshoot issues
Apply knowledge of 401(k) products (mutual funds, CITs) and FIS Omni
Perform QA/QC, maintain documentation, ensure ERISA/IRS/DOL compliance
Collaborate with stakeholders; communicate data needs and resolutions
Use AI/Python/SQL/RPA to automate processes and improve efficiency