P&C Data Analyst

Farm Family; Richmond (VA); On-site; USD 68,000 - 98,000; Full time

Job summary

Farm Family is seeking an onsite P&C Data Analyst to develop and improve analytical models for pricing, underwriting, and portfolio management. You will work with pricing actuaries, underwriting, claims, distribution, and IT to translate questions into data-driven solutions.

The role emphasizes data quality, model governance, and collaboration across teams to deliver actionable insights and monitoring of performance over time.

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 be considered in lieu of one to two years of experience
• Proficiency in analytical programming languages and tools (e.g., SQL, Python, R)
• Experience working with large, complex datasets
• Strong analytical thinking, problem-solving, and communication skills
• Strong diligence and commitment to data quality

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 performance metrics
• Partner with actuarial, underwriting, and product teams to identify business challenges and develop data-driven recommendations
• Assist in evaluating the impact of underwriting, pricing, and product changes on business performance
• Develop recurring and ad hoc analyses that support strategic and operational decision-making
• Work with large, structured and semi-structured datasets using SQL and analytical programming languages (e.g., Python or R)
• Ensure data quality, reproducibility, and proper documentation of models, assumptions, and results
• Support adherence to model development best practices and model risk governance standards
• Support data science and predictive modeling initiatives through data preparation, feature development, exploratory analysis, and model performance reporting
• Collaborate with data scientists and actuarial partners on analytical projects involving risk segmentation, predictive modeling, and portfolio optimization
• Develop foundational skills in statistical analysis, predictive modeling, and analytical programming
• Participate in testing, monitoring, and implementation of analytical models and business rules
• Contribute to the evaluation of new data sources and analytical techniques that improve pricing and underwriting decisions
• Collaborate with actuarial, underwriting, distribution, and product stakeholders to define analytical questions and success criteria
• Translate technical analyses into clear, actionable insights using appropriate visualizations and written summaries
• Respond to feedback and iterate on analyses to better support business decisions
• Partner with technical teams to support implementation of analytical and reporting solutions
• Identify opportunities to improve reporting processes, data quality, analytical efficiency, and business insights
• Stay current on industry trends, pricing methodologies, and analytical best practices within P&C insurance
• Contribute ideas for improving models, processes, and data usage within the pricing analytics function

Skills

Analytical thinking

Communication

Education

Bachelor's degree in quantitative field

Master's degree may substitute 1–2 years experience

Tools

SQL

Python

R

Job description

This is an onsite position, available in New York, Chicago, Albany, Richmond or Omaha.

The P&C Data Analyst supports the development and improvement of analytical models and insights that inform pricing, underwriting, and portfolio management decisions. This role applies data analysis techniques to insurance data to improve risk segmentation and rate adequacy, supporting profitable growth across products and locations.

The P&C Data Analyst works closely with pricing actuaries, underwriting, claims, distribution, product partners, data experts, and IT professionals to translate business questions into analytical solutions and monitor performance over time. This role operates with moderate independence while receiving guidance on more complex problems.

Key Responsibilities

Pricing & Insurance Analytics

• 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 performance metrics
• Partner with actuarial, underwriting, and product teams to identify business challenges and develop data-driven recommendations
• Assist in evaluating the impact of underwriting, pricing, and product changes on business performance
• Develop recurring and ad hoc analyses that support strategic and operational decision-making

Data & Technical Skills

• Work with large, structured and semi‑structured datasets using SQL and analytical programming languages (e.g., Python or R)
• Ensure data quality, reproducibility, and proper documentation of models, assumptions, and results
• Support adherence to model development best practices and model risk governance standards

Advanced Analytics & Data Science Support

• Support data science and predictive modeling initiatives through data preparation, feature development, exploratory analysis, and model performance reporting
• Collaborate with data scientists and actuarial partners on analytical projects involving risk segmentation, predictive modeling, and portfolio optimization
• Develop foundational skills in statistical analysis, predictive modeling, and analytical programming
• Participate in testing, monitoring, and implementation of analytical models and business rules
• Contribute to the evaluation of new data sources and analytical techniques that improve pricing and underwriting decisions

Business Partnership & Communication

• Collaborate with actuarial, underwriting, distribution, and product stakeholders to define analytical questions and success criteria
• Translate technical analyses into clear, actionable insights using appropriate visualizations and written summaries
• Respond to feedback and iterate on analyses to better support business decisions
• Partner with technical teams to support implementation of analytical and reporting solutions
• Identify opportunities to improve reporting processes, data quality, analytical efficiency, and business insights
• Stay current on industry trends, pricing methodologies, and analytical best practices within P&C insurance
• Contribute ideas for improving models, processes, and data usage within the pricing analytics function

Required 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 be considered in lieu of one to two years of experience
• Proficiency in analytical programming languages and tools (e.g., SQL, Python, R)
• Experience working with large, complex datasets
• Strong analytical thinking, problem‑solving, and communication skills
• Strong diligence and commitment to data quality

Preferred Qualifications

• Experience in Property & Casualty insurance, preferably supporting actuarial, underwriting, claims, or product
• Familiarity with statistical analysis, predictive modeling, or machine learning concepts
• Experience with data lineage, data mapping, validation, and reconciliation processes
• Exposure to cloud-based analytics platforms and modern data environments
• Understanding of insurance data structures, coverages, rating variables, and policy lifecycle processes
• Experience working in Agile or cross-functional project environments

The base salary range provided below is for hires in those geographic areas only and will be commensurate with candidate experience. Pay ranges for candidates in other locations may differ based on the cost of labor in that location.

• Albany, Richmond & Chicago Pay Range $68,000 - $95,000
• New York City Pay Range $70,000 - $98,000