Actuarial Analyst

Base pay range$110,000.00/yr - $140,000.00/yrAbout the RoleWe are seeking a detail-oriented and analytical Actuarial Analyst to join our actuarial team supporting multiple commercial lines of business, including General Liability, Workers' Compensation, Inland Marine, and Excess Casualty. This role is ideal for someone who thrives on executing rigorous insurance analysis, collaborating cross-functionally, and delivering precise, actionable insights that drive competitive advantage. As an Actuarial Analyst, you will bridge market intelligence, regulatory requirements, and data-driven product decisions, helping ensure our products remain competitive while maintaining compliance across all jurisdictions where we operate.Key ResponsibilitiesData Analytics & Performance Monitoring (50%)Write SQL queries to extract and analyze data related to premium volumes, loss ratios, exposure metrics, and rate change impacts from internal PostgreSQL databasesDevelop and maintain spreadsheet-based models for competitive analysis and rate monitoringCreate interactive BI dashboards using Metabase or similar platforms to track key product performance metricsSupport data transformation processes using dbt for analytics and reporting workflowsConduct analytical work including rating factor impact analysis, product performance summaries, and segmentation studies to support product design and optimizationPerform loss ratio analysis by line of business, territory, and risk characteristics to identify profitable segments and areas of concernSupport actuarial and underwriting teams with data extraction and analysis for pricing studies and rate filingsCompetitive Intelligence & Market Analysis (50%)Conduct comprehensive competitor analysis of rate and form filings across all commercial lines, utilizing SERFF, S&P Capital IQ Pro, and other regulatory databases to identify market trends and competitive positionAnalyze filings, rate manuals, underwriting guidelines, and coverage forms from industry resources including ISO manuals and NCCI data to develop detailed benchmarks and strategic recommendationsResearch and track competitor product launches, rate changes, and form modifications to inform product development and pricing strategyPrepare competitive analysis reports with recommendations for product enhancements, rate adjustments, and market positioningResearch and draft comprehensive responses to rate-related objections, ensuring actuarial justification is providedRequired QualificationsExperience & Education2-5 years of experience in commercial insurance product analysis, actuarial, underwriting, or competitive analysis functionBachelor's degree in Mathematics, Statistics, Economics, Finance, or related analytical fieldDemonstrated experience with commercial insurance products and insurance data analyticsActuarial exams such as P, FM, MAS-I, MAS-II (preferred but not required)Technical SkillsAdvanced SQL proficiency for data extraction, manipulation, and analysis from PostgreSQL databasesSERFF system knowledge including navigation, filing preparation, and objection response processesAdvanced spreadsheet modeling skills for financial analysis and data manipulationExperience with industry databases and tools including ISO manuals, NCCI data, and regulatory research platformsPython experience for advanced analytics (preferred but not required)Insurance KnowledgeUnderstanding of commercial insurance products including rating methodologies and underwriting guidelinesKnowledge of state insurance filings processesUnderstanding of ISO forms, NCCI guidelines, and industry standard practicesUnderstanding of actuarial concepts including loss development, rate adequacy, and predictive modeling principlesCore CompetenciesStrong analytical and critical thinking skills with ability to translate data into insights and recommendationsExceptional attention to detail and accuracy, especially for time-sensitive regulatory deliverablesClear communication skills for both technical and non-technical audiencesCross-functional collaboration experience with actuarial, underwriting, compliance, and product management teamsAdditional InformationWe are an equal opportunity employer. EEO statements and other legally required notices should be included here as applicable. #J-18808-Ljbffr

Created: 2025-09-17