HR Tech Solutions

EDI Coordinator, Excel Analyst

HR Tech Solutions

full-time

Posted on:

Location Type: Remote

Location: United States

Visit company website

Explore more

✨ AI Apply
Apply

About the role

  • The EDI Coordinator will be responsible for managing discrepancy reports for 834 file feeds
  • This position does not require you to configure EDIs; it requires reviewing and resolving discrepancy reports
  • In addition to EDI discrepancy management, this role will support advanced Excel-based data analysis, reporting, reconciliation, and process optimization related to carrier feeds, enrollment data, and compliance reporting
  • 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
  • Other duties as assigned
  • 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

Requirements

  • 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
  • Experience integrating Excel with other systems or tools preferred
Benefits
  • Fully Remote 📊 Check your resume score for this job Improve your chances of getting an interview by checking your resume score before you apply. Check Resume Score
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
data analysisdata reconciliationdata modelingExcel formulaspivot tablesPower Queryautomated reportsdashboard creationdiscrepancy managementcompliance reporting
Soft Skills
analyticaldetail orientedcustomer serviceflexibilitymultitaskingtime managementproblem solvingcommunication