Wall Street Consulting Services LLC
Data Analyst - P&C
⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is a Data Analyst - P&C for a contract length of "X months" at a pay rate of "$X/hour". Required skills include strong SQL, Python/R, advanced Excel, and experience with BI tools like Power BI/Tableau, specifically in Property & Casualty insurance.
🌎 - Country
United States
💱 - Currency
$ USD
-
💰 - Day rate
Unknown
-
🗓️ - Date
February 27, 2026
🕒 - Duration
Unknown
-
🏝️ - Location
Unknown
-
📄 - Contract
Unknown
-
🔒 - Security
Unknown
-
📍 - Location detailed
New Jersey, United States
-
🧠 - Skills detailed
#Data Quality #R #Microsoft Power BI #Tableau #Trend Analysis #Python #Data Modeling #Data Analysis #NumPy #Pandas #SQL (Structured Query Language) #BI (Business Intelligence) #Compliance
Role description
A Data Analyst in Property & Casualty insurance focuses on analyzing policy, claims, underwriting, and loss data to support risk assessment, pricing, profitability, and regulatory reporting.
Key Responsibilities (P&C-specific)
• 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
Core Skills Required
Technical
• 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
A Data Analyst in Property & Casualty insurance focuses on analyzing policy, claims, underwriting, and loss data to support risk assessment, pricing, profitability, and regulatory reporting.
Key Responsibilities (P&C-specific)
• 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
Core Skills Required
Technical
• 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
