Data Analyst

Description

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 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.

Nonessential Functions

• Other duties as assigned or appropriate

Education/Qualifications

• Associate’s degree in computer science or management information systems and 2-3 years related experience; or equivalent combination of education and experience 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

Experience with the following required:

• Microsoft Office, including Excel and Microsoft Access.
• SQL and relational database concepts.
• VBA or similar scripting/programming experience.
• Data analysis, reporting, and data validation.
• Experience troubleshooting data processing issues.
• Strong analytical and problem-solving abilities.

Experience with the following preferred but 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.

Full benefits including: Medical, Dental, Vision, Flexible Spending, Gym Membership Reimbursement, Life Insurance, LTD, STD, 401K, 3 weeks vacation, 9 paid holidays, casual dress code and more