Data Analyst

Auxiant•Cedar Rapids, IA

About The Position

Auxiant is a third-party administrator of self-funded employee benefit plans, with offices in Cedar Rapids, Iowa, and Madison and Milwaukee, Wisconsin. The Data Analyst supports the organization's adjudication and EDI systems through data analysis, data processing, reporting, and application support. The role manages and supports data loads from multiple sources, including EDI files, scanned claims, and third-party eligibility feeds, as well as data extracts that support 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 data-processing efficiency, and identify opportunities for automation and application modernization. The ideal candidate has analytical and problem-solving skills, relational database experience, attention to detail, and the ability to support established and evolving technologies.

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.
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.
Experience with Microsoft Office, including Excel and Microsoft Access.
Experience with SQL and relational database concepts.
VBA or similar scripting/programming experience.
Experience in data analysis, reporting, and data validation.
Experience troubleshooting data-processing issues.

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.
SFTP and file-based integration experience.
Experience with healthcare EDI transactions, claims, and eligibility processing.
Experience with healthcare claims adjudication systems.
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.