Data Analyst

Auxiant•Cedar Rapids, IA

About The Position

The Data Analyst supports Auxiant’s adjudication and EDI systems through data analysis, data processing, reporting, and application support. The role manages and supports data loads from sources such as EDI files, scanned claims, and third-party eligibility feeds, and develops data extracts for PPO and PBM eligibility and claims processing. The position analyzes data, identifies and resolves data quality issues, maintains custom reports, and supports data conversions for new group implementations. It also provides technical support for existing data-processing applications and automated workflows, including Microsoft Access, VBA, SQL Server, and scheduled processing jobs. The Data Analyst collaborates with other IT teams to troubleshoot production issues, improve processing efficiency, and identify opportunities for automation and application modernization. Auxiant is a third-party administrator of self-funded employee benefit plans, with offices in Cedar Rapids, Iowa, and Madison and Milwaukee, Wisconsin. The company describes itself as growing and progressive, with a mission of investing in people and innovation to deliver expert-driven experiences with real results.

Requirements

Associate’s degree in computer science or management information systems and 2–3 years of related experience, or an equivalent combination of education and experience.
Experience with Microsoft Office, including Excel and Microsoft Access.
Experience with SQL and relational database concepts.
VBA or similar scripting/programming experience.
Experience with data analysis, reporting, and data validation.
Experience troubleshooting data-processing issues.
Strong analytical and problem-solving abilities.
Effective written and oral communication skills.
Good interpersonal skills.
Ability to prioritize tasks and adapt when priorities change.
Self-motivated, with strong attention to detail.

Nice To Haves

Microsoft SQL Server experience, including stored procedures.
MySQL experience.
PowerShell or batch scripting experience.
Production application support and troubleshooting experience.
Experience with scheduled tasks and automated data processing.
Experience with SFTP and file-based integrations.
Healthcare EDI transactions, claims, and eligibility processing experience.
Healthcare claims adjudication systems experience.
Data validation and quality assurance experience.

Responsibilities

Perform data analysis, validation, and interpretation to support operational and business requirements.
Support and maintain data loads involving 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.
Develop, maintain, and troubleshoot custom reports.
Support data conversions for new group implementations.
Investigate data discrepancies, identify root causes, and implement corrective actions.
Ensure data accuracy, completeness, and integrity across systems.
Support existing applications and automated processes for data processing, reporting, and system integrations.
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 application logs and processing results to identify and resolve issues.
Document recurring production issues, troubleshooting procedures, and corrective actions.
Perform other duties as assigned or appropriate.