ERP Benefits Data Analyst/Auditor

Benefit Harbor provides benefits administration technology and compliance solutions. The ERP Benefits Data Analyst/Auditor audits, analyzes, and validates EDI files, enrollment data, and reports exchanged across ERP systems, carriers, vendors, and Benefit Harbor’s platform. The role supports data quality, issue resolution, documentation, and operational collaboration.

Responsibilities:

• Conduct post-open enrollment, monthly system, and quarterly enrollment audits to validate the accuracy and consistency of data exchanged between ERP systems and the Benefit Harbor platform
• Review audit results, identify discrepancies, document findings, and communicate potential issues to the appropriate internal teams
• Research data inconsistencies, investigate root causes, and collaborate with relevant stakeholders to support corrective actions through resolution
• Perform quality assurance reviews to confirm the completeness, accuracy, and integrity of enrollment data, reports, and electronic data files
• Maintain clear and organized audit documentation, including results, identified exceptions, follow-up activities, and resolution status
• Assist Client Services and Operations teams with audit-related issue mitigation and ongoing data quality improvements
• Request, obtain, and review data extracts from insurance carriers, vendors, and Workday or other ERP systems to support regularly scheduled audits and data validation activities
• Develop and maintain a working understanding of various EDI file types, file layouts, data elements, and basic data mapping concepts
• Compare data across systems and files to identify missing information, discrepancies, formatting issues, and potential transmission errors
• Assist with investigating issues affecting data transfers and coordinate with internal technical teams and external partners as needed
• Support the validation of file updates, enrollment changes, and data corrections to help ensure accurate information is reflected across connected systems
• Maintain documentation related to file specifications, audit procedures, recurring data issues, and established workflows
• Investigate audit exceptions, data discrepancies, and reported system or file-related issues, coordinating with internal stakeholders and external partners to determine appropriate resolutions
• Manage assigned Client Support and TMS tickets, providing timely updates, maintaining accurate documentation, and following established procedures through completion
• Escalate unresolved or complex issues to the appropriate team members, providing supporting details and relevant findings to facilitate investigation
• Maintain ownership of assigned issues and follow up with stakeholders to ensure outstanding items are addressed within expected timelines
• Support the Client Services and Operations teams with data-related inquiries, reporting requests, and troubleshooting activities
• Meet established deadlines for scheduled audits, data extracts, support tickets, and other assigned deliverables
• Build and maintain effective working relationships with insurance carriers, vendors, Client Services, Operations, Development, and other internal teams
• Communicate audit findings, data concerns, and resolution updates clearly to both technical and non-technical stakeholders
• Identify opportunities to improve audit procedures, strengthen data quality controls, streamline workflows, and enhance operational efficiency
• Adapt to changing business priorities while maintaining accuracy, organization, and consistent follow-through
• Participate in special projects and perform additional duties as assigned

Requirements:

• Bachelor's degree in business, Information Systems, Healthcare Administration, or a related field; equivalent relevant professional experience may be considered
• At least two years of experience supporting complex projects, data analysis, auditing, quality assurance, benefits administration, or related operational functions
• Proficiency in Microsoft Office applications, with intermediate-level Excel and Access skills required
• Strong analytical skills and the ability to evaluate data, identify inconsistencies, investigate discrepancies, and support appropriate resolutions
• Ability to work with spreadsheets, structured data, electronic files, and recurring reports while maintaining accuracy and attention to detail
• Ability to organize electronic files, maintain accurate documentation, and use standard computer applications effectively
• Willingness and ability to learn proprietary platforms, ERP systems, EDI file formats, and benefits administration processes
• Strong written and verbal communication skills, including the ability to explain findings and technical issues to both technical and non-technical audiences
• Ability to ask clarifying questions, gather relevant information, investigate concerns, and communicate next steps effectively
• Professional and responsive approach when working with internal teams, carriers, vendors, and other business partners
• Strong customer service orientation, with a commitment to timely communication, follow-up, and issue resolution
• Exceptional attention to detail and commitment to data accuracy and integrity
• Strong organizational and time management skills, with the ability to manage multiple assignments and meet recurring deadlines
• Self-motivated, dependable, and accountable, with a strong work ethic and willingness to take initiative
• Logical and methodical approach to research, troubleshooting, and problem-solving
• Ability to adapt to changing priorities in a fast-paced, deadline-driven environment
• Demonstrated ability to collaborate effectively and contribute to shared team objectives
• Experience working with health insurance, employee benefits, enrollment data, or EDI processes is preferred
• Familiarity with data reconciliation, file validation, system reporting, or troubleshooting data discrepancies is an advantage
• Familiarity with database functions, data structures, and data validation techniques is preferred but not required