Data Integration Support Specialist

Required Qualifications

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, with 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 a commitment to data accuracy, quality, and reliability.

Effective written and verbal communication skills, including the ability to explain technical issues and collaborate with cross-functional teams.

A proactive, solutions-oriented approach with the ability to work independently and contribute within a collaborative team.

High school diploma or equivalent.

What Would make You Stand Out

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.

What You Will Be Doing

Own integration troubleshooting and resolution: Independently investigate, diagnose, and resolve data integration issues, including file processing failures, data discrepancies, and transfer errors.

Ensure reliable data processing: Monitor and analyze automated integration jobs, proactively identifying issues and taking corrective action to maintain accurate and timely data exchanges.

Leverage SQL and integration tools: Use SQL Server Management Studio (SSMS), SQL queries, scripts, and SQL Server Integration Services (SSIS) to investigate issues, validate data, and support integration processes.

Support client and vendor data exchanges: Troubleshoot inbound and outbound files based on established interface requirements, ensuring data is processed accurately and consistently.

Manage file transfers and automation: Maintain SFTP configurations, troubleshoot file transmission issues, and support automated processing workflows.

Execute critical processing requests: Run manual jobs, reprocess files, and manage off-cycle file requests while ensuring accuracy and minimizing disruptions.

Improve processes and documentation: Maintain documentation of integration workflows, file specifications, and schemas while identifying opportunities to reduce recurring issues and improve efficiency.

Collaborate across teams: Partner with internal teams to communicate findings, resolve more complex issues when additional expertise is needed, and support dependable integration operations.

What Success Looks Like

Success in this role means more than resolving technical issues. It's about taking ownership, anticipating challenges, and helping ensure our clients can depend on the accuracy and reliability of their data.

You'll make an impact by:

Delivering reliable integrations: Keeping automated data processes running accurately and consistently, minimizing disruptions to client operations.

Resolving issues with confidence: Independently identifying root causes, implementing effective solutions, and knowing when collaboration is needed.

Preventing recurring problems: Looking beyond immediate fixes to identify patterns and opportunities for lasting improvements.

Taking ownership from start to finish: Managing competing priorities, following issues through resolution, and communicating progress to the appropriate stakeholders.

Driving continuous improvement: Contributing ideas and process enhancements that strengthen data accuracy, operational efficiency, and the overall client experience.

Ready to make an impact? Join VBA and help accelerate the reliability, accuracy, and performance of the technology our clients depend on.

Travel Requirements: None

Schedule: This position may require occasional after-hours or weekend support associated with monthly software releases or critical integration needs.

Location : Remote

What can VBA offer you?

Purposeful Work. Flexible Culture. Human-Centered Tech.

At VBA, you’ll be part of a team that’s connected by mission and driven by innovation. We offer the flexibility to do your best work from wherever you are, the tools and support to grow your career, and the chance to make a real impact on the healthcare experience. Our culture blends trust, collaboration, and curiosity—giving you space to think boldly and the structure to succeed.

Work/Life Balance:

Remote/Hybrid Schedules (depending on job role)

Time off: 12 Paid Holidays Responsible Time Off Volunteerism Day Paid Parental Leave: 2 Weeks: Bonding Leave 10 Weeks: Supplemental Medical Leave (for Birthing Parents Only)

12 Paid Holidays

Responsible Time Off

Volunteerism Day

Paid Parental Leave: 2 Weeks: Bonding Leave 10 Weeks: Supplemental Medical Leave (for Birthing Parents Only)

2 Weeks: Bonding Leave

10 Weeks: Supplemental Medical Leave (for Birthing Parents Only)

Financial Health-Company Sponsored Benefits:

Life insurance-$500,000 guaranteed issue

Short- and long-term disability insurance

Employer match on employee 401(k) contributions

Broadband Reimbursement up to $120

Health & Wellness:

Health (2-Medical Plan Options), Dental, and Vision Insurance