Data Integration Support Specialist

Virtual Benefits Administrator; Oregon; Hybrid; USD 65,000 - 90,000; Full time

Benefits offered by this job

Life insurance

Disability insurance

401(k) match

Broadband reimbursement

Health & Vision/Dental

Job summary

Virtual Benefits Administrator (VBA) seeks a Data Integration Support Specialist to own integration troubleshooting and data transfers. You'll investigate file processing failures, monitor automated jobs, and collaborate with clients and vendors to ensure accurate, timely data exchanges.

This remote role offers flexible schedules, cross-functional teamwork, and opportunities to improve automation and documentation while maintaining strict HIPAA-compliant data handling practices.

Qualifications

• Hands-on experience with SSMS including writing and troubleshooting SQL queries.
• Working knowledge of SSIS, EDI processes, and automated file workflows.
• Experience investigating data integration, file processing, or transfer issues independently.
• Strong analytical and troubleshooting skills with root-cause identification.
• Ability to manage multiple priorities with sound judgement.

Responsibilities

• Own integration troubleshooting and resolution: diagnose and resolve data integration issues.
• Ensure reliable data processing by monitoring automated jobs and correcting issues.
• Utilize SSMS/SSIS to investigate issues, validate data, and support integration processes.
• Support client and vendor data exchanges, ensuring accurate file processing.
• Maintain SFTP configurations and assist with automated processing workflows.
• Execute critical processing requests, reprocess files, and manage off-cycle requests.
• Document integration workflows and schemas; identify recurring issues for improvements.
• Collaborate with cross-functional teams to resolve complex issues.

Skills

Data integration troubleshooting

SQL queries

Analytical problem solving

Cross-functional communication

Multitasking & prioritization

Education

High school diploma or equivalent

Tools

SSMS

SSIS

EDI

Automate

SFTP

Job description

Keep critical healthcare data moving. Solve complex problems. Make an impact where accuracy and technology come together.Make an Impact at VBAAt VBA, reliable data is at the heart of delivering a seamless experience for our clients. As a Data Integration Support Specialist , you'll play a critical role in ensuring healthcare and benefits administration data moves accurately, securely, and efficiently between VBA, our clients, and their vendors.

This is a hands‑on technical role where you'll take ownership of investigating, troubleshooting, and resolving data integration issues. From identifying the root cause of a failed file transfer to ensuring automated processes run as expected, your work will directly contribute to the reliability of our platform and the experience we deliver to our clients. If you're someone who enjoys digging into technical challenges, solving problems independently, and finding better ways to make processes work, this is an opportunity to make a meaningful impact.

About VBA

Connected by Mission. Driven by Innovation.

At VBA, our mission is simple but powerful: we make the healthcare experience better for everyone. We help clients simplify complex operations through fully integrated solutions spanning claims and benefits administration, revenue cycle management, provider and network management, care coordination, and automation tools. Our technology—ranging from VBAPI’s thousands of integration endpoints to predictive analytics, branded portals, mobile access, and AI-powered automation—drives efficiency, accuracy, and better outcomes for millions of people who rely on their health benefits every day. What sets us apart is not just our platform, but our people-centered culture: we blend innovation with flexibility, empowering employees to do meaningful work, stay connected across 25+ states, and thrive in an environment where purpose, collaboration, and growth fuel everything we do.

What You’ll Bring to VBA

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

• Delivering reliable integrations: Keep 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)

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