Data Analyst: EDI, SQL & Reporting Specialist

Auxiant

Cedar Rapids (IA)

On-site

USD 60,000 - 90,000

Full time

4 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Medical insurance
Dental insurance
Vision insurance
401K
3 weeks vacation
9 paid holidays
Gym membership reimbursement

Job summary

Auxiant in Cedar Rapids, IA, is seeking a data analyst-style role to support adjudication and EDI operations through data analysis, reporting, and troubleshooting. The position focuses on validating data from EDI, claims, and eligibility feeds, plus developing reports and maintaining data loads.

The role requires an Associate’s degree in CS or MIS with 2–3 years of related experience, strong analytical and communication skills, and proficiency with MS Office, SQL, and VBA.

Qualifications

  • Associate’s degree in computer science or MIS with 2-3 years related experience required.
  • Strong analytical and problem-solving abilities.
  • Proficiency with Microsoft Office, including Excel and Access.
  • SQL and relational database concepts; VBA or scripting experience.

Responsibilities

  • Perform data analysis, validation, and interpretation to support operational and business requirements.
  • Support and maintain data loads from EDI files, scanned claims, third-party eligibility feeds, and other sources.
  • Develop and maintain data extracts for PPO/PBM eligibility, claims, and other business needs.
  • Create, maintain, and troubleshoot custom reports.
  • Support data conversions tied to new group implementations.
  • Investigate data discrepancies and apply corrective actions.
  • Ensure data accuracy and integrity across connected systems.
  • Support applications and automated processes for data processing and reporting.
  • Troubleshoot Microsoft Access applications, including VBA code, queries, macros, and scheduled jobs.
  • Investigate SQL Server queries, stored procedures, and data processing issues.
  • Monitor and troubleshoot scheduled data processing jobs and automated file transfers.
  • Review logs and results to resolve issues.
  • Document recurring issues and corrective actions.

Skills

Analytical skills
Problem solving
Communication skills
Interpersonal skills
Prioritization
Self-motivation
Attention to detail
MS Office (Excel)
SQL concepts
VBA
Data analysis & reporting
Data validation
Data processing troubleshooting

Education

Associate’s degree in CS or MIS

Tools

SQL
Microsoft Access
PowerShell
VBA
Excel
Batch scripting
SFTP
EDI
SQL Server

Job description

Auxiant in Cedar Rapids, IA, is seeking a data analyst-style role to support adjudication and EDI operations through data analysis, reporting, and troubleshooting. The position focuses on validating data from EDI, claims, and eligibility feeds, plus developing reports and maintaining data loads.

The role requires an Associate’s degree in CS or MIS with 2–3 years of related experience, strong analytical and communication skills, and proficiency with MS Office, SQL, and VBA.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Analyst
Data Analyst

Auxiant • Cedar Rapids (IA)

On-site
USD 60,000 - 90,000
Medical insurance
Dental insurance
Vision insurance
+4
Claims Analyst
Claims Analyst

Global Information Technology • Southfield (MI)

Remote
USD 41,000 - 83,000
Strategic EDI Systems Analyst & Data Liaison
Strategic EDI Systems Analyst & Data Liaison

CareFirst BlueCross BlueShield • Baltimore (MD)

On-site
USD 65,000 - 129,000
EDI Analyst
EDI Analyst

Hermann-Forwarding • Houston (TX)

On-site
USD 60,000 - 75,000
Senior EDI Analyst - Data Compliance & Integration
Senior EDI Analyst - Data Compliance & Integration

Us Tech Solutions • Deerfield (IL)

On-site
USD 52,000 - 62,000
Healthcare Data Analyst - DataOps & EDI Specialist
Healthcare Data Analyst - DataOps & EDI Specialist

Scalepex • Texas

On-site
USD 70,000 - 90,000
EDI Analyst I | Healthcare Data & Integrations
EDI Analyst I | Healthcare Data & Integrations

Morris & Dickson Co., LLC • Shreveport (LA)

On-site
USD 52,000 - 78,000
Medical, Dental, and Vision Insurance
HSA, HRA, FSA reimbursement accounts
401K Savings Plan with company match
EDI Analyst
EDI Analyst

Hermann Forwarding • Houston (TX)

On-site
USD 60,000 - 75,000
Client Implementation Analyst II-EDI
Client Implementation Analyst II-EDI

MultiPlan • McLean (VA)

Remote
USD 107,000 - 117,000
Remote work
EDI Analyst I — Healthcare Data Integrations
EDI Analyst I — Healthcare Data Integrations

Morris & Dickson • Shreveport (LA)

On-site
USD 52,000 - 70,000
Medical, Dental, Vision Insurance
HRA, HSA, and FSA reimbursement
401K Savings Plan with a company match
+4