Senior Claims Data Analyst

Pie's mission is to empower small businesses to thrive by making commercial insurance affordable and as easy as pie. We leverage technology to transform how small businesses buy and experience commercial insurance.   Like our small business customers, we are a diverse team of builders, dreamers, and entrepreneurs who are driven by core values and operating principles that guide every decision we make.

The Senior Claims Data Analyst will play a pivotal role in transforming raw claims data into actionable insights that drive strategic decisions within our organization. This role is responsible for retrieving and compiling large and complex datasets from various claims systems, databases and external sources. This position involves understanding data structures, ensuring data integrity and implementing efficient data extraction processes. The role will involve cleaning, validating, and transforming raw data to ensure accuracy, consistency, and suitability for analysis; including identifying and resolving data quality issues, handling missing data and standardizing data formats. The Analyst will translate complex data findings into clear, concise and visually appealing reports, dashboards, and presentations. They will work closely with cross-functional teams.

How You’ll Do It

Manage Data Extraction and Management

• Conduct data quality audits and work with IT to resolve data discrepancies.
• Documenting analytical methodologies and reporting processes.
• Gather and interpret complex datasets related to insurance claims, policies, and customer profiles.
• Ensure data integrity by cleaning, validating, and maintaining large claims databases.
• Develop and implement data improvement strategies in collaboration with IT teams.

Develop Reporting and Visualizations

• Develop and maintain manual and automated reports on key claim metrics.
• Create and maintain dashboards and reports to provide insights to stakeholders and management.
• Utilize data visualization tools (e.g.,Looker, Excel) to present claims trends and patterns.
• Prepare comprehensive reports identifying key performance indicators and operational risks.
• Automate reporting processes to streamline data accessibility and improve decision-making.

Manage Claims Analytics and Reporting

• Perform deep-dive analysis on specific claim types or loss events to identify contributing factors and potential mitigation strategies. 
• Perform statistical analysis to identify trends, anomalies, and predictive insights in claims data.
• Evaluate claims processing effectiveness and recommend data-driven solutions.
• Monitor and assess the impact of regulatory changes on claims data and reporting.

Communication and Collaboration with Internal and External Teams

• Participate in cross-functional projects aimed at improving claims operations.
• Communicate findings to non-technical stakeholders through clear and actionable insights.
• Support cross-functional initiatives by integrating claims data into broader business strategies.
• Partner with claims adjusters and fraud investigators to enhance claims accuracy and fraud prevention.

The Right Stuff

• Bachelor’s Degree required.
• 3+ years Technical Skills with demonstrated experience building data visualization tools and reporting.
• 3+ years Quantifying, measuring, and analyzing  claim data.
• 2+ years Claim systems/process knowledge and experience.
• Working knowledge of claims processes and general requirements.
• Ability to communicate technical information to both technical and non-technical teams.
• Ability to troubleshoot issues and resolve problems effectively.
• Strong understanding of Reporting systems, Data Visualization Tools and claims applications.
• Ability to work effectively with others in a team environment.
• Ability to analyze data, identify trends, and recommend solutions.

The use of AI in Application Review: To support a fair, efficient, and consistent hiring process, we use AI-powered tools to assist in the initial screening of applications. These tools help us identify qualifications and prior work experiences that align with the requirements of the role. All AI-reviewed applications are still subject to human oversight and decision-making at multiple stages of the process. By submitting your application, you acknowledge and consent to Pie utilizing these AI technologies to assist in our evaluation process.

Base Compensation Range$90,000—$115,000 USD

Compensation & Benefits 

• Competitive cash compensation
• A piece of the pie (in the form of equity)
• Comprehensive health plans
• Generous PTO
• Future focused 401k match
• Generous parental and caregiver leave
• Our core values are more than just a poster on the wall; they’re tangibly reflected in our work 

Our goal is to make all aspects of working with us as easy as pie. That includes our offer process. When we’ve identified a talented individual who we’d like to be a Pie-oneer , we work hard to present an equitable and fair offer. We look at the candidate’s knowledge, skills, and experience, along with their compensation expectations and align that with our company equity processes to determine our offer ranges. 

Each year Pie reviews company performance and may grant discretionary bonuses to eligible team members.

Location Information 

Unless otherwise specified, this role has the option to be hybrid or remote. Hybrid work locations provide team members with the flexibility of working partially from our Denver office and from home. Remote team members must live and work in the United States* (*territories excluded), and have access to reliable, high-speed internet.

Additional Information

Pie Insurance is an equal opportunity employer. We do not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity, marital status, age, disability, national or ethnic origin, military service status, citizenship, or other protected characteristic.

Pie Insurance participates in the E-Verify program. Please click here, here and here for more information.

Pie Insurance is committed to protecting your personal data. Please review our Privacy Policy.  

Safety First: Pie Insurance is committed to your security during the recruitment process. We will never ask you for credit card information or ask you to purchase any equipment during our interview or onboarding process.

Pie Named to 2025 America's Best Startup Employers

Pie's Ford Pro Insure Coverage expanded to Pennsylvania and Texas

Pie Insurance 2025 State of Workplace Safety Report

 

#LI-REMOTE #BI-REMOTE