Claims - Data Analyst I - III

Company Overview

Role Overview

Starting Pay

• The annual pay range is $55,000 to $90,000.
• Pay depends on education, experience, location, knowledge, skills, and abilities.
• Eligible associates may receive annual cash bonuses and stock incentives based on company and individual performance.

Responsibilities

• Participate in or lead customer meetings to understand data and reporting needs.
• Create routine and ad hoc reports, dashboards, and trending analyses.
• Extract and validate information from multiple data sources.
• Perform statistical analyses and summarize results.
• Identify trends and provide actionable insights.
• Partner with IT to resolve data issues, document requirements, and test system enhancements.
• Understand claims data flows across source systems, downstream systems, portals, and data warehouses.
• Improve reporting processes, automation, and data accuracy.
• Review data requests independently and deliver timely reporting.
• Serve as a Claims data subject matter expert and mentor analysts as appropriate.

Required and Preferred Qualifications

• A bachelor’s degree in business, mathematics, statistics, information technology, or a related field, or related experience.
• Advanced Microsoft Excel skills, including pivot tables, Power Query, combination charts, VLOOKUPs, and complex calculations.
• Experience with data analysis, reporting, data extraction queries, statistical analysis, data models, and PowerPivot.
• Strong problem-solving, communication, presentation, relationship-building, and organizational skills.
• Knowledge of insurance and risk management is preferred.
• Experience with Power BI, SAP Business Warehouse, Cognos, SAS, R, SPSS, VBA, SQL, DAX, or similar tools is preferred.
• Professional insurance designations are preferred but not required.

Benefits and Amenities

• The company offers benefits and amenities intended to support associate well-being, service, professional development, and long-term career growth.