HR Tech Solutions

We are committed to offering superior human resource tools to Brokers and Employers.

EDI Coordinator, Excel Analyst

AnalystAnalystFull TimeRemoteTeam 11-50Since 2016H1B No SponsorCompany SiteLinkedIn

Location

United States

Posted

29 days ago

Salary

Not specified

Bachelor Degree2 yrs expEnglish

Job 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 • 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

Job 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

Related Categories

Related Job Pages

More Analyst Jobs

Senior Analyst, Incentive Compensation

Mariner

Reducing Manufacturers' Cost of Quality

Analyst29 days ago
Full TimeRemoteTeam 11-50H1B Sponsor

Technical Analyst managing third-party compensation calculations and optimizations

ETLOracleSQL
Kansas

Publishing Analyst

JPI

Over 30 years of developing class A multifamily. 🏆 NMHC’s fastest-growing developer and second-fastest growing builder.

Analyst29 days ago
Full TimeRemoteTeam 201-500Since 1989H1B Sponsor

Publishing Analyst supporting IT projects for federal clients

United States

Senior Distributions Analyst

PCS Retirement

PCS Retirement is one of the largest independent and conflict-free retirement solution providers.

Analyst29 days ago
Full TimeRemoteTeam 201-500H1B Sponsor

Senior Distributions Analyst supporting retirement plan processing at PCS Retirement, LLC

United States
$48K - $60K / year
Analyst29 days ago
Full TimeRemoteTeam 1,001-5,000H1B Sponsor

GIS Analyst executing data services projects for public safety and GIS.

United States
$62K - $75K / year