Data Analyst

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

In Cedar Rapids, IA, this role supports adjudication and EDI operations through analysis, data processing, reporting, and application troubleshooting.

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, identify root causes, and apply corrective actions.
  • Ensure accuracy, completeness, and data integrity across connected systems.
  • Support existing applications and automated processes used for data processing, reporting, and system integrations.
  • Troubleshoot Microsoft Access applications, including VBA code, queries, macros, and scheduled jobs.
  • Investigate Microsoft SQL Server queries, stored procedures, and data processing issues.
  • Monitor and troubleshoot scheduled data processing jobs and automated file transfers.
  • Review application logs and processing results to identify and resolve issues.
  • Document recurring production issues, troubleshooting steps, and corrective actions.
  • Perform other duties as assigned or appropriate.
Requirements
  • Associate’s degree in computer science or management information systems and 2-3 years related experience, or equivalent education and experience combination required.
  • Strong analytical and problem-solving abilities.
  • Effective written and oral communication skills.
  • Good interpersonal skills.
  • Ability to prioritize tasks and adapt to priority changes when needed.
  • Self-motivated.
  • Strong attention to detail.
  • Proficiency with Microsoft Office, including Excel and Microsoft Access.
  • SQL and relational database concepts.
  • VBA or similar scripting/programming experience.
  • Experience with data analysis, reporting, and data validation.
  • Experience troubleshooting data processing issues.
Technologies
  • Microsoft Office, Excel, Microsoft Access
  • VBA
  • SQL, relational databases, Microsoft SQL Server
  • Stored procedures
  • PowerShell
  • Batch scripting
  • SFTP
  • EDI
  • SQL Server
Preferred (Not Required)
  • Microsoft SQL Server, including stored procedures
  • MySQL
  • PowerShell or batch scripting
  • Production application support and troubleshooting
  • Scheduled tasks and automated data processing
  • SFTP and file-based integrations
  • Healthcare EDI transactions, claims, and eligibility processing
  • Healthcare claims adjudication systems
  • Data validation and quality assurance
Benefits
  • Medical
  • Dental
  • Vision
  • Flexible Spending
  • Gym Membership Reimbursement
  • Life Insurance
  • LTD
  • STD
  • 401K
  • 3 weeks vacation
  • 9 paid holidays
  • Casual dress code
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Analyst: EDI, SQL & Reporting Specialist
Data Analyst: EDI, SQL & Reporting Specialist

Auxiant • Cedar Rapids (IA)

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

AHS • Little Rock (AR)

Hybrid
USD 60,000 - 85,000
AD&D insurance
Dental insurance
Disability insurance
+8
EDI Analyst
EDI Analyst

American Vision Partners • Phoenix (AZ)

On-site
USD 70,000 - 90,000
Medical and dental insurance
Eye care discounts
401(k)
+3
EDI & Claims Operational Analyst
EDI & Claims Operational Analyst

Blue Zones Health • United States

On-site
USD 85,000 - 100,000
Technical EDI Analyst (Remote)
Technical EDI Analyst (Remote)

CareFirst BlueCross BlueShield • Baltimore (MD)

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

Integrated Home • Florida

On-site
USD 70,000 - 95,000
Data Analyst
Data Analyst

Christian Community Health Center • South Holland (IL)

On-site
USD 65,000 - 85,000
Blue Cross Blue Shield Medical
Blue Cross Blue Shield Dental and VIs/
Life Insurance
Healthcare Data Analyst - DataOps & EDI Specialist
Healthcare Data Analyst - DataOps & EDI Specialist

Scalepex • Texas

On-site
USD 70,000 - 90,000
Healthcare Data Analyst
Healthcare Data Analyst

Scalepex • Texas

On-site
USD 70,000 - 90,000
Medical Informatics Analyst – Business Analyst Advanced
Medical Informatics Analyst – Business Analyst Advanced

Blue Cross Blue Shield of Michigan • Detroit (MI)

On-site
USD 90,000 - 120,000