Data Integration Support Specialist

Virtual Benefits Administrator• US,

9d•$65,000 - $70,000•Remote

About The Position

The Data Integration Support Specialist is a hands-on technical role responsible for ensuring healthcare and benefits administration data moves accurately, securely, and efficiently between VBA, its clients, and vendors. The specialist owns investigation, troubleshooting, and resolution of data integration issues, including failed file transfers, data discrepancies, and automated processing problems. The role monitors automated integration jobs and supports inbound and outbound data exchanges. It uses SQL Server Management Studio (SSMS), SQL queries and scripts, SQL Server Integration Services (SSIS), SFTP configurations, and automation workflows to investigate issues, validate data, and maintain reliable processing. The specialist also runs manual jobs, reprocesses files, manages off-cycle file requests, documents workflows and file specifications, and contributes to process improvements. The position is remote, with no travel. Occasional after-hours or weekend support may be required for monthly software releases or critical integration needs.

Requirements

Hands-on experience with SQL Server Management Studio (SSMS), including writing and executing SQL queries, reviewing data, and troubleshooting issues.
Working knowledge of SQL Server Integration Services (SSIS), EDI processes, and automated file processing workflows.
Experience independently investigating and resolving data integration, file processing, or data transfer issues.
Strong analytical and troubleshooting skills, including the ability to identify root causes and implement effective solutions.
Ability to manage multiple priorities, exercise sound judgment, and follow technical issues through resolution.
Strong attention to detail and commitment to data accuracy, quality, and reliability.
Effective written and verbal communication skills, including explaining technical issues and collaborating with cross-functional teams.
Proactive, solutions-oriented approach and ability to work independently and contribute within a collaborative team.
High school diploma or equivalent.

Nice To Haves

Experience supporting EDI integrations within healthcare, health insurance, benefits administration, or a related industry.
Familiarity with HIPAA EDI transaction formats, particularly 834 enrollment and 837 claims files.
Experience with automation tools such as Automate.
Experience troubleshooting SFTP connections, scheduled integration jobs, and automated file workflows.
Experience identifying recurring integration issues and contributing to process improvements or automation enhancements.

Responsibilities

Independently investigate, diagnose, and resolve data integration issues, including file processing failures, data discrepancies, and transfer errors.
Monitor and analyze automated integration jobs, identify issues proactively, and take corrective action to maintain accurate and timely data exchanges.
Use SSMS, SQL queries and scripts, and SSIS to investigate issues, validate data, and support integration processes.
Troubleshoot inbound and outbound client and vendor files in accordance with established interface requirements.
Maintain SFTP configurations and troubleshoot file transmission issues and automated processing workflows.
Run manual jobs, reprocess files, and manage off-cycle file requests accurately while minimizing disruption.
Document integration workflows, file specifications, and schemas.
Identify recurring issues and opportunities to improve efficiency, processes, and automation.
Collaborate with internal teams, communicate findings, and seek additional expertise when needed to resolve complex issues.
Manage competing priorities, follow issues through resolution, and communicate progress to appropriate stakeholders.

Benefits

12 paid holidays
Responsible Time Off
Volunteerism Day
Paid parental leave: 2 weeks of bonding leave and 10 weeks of supplemental medical leave for birthing parents only
Life insurance with $500,000 guaranteed issue
Short- and long-term disability insurance
Employer match on employee 401(k) contributions
Broadband reimbursement up to $120
Two medical plan options
Dental insurance
Vision insurance
Remote/hybrid schedules depending on job role