P&C Data Analyst

Company Farm Family Farm Family specializes in farm and ranch protection with a wide range of products including flexible farm packages, business owner policies, commercial package, workers compensation, commercial auto and select personal auto coverage. Farm Family is a leader in serving the Northeast and Mid-Atlantic markets and is pursuing growth across the U.S. The Farm Family entities are wholly-owned subsidiaries of Clearbrook Group Holdings Inc. Job Description 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 productsAnalyze trends in frequency, severity, retention, growth, profitability, and other key insurance performance metricsPartner with actuarial, underwriting, and product teams to identify business challenges and develop data-driven recommendationsAssist in evaluating the impact of underwriting, pricing, and product changes on business performanceDevelop 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 resultsSupport 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 reportingCollaborate with data scientists and actuarial partners on analytical projects involving risk segmentation, predictive modeling, and portfolio optimizationDevelop foundational skills in statistical analysis, predictive modeling, and analytical programmingParticipate in testing, monitoring, and implementation of analytical models and business rulesContribute 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 criteriaTranslate technical analyses into clear, actionable insights using appropriate visualizations and written summariesRespond to feedback and iterate on analyses to better support business decisionsPartner with technical teams to support implementation of analytical and reporting solutions Continuous Improvement Identify opportunities to improve reporting processes, data quality, analytical efficiency, and business insightsStay current on industry trends, pricing methodologies, and analytical best practices within P&C insuranceContribute 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 fieldTwo to four years of relevant experience in data science, analytics, actuarial support, or related quantitative rolesA master’s degree may be considered in lieu of one to two years of experienceProficiency in analytical programming languages and tools (e.g., SQL, Python, R)Experience working with large, complex datasetsStrong analytical thinking, problem‑solving, and communication skillsStrong diligence and commitment to data quality Preferred Qualifications Experience in Property & Casualty insurance, preferably supporting actuarial, underwriting, claims, or productFamiliarity with statistical analysis, predictive modeling, or machine learning conceptsExperience with data lineage, data mapping, validation, and reconciliation processesExposure to cloud-based analytics platforms and modern data environmentsUnderstanding of insurance data structures, coverages, rating variables, and policy lifecycle processesExperience 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,000New York City Pay Range $70,000 - $98,000 Please Note Applicants must be legally authorized to work in the United States. At this time, we are not able to sponsor or assume sponsorship of employment visas. If you have a disability under the Americans with Disabilities Act or similar state or local law and you wish to discuss potential reasonable accommodations related to applying for employment with us, please contact our Benefits Department at 210-321-8400. Benefits And Compensation We offer a competitive compensation package, performance-based incentives, and a comprehensive benefits program—including health, dental, vision, 401(k) with company match, paid time off, and professional development opportunities. Core Values At Clearbrook our Core Values are Integrity, Collaboration, Pursuit of Excellence and Forward Thinking. These values reflect who we are today and who we aspire to be - guiding how we work, how we lead and how we succeed.