Job Closed

This listing is no longer active.

HR Tech Solutions logo
HR Tech Solutions

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

EDI Coordinator, Excel Analyst

AnalystAnalystOtherRemoteMid LevelTeam 11-50Since 2016H1B No SponsorCompany SiteLinkedIn

Location

United States

Posted

113 days ago

Salary

0

Seniority

Mid Level

Bachelor Degree2 yrs expEnglish

Job Description

EDI Coordinator, Excel Analyst

HR Tech Solutions

• 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

Xebia logo

Data Quality Analyst

Xebia

Creating Digital Leaders. Digital Transformation Consultancy Services and Solutions

Analyst113 days ago
Full TimeRemoteTeam 5,001-10,000H1B Sponsor

• serving as a Data Quality specialist supporting governance and analytics teams • designing, developing, and maintaining Data Quality checks and controls • contributing to the selection and optimization of Data Quality tools • translating business and governance requirements into Data Quality implementations • proactively monitoring Data Quality results and execution logs • initiating and coordinating Data Quality resolution activities • performing impact analysis and ensuring lineage metadata availability • ensuring quality assurance and adherence to defined standards • collaborating with Data Governance, Data Modeling, Architecture, and QA teams • providing training and guidance to stakeholders • supporting releases of Data Quality solution components • participating in Agile delivery processes.

Bulgaria
Job Closed
Xebia Poland logo

Data Quality Analyst

Xebia Poland

A place where experts grow.

Analyst113 days ago
Full TimeRemoteTeam 1,001-5,000Since 2001H1B No Sponsor

• serving as a Data Quality specialist supporting governance and analytics teams • designing, developing, and maintaining Data Quality checks and controls • contributing to the selection and optimization of Data Quality tools • translating business and governance requirements into Data Quality implementations • proactively monitoring Data Quality results and execution logs • initiating and coordinating Data Quality resolution activities • performing impact analysis and ensuring lineage metadata availability • ensuring quality assurance and adherence to defined standards • collaborating with Data Governance, Data Modeling, Architecture, and QA teams • providing training and guidance to stakeholders • supporting releases of Data Quality solution components • participating in Agile delivery processes

Bulgaria
Job Closed
Mariner logo

Senior Analyst, Incentive Compensation

Mariner

Reducing Manufacturers' Cost of Quality

Analyst113 days ago
OtherRemoteTeam 11-50H1B Sponsor

• Support the calculation, administration, and payment of third-party (3P) compensation programs** • Interpret complex contract terms and operationalize them into scalable compensation logic** • Partner with Legal and business stakeholders to implement new or amended agreements** • Ensure consistent treatment across third-party populations, including legacy arrangements** • Source, reconcile, and validate large volumes of data from CRM, billing, custody, and accounting systems** • Configure, maintain, and enhance compensation system logic to support 3P programs** • Validate compensation results, identify risks and recommend scalable technical solutions** • Support audits and inquiries related to third-party compensation calculations and payments** • Partner with Accounting, Legal, Compliance, Technology, and business teams to ensure accurate and timely payments** • Serve as a technical escalation point for complex 3P compensation scenarios** • Identify opportunities to standardize and automate third-party compensation processes** • Build and maintain detailed documentation for compensation logic, data sources, and system workflows** • Support system enhancements, migrations, and future-state design related to 3P compensation** • Contribute to training and enablement materials for internal teams supporting third-parties

Kansas
Job Closed
JPI logo

Publishing Analyst

JPI

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

Analyst113 days ago
OtherRemoteTeam 201-500Since 1989H1B Sponsor

• Assist in development of the database visualization models • Edit and update internal database systems • Identify library information and update the current systems • Read and interpret government policy, regulations, and directives and applying those to required activities • Lead and facilitate client meetings and exercises • Identify strategies for automating and implementing efficient work management processes • Map complex business processes and communicate processes solutions to the client • Create project status briefings and reports • Develop project artifacts including charters, agendas, minutes, and correspondence • Identify risks to the trajectory of the project and develop risk mitigation strategies • Identify issues and develop issues resolution/escalation strategies • Participate in program management working sessions and support program managers in executing day-to-day project management activities.

United States
Job Closed