Etl Analyst
Current• Build and maintain ANSI 834 or carrier specific eligibility files• Maintain, adapt and update existing file feed to meet carrier requirements• Develop and document processes for standard file feed integrations• Troubleshoot transformation logic to correct errors from weekly reports• Meet with internal and external partners to gather data requirements• Establishes / Attends recurring conference calls with carriers• Coordinate with Insurance Carriers to ensure file feed accuracy and timeliness• Implement and perform Unit Testing on Data Mapping Logic• Troubleshoot issues and provide / recommend solutions• Perform peer reviews on Data Mapping and logic• Work with Implementation Project Managers and Client Services to ensure Client file feed expectations are met• Establish SFTP / FTP Connections with Healthcare carriers• Transform Business Documents to Data Requirements• Setup Data Mapping and Rules• Maintain SLAs with internal and external stakeholders