DataJobs.io
← Back to all jobs

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

Similar Jobs