HR Tech Solutions · 14 hours ago
834 EDI Coordinator and Excel Analyst
United States
Full-time
Remote
Entry, Mid Level
2+ years expHR Tech Solutions is seeking an EDI Coordinator and Excel Analyst to manage discrepancy reports for 834 file feeds and support advanced Excel-based data analysis. The role involves reviewing and resolving discrepancies, developing Excel workbooks, and ensuring data accuracy for business operations and compliance needs.
Human Resources
Responsibilities
Manage discrepancy reports for 834 file feeds
Review daily carrier reports and triage member and technical discrepancies
Investigate issues and route to carrier, broker and/or create a technology case
Answer system related questions from a variety of companies with multiple benefit plans and levels
Develop and maintain advanced Excel workbooks (formulas, pivot tables, Power Query, data models) to support reporting and analysis
Analyze, reconcile, and audit enrollment and carrier data to identify discrepancies, trends, and process improvements
Create dashboards, automated reports, and tracking tools to support business operations and compliance needs
Ensure data accuracy and integrity while documenting processes and supporting ad hoc 834 and benefits reporting requests
Qualification
Required
Must have a minimum of 2-3 years experience in employee benefits and understand all types of plans and the relationship between the broker and human resources
Must have worked with an online benefit administration in a previous position for at least two (2) years- preferably with Employee Navigator, Ease Bswift, Plansource or Zenefits
Must be analytical & detail oriented
Must have excellent customer service skill and flexibility
Must be able to handle multiple projects at one time at a fast pace with minimal errors
Advanced proficiency in Microsoft Excel, including formulas, pivot tables, Power Query, lookups, conditional logic, and data modeling
Experience working with large or complex datasets and performing data reconciliation
Preferred
Experience integrating Excel with other systems or tools preferred
Company
HR Tech Solutions
Offering superior human resources consulting and technology solutions for healthcare brokers and businesses.
11-50 employees
Funding
Current Stage
Early StageCompany data provided by crunchbase