HR Tech Solutions
We are committed to offering superior human resource tools to Brokers and Employers.
EDI Coordinator, Excel Analyst
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 Guides
Related Categories
Related Job Pages
More Analyst Jobs
Analyst29 days ago
Full TimeRemoteTeam 11-50H1B Sponsor
Technical Analyst managing third-party compensation calculations and optimizations
ETLOracleSQL
Kansas
Publishing Analyst
JPIOver 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 RetirementPCS 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
Analyst29 days ago
Full TimeRemoteTeam 1,001-5,000H1B Sponsor
GIS Analyst executing data services projects for public safety and GIS.