Data Analyst - P&C jobs in United States
cer-icon
Apply on Employer Site
company-logo

Wall Street Consulting Services LLC · 16 hours ago

Data Analyst - P&C

Wall Street Consulting Services LLC is seeking a Data Analyst in Property & Casualty insurance. The role focuses on analyzing policy, claims, underwriting, and loss data to support risk assessment, pricing, profitability, and regulatory reporting.

Big DataBusiness IntelligenceConsultingCRMEnterprise Resource Planning (ERP)
check
H1B Sponsor Likelynote
Hiring Manager
Srinivas Pavuluri
linkedin

Responsibilities

Analyze policy, premium, claims, and loss data across lines like Auto, Home, Workers’ Comp, Liability
Perform loss ratio, combined ratio, and profitability analysis
Support underwriting with risk insights and trend analysis
Analyze claims severity & frequency , leakage, and fraud indicators
Build dashboards for claims performance, exposure, reserves, and renewals
Work with actuarial and underwriting teams to validate assumptions
Ensure data quality and reconciliation across policy admin & claims systems
Support regulatory and compliance reporting (state filings, audits)
Identify trends impacting pricing, retention, and risk exposure

Qualification

SQLPython / RExcelBI ToolsData modelingData validation

Required

Analyze policy, premium, claims, and loss data across lines like Auto, Home, Workers' Comp, Liability
Perform loss ratio, combined ratio, and profitability analysis
Support underwriting with risk insights and trend analysis
Analyze claims severity & frequency, leakage, and fraud indicators
Build dashboards for claims performance, exposure, reserves, and renewals
Work with actuarial and underwriting teams to validate assumptions
Ensure data quality and reconciliation across policy admin & claims systems
Support regulatory and compliance reporting (state filings, audits)
Identify trends impacting pricing, retention, and risk exposure
SQL (strong – joins, CTEs, window functions)
Python / R (pandas, NumPy for analysis)
Excel (advanced formulas, pivots)
BI Tools: Power BI / Tableau
Data modeling & data validation

Company

Wall Street Consulting Services LLC

twittertwitter
company-logo
“Why wait for change? Drive it yourself!” At Wall Street the next generation IT solutions meet the next generation career opportunities.

H1B Sponsorship

Wall Street Consulting Services LLC has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (23)
2024 (28)
2023 (22)
2022 (11)
2021 (10)
2020 (5)

Funding

Current Stage
Growth Stage
Company data provided by crunchbase