Senior Claims Data Analytics Architect (Remote)

Aspire General Insurance; California (MO); Hybrid; USD 90,000 - 120,000; Full time

Job summary

Aspire General Insurance is seeking a Sr. Claims Data Analyst to transform complex claims data into actionable dashboards and insights. You will bridge Claims Operations with IT, using SQL and Power BI to drive data-driven decision making in a fast-paced environment.

The role emphasizes building robust reporting, collaborating with stakeholders, and advancing analytics capabilities across the organization. Hybrid work options and a supportive development culture are offered.

Qualifications

• 3-5+ years in a Data Analyst/BI/Analytics role.
• Strong SQL (T-SQL) experience with 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.

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.

Skills

SQL (T-SQL)

Power BI

Data analysis

Communication

Stakeholder collaboration

Education

Bachelor’s degree in Statistics/Data Science/CS/Math/Analytics

Tools

Microsoft Fabric

DirectLake

Azure Data Factory (ADF)

Lakehouse

Job description

Aspire General Insurance is seeking a Sr. Claims Data Analyst to transform complex claims data into actionable dashboards and insights. You will bridge Claims Operations with IT, using SQL and Power BI to drive data-driven decision making in a fast-paced environment.

The role emphasizes building robust reporting, collaborating with stakeholders, and advancing analytics capabilities across the organization. Hybrid work options and a supportive development culture are offered.