834 EDI Coordinator and Excel Analyst
Company: HR Tech Solutions LLC
Location: Mount Clemens
Posted on: February 19, 2026
|
|
|
Job Description:
Job Description Job Description Description: 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. If you have
an employee benefits background and have worked with benefit
administration systems, you will be able to be trained in this
position. 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: Required Work Experience,
Skills & Education 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
Keywords: HR Tech Solutions LLC, Lorain , 834 EDI Coordinator and Excel Analyst, Accounting, Auditing , Mount Clemens, Ohio
