Claims Data Manager

Aspire General Insurance; Rancho Cucamonga (CA); Hybrid; USD 130,000 - 170,000; Full time

Job summary

Aspire General Insurance is seeking a Claims Data Manager in a hybrid IT environment. The role bridges business operations and technology to transform claims data into dashboards, reports, insights, and recommendations that drive performance.

The ideal candidate has 3–5+ years in data analytics or BI, strong SQL and Power BI skills, and the ability to work with large datasets while collaborating with stakeholders across the business and IT teams.

Qualifications

• 3–5+ years in data analytics, BI, or analytics roles.
• Strong SQL (T-SQL) with complex queries and stored procedures.
• Advanced Power BI with dashboards, reporting, and DAX.
• Ability to work independently with large datasets.
• Strong analytical, problem-solving, and communication skills.
• Ability to translate findings into actionable business recommendations.
• Experience collaborating with business stakeholders and technical teams.

Responsibilities

• Develop and maintain SQL queries and procedures to support reporting and decision-making.
• Design, build, and enhance Power BI dashboards using Fabric and DirectLake.
• Support operational dashboards for claims performance and analytics.
• Perform trend analysis, forecasting, and exploratory analytics.
• Identify leakage, anomalies, fraud indicators, and inefficiencies.
• Create performance scorecards and workforce productivity reporting.
• Conduct statistical analyses on severity, closing ratios, and reserves.
• Translate business questions into meaningful reports and insights.
• Partner with IT/Data Engineering to ensure data integrity and reliability.
• Evaluate AI-assisted analytics solutions to improve outcomes.
• Maintain reporting standards, governance, and documentation.
• Stay updated on analytics trends and best practices.

Skills

SQL (T-SQL)

Power BI

Independent work

Analytical skills

Stakeholder collaboration

Communication skills

Education

Bachelor's in a quantitative field

Tools

Microsoft Fabric

DirectLake

Azure Data Factory

Lakehouse

Job description

Department: ITAre you looking for more than just a job? Do you want a career with a growing, stable organization where your ideas are valued, your contributions make an impact, and your professional development is supported?

Description

Claims Data Manager

Aspire General Insurance | Full-Time

Department: IT

Are you looking for more than just a job? Do you want a career with a growing, stable organization where your ideas are valued, your contributions make an impact, and your professional development is supported? At Aspire General Insurance, you'll join an established and collaborative team where innovation is encouraged, continuous learning is embraced, and career growth is a priority. If you're passionate about leveraging data to drive business decisions and want to be part of an organization investing in its future, we'd love to speak with you.

Required Qualifications

• 3-5+ years of experience in a Data Analyst, Business Intelligence, or Analytics role.
• Strong SQL (T-SQL) experience, including writing and troubleshooting complex queries and stored procedures.
• Advanced Power BI experience, including dashboard development, reporting, and DAX.
• Ability to work independently with large and complex datasets.
• Strong analytical, problem-solving, and communication skills.
• Ability to translate technical findings into actionable business recommendations.
• Experience collaborating with business stakeholders and technical teams.

Preferred Qualifications

• Bachelor's degree in Statistics, Data Science, Computer Science, Actuarial Science, Mathematics, Business Analytics, or a related quantitative field.
• Insurance, Financial Services, or Claims Operations experience.
• Knowledge of Personal Auto Insurance and claims data.
• Experience with Microsoft Fabric, DirectLake, Azure Data Factory (ADF), and Lakehouse environments.
• Familiarity with actuarial concepts such as loss ratio, claim severity, and reserve adequacy.
• Experience utilizing AI-assisted analytics and reporting tools.

About The Role

Under the direction of the Director of Claims Reporting & Analytics, the Claims Data Manager serves as a key analytics partner to Claims Operations. This role bridges the gap between business operations and technology by transforming complex claims data into meaningful dashboards, reporting, insights, and recommendations that drive business performance.

The ideal candidate is equally comfortable working with SQL and Power BI as they are partnering with business leaders to solve operational challenges and improve decision-making.

Job Responsibilities

• Develop and maintain SQL queries and stored procedures to support reporting, analysis, and operational decision-making.
• Design, build, and enhance Power BI dashboards and reports utilizing Microsoft Fabric and DirectLake technologies.
• Support the development of operational dashboards, including Casualty, SIU, and claims performance reporting.
• Perform trend analysis, forecasting, and exploratory analytics to identify emerging risks and business opportunities.
• Analyze claims data to identify leakage, payment anomalies, fraud indicators, and operational inefficiencies.
• Develop performance scorecards and workforce productivity reporting.
• Conduct statistical analyses to evaluate claim severity, closing ratios, reserve activity, and operational effectiveness.
• Translate business questions into meaningful reporting and actionable insights.
• Partner with IT and Data Engineering teams to ensure data integrity and reporting reliability.
• Evaluate and implement AI-assisted analytics solutions to improve business outcomes.
• Maintain reporting documentation, standards, and governance practices.
• Stay current on industry trends, technology advancements, and analytics best practices.

What Success Looks Like

• Delivering accurate, timely, and impactful reporting.
• Providing meaningful insights that influence business decisions.
• Identifying opportunities for operational improvement and efficiency.
• Building strong partnerships across Claims, IT, and Leadership teams.
• Contributing to a culture of innovation, collaboration, and continuous improvement.

Work Environment

• Professional office environment or approved remote/hybrid setting.
• Frequent use of SQL, Power BI, reporting platforms, and business intelligence tools.
• Regular interaction with Claims Operations, IT, leadership teams, and key stakeholders.
• Fast-paced environment requiring strong prioritization, organization, and analytical thinking.
• Occasional travel may be required.

Physical Requirements

• Ability to work at a computer for extended periods.
• Ability to analyze large data sets and review reports across multiple screens.
• Ability to communicate effectively with technical and non-technical audiences.
• Ability to perform the essential functions of the role with or without reasonable accommodation.

Why Aspire?

At Aspire General Insurance, we believe great people drive great results. We invest in our employees, encourage innovation, and provide opportunities for growth and advancement. If you're looking for a company where you can learn, contribute, and build a long-term career, we'd love to hear from you.

Aspire General Insurance is an Equal Opportunity Employer.