Data Analyst
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