https://www.auxiant.com/
Auxiant’s Mission Statement and Core Values
Mission:
An Independent TPA investing in People and Innovation to deliver expert-driven experiences with REAL Results.
Core Values: Independent Solutions. REAL Results
Respect
Empowerment
Agility
Leadership
Be part of a growing and prospering company as a Data Analyst. Auxiant is a third party administrator of self-funded employee benefit plans with offices in Cedar Rapids, IA, Madison and Milwaukee, WI. Auxiant is a fast-growing,progressive company offering an excellent wage and benefit package.
Job Summary:
The Data Analyst is responsible for supporting the organization's adjudication and EDI systems through data analysis, data processing, reporting, and application support. This position manages and supports data loads from multiple sources, including EDI files, scanned claims, and third-party eligibility feeds, as well as data extracts supporting PPO and PBM eligibility and claims processing.
The position is also responsible for analyzing data, identifying and resolving data quality issues, maintaining custom reports, and supporting data conversions for new group implementations.
In addition, the Data Analyst provides technical support for existing data processing applications and automated workflows, including Microsoft Access, VBA, SQL Server, and scheduled processing jobs. The position collaborates with other IT teams to troubleshoot production issues, improve data processing efficiency, and identify opportunities for automation and application modernization.
The ideal candidate possesses strong analytical and problem-solving skills, experience working with relational databases, attention to detail, and the ability to support both established and evolving technologies.
Essential Functions:
- 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 the accuracy, completeness, and integrity of data across systems.
- Support existing applications and automated processes responsible for data processing, reporting, and system integrations.
- Troubleshoot Microsoft Ac