P&C Data Analytics Specialist

Farm Family; City of Albany, Northern (NY, KY); Hybrid; USD 68,000 - 95,000; Full time

Benefits offered by this job

Health insurance

Dental insurance

Vision insurance

401(k) with company match

Paid time off (PTO)

Professional development opportunities

Job summary

Farm Family is seeking a P&C Data Analyst to support pricing analytics, underwriting insights, and portfolio management. You will translate business questions into analytical solutions, collaborating with actuaries, underwriters, and product partners, and monitor model performance over time.

Strong SQL and Python or R skills are required, along with a quantitative degree and 2–4 years of experience. You will contribute to data science initiatives while ensuring data quality and reproducibility

Qualifications

• Bachelor’s degree in mathematics, statistics, actuarial science, computer science, data science, or a related quantitative field.
• Two to four years of relevant experience in data science, analytics, actuarial support, or related quantitative roles; a master’s degree may substitute.
• Proficiency in analytical programming languages and tools (SQL, Python, R).
• Experience working with large, complex datasets; strong analytical thinking and communication skills.

Responsibilities

• Support pricing analyses, rate reviews, segmentation evaluations, portfolio monitoring, and performance assessments across Personal and Commercial Lines products.
• Analyze trends in frequency, severity, retention, growth, profitability, and other key insurance metrics.
• Partner with actuarial, underwriting, and product teams to identify business challenges and develop data-driven recommendations.

Skills

SQL

Python

R

Analytical thinking

Communication

Data quality

Education

Bachelor’s degree in a quantitative field

Master’s degree may substitute experience

Tools

SQL

Python

R

Job description

Farm Family is seeking a P&C Data Analyst to support pricing analytics, underwriting insights, and portfolio management. You will translate business questions into analytical solutions, collaborating with actuaries, underwriters, and product partners, and monitor model performance over time.

Strong SQL and Python or R skills are required, along with a quantitative degree and 2–4 years of experience. You will contribute to data science initiatives while ensuring data quality and reproducibility