Actuarial Data Analyst

We need to output HTML fragment with sections: About the role? Actually we need to use headings for sections: About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. Use

for each heading. Only include sections when posting has real specific content. We have content: About the role? The posting includes "The Role description: "We are seeking a detail-oriented and analytical Actuarial Analyst..." That's about the role. So we can have

About the role

with paragraph(s). Responsibilities: we have Key Responsibilities with subpoints. So include

Responsibilities

with

• ... each bullet. Requirements? The posting has "Required Qualifications" with subparts: Experience & Education, Technical Skills, Insurance Knowledge, Core Competencies. Could treat as Requirements section. Might also have Qualifications and Skills separate but we can combine? The instruction: Use headings for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule). So we can have separate sections for Requirements, Qualifications, Skills if content exists. Let's parse. Content: - About the role: The Role paragraph. - Responsibilities: Key Responsibilities (with sub-bullets). Good. - Requirements: maybe "Required Qualifications" includes Experience & Education etc. Could be Requirements. - Qualifications: maybe same as Requirements? But we can split: Qualifications could be "Experience & Education" bullet list? However we have also "Technical Skills" and "Insurance Knowledge" and "Core Competencies". Those could be Skills section. Better: Use Requirements for Experience & Education, Qualifications for maybe "Actuarial exams such as P, FM, MAS-I, MAS-II, 5 (preferred but not required)"? Actually that's under Required Qualifications. Might be overlapping. Given instruction to prefer few substantive sections over many thin ones. So we can combine: Have About the role, Responsibilities, Requirements (which includes Experience & Education, Technical Skills, Insurance Knowledge, Core Competencies), Benefits, Pay. No Schedule (not provided). Benefits we have detailed list. Pay we have compensation range. Thus sections: About the role, Responsibilities, Requirements, Benefits, Pay. We must not repeat job title as heading. Not include Job ID etc. We must preserve all substantive information; do not invent or summarize away detail. Must include all details. We need to format lists with
  • . For prose use

    . We need to include all bullet points from Responsibilities, Required Qualifications (Experience & Education, Technical Skills, Insurance Knowledge, Core Competencies), Benefits list, Pay range. Let's extract details. About the role paragraph: "We 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, Commercial Property, and Excess Casualty. This role is perfect for someone who thrives on executing rigorous insurance analysis, collaborating cross-functionally, and delivering precise, actionable insights that drive competitive advantage. As an Actuarial Data Analyst, you will be the bridge between market intelligence, regulatory requirements, and data-driven product decisions. You will be joining a small team of actuaries playing a critical role in ensuring our products remain competitive while maintaining compliance across all jurisdictions where we operate. The actuarial team works in close partnership with underwriters and software engineers, translating actuarial insights into the technology and decisions that power a modern insurance platform." That's the role description. Responsibilities: Key Responsibilities with percentages. We need to preserve each bullet exactly. List: - Ratemaking & Competitive Intelligence (50%) - Assist in the development, pricing, and implementation of rating plans for filing with state Departments of Insurance - Support the Compliance team in the preparation, documentation, and submission of rate and form filings - 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 positioning - Analyze filings, rate manuals, underwriting guidelines, and coverage forms from industry resources including ISO manuals and NCCI data to develop detailed benchmarks and strategic recommendations - Research and draft comprehensive responses to rate-related objections, ensuring actuarial justification is provided - Actuarial Reporting & Portfolio Monitoring (25%) - Perform loss ratio analysis by line of business, territory, and risk characteristics to identify profitable segments and areas of concern - Develop and maintain reporting requirements, including bordereaux and portfolio reporting, coordinating with internal teams and external partners on data accuracy and timely delivery - Support workers’ compensation statistical reporting obligations, including WCSTAT and WCPOLS - Data Analytics (25%) - Write SQL queries to extract and analyze data related to premium volumes, loss ratios, exposure metrics, and rate change impacts from internal PostgreSQL databases - Create interactive BI dashboards using Metabase or similar platforms to track key product performance metrics - Support data transformation processes using dbt for analytics and reporting workflows We need to keep the percentages maybe as part of bullet? Could keep as part of bullet text. Now Requirements: "Required Qualifications" includes: Experience & Education - 2-5 years of experience in commercial P&C insurance product analysis, actuarial, or competitive analysis functions - Bachelor’s degree in Mathematics, Statistics, Economics, Finance, or related analytical field - Demonstrated experience with commercial insurance products and insurance data analytics - Actuarial exams such as P, FM, MAS-I, MAS-II, 5 (preferred but not required) Technical Skills - Advanced SQL proficiency for data extraction, manipulation, and analysis from PostgreSQL databases - SERFF system knowledge including navigation, filing preparation, and objection response processes - Advanced spreadsheet modeling skills for financial analysis and data manipulation - Experience with industry databases and tools including ISO manuals, NCCI data, and regulatory research platforms - Python experience for advanced analytics (preferred but not required) Insurance Knowledge - Understanding of commercial insurance products including rating methodologies and underwriting guidelines - Knowledge of state insurance filings process - Understanding of ISO forms, NCCI guidelines, and industry standard practices - Understanding of actuarial concepts including loss development, rate adequacy, and predictive modeling principles Core Competencies - Strong analytical and critical thinking skills with ability to translate data into insights and recommendations - Exceptional attention to detail and accuracy, especially for time-sensitive regulatory deliverables - Clear communication skills for both technical and non-technical audiences - Cross-functional collaboration experience working with actuarial, underwriting, compliance, and product management teams We could group these under Requirements heading with subheadings? But we only allowed headings: About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. We could make sub-sections using

    ? Not allowed? Only said use

    for section headings. Could still use

    but not specified. Safer to keep only

    headings. Could combine all into Requirements with paragraphs and lists. But we might lose distinction. However instruction: "Use

    for section headings (e.g. About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule)." It doesn't forbid other headings, but we should follow that pattern. Could we use

    for each of those categories? We have many categories; we could make separate sections for Experience & Education, Technical Skills, Insurance Knowledge, Core Competencies as Qualifications or Skills? Might be too many thin sections. Better to combine into Requirements and maybe Skills. We could have: - Requirements: Experience & Education (list) - Skills: Technical Skills + Insurance Knowledge + Core Competencies (list) But we also have Qualifications heading; maybe we put Experience & Education under Qualifications, and Technical Skills etc under Skills. Let's decide: Qualifications: Experience & Education (including degree, years, demonstrated experience, actuarial exams) Skills: Technical Skills, Insurance Knowledge, Core Competencies. That seems reasonable. Thus sections: About the role, Responsibilities, Qualifications, Skills, Benefits, Pay. We need to include all details. Now Benefits: list from "What We Offer" and then "Benefits 🏥 Premium Healthcare..." Actually there are two benefit sections: "What We Offer" includes: - Competitive salary ranging from $110,000 - $140,000 based on experience and qualifications - Equity participation with significant upside potential in our growing organization - Comprehensive benefits package including health, dental, vision, and 401(k) with company match - Professional development opportunities including conference attendance and certification support - Collaborative startup environment with opportunities for rapid career growth and expanded responsibilities Then later "Benefits 🏥 Premium Healthcare 100% contribution to top-tier health, dental, and vision 🥕 Fertility benefits and family building support 🏖️ Unlimited PTO Flexibility to take the time off, recharge, and perform 🥗 Daily lunches, dinners, and snacks We work together, and enjoy meals together too 🖥️ SF, NYC, Dallas-Fort Worth, Chicago and LA Offices 📚 Professional Development Access to premium coaching, including leadership development 🏦 Competitive 401(k) Plan 🐶 Dog-friendly office Plenty of dogs to play with and make friends with in the SF office" We need to preserve all substantive information. So combine both sets. Pay: compensation range $110K - $140K (already in What We Offer). We'll have Pay section with that. Schedule: not provided, so omit. Now produce HTML. We must not include markdown code fences. Just raw HTML. Let's craft. Structure:

    About the role

    ... (the paragraph)

    Responsibilities

    • Ratemaking & Competitive Intelligence (50%)
      • Assist in the development, pricing, and implementation of rating plans for filing with state Departments of Insurance
      • Support the Compliance team in the preparation, documentation, and submission of rate and form filings
      • 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 positioning
      • Analyze filings, rate manuals, underwriting guidelines, and coverage forms from industry resources including ISO manuals and NCCI data to develop detailed benchmarks and strategic recommendations
      • Research and draft comprehensive responses to rate-related objections, ensuring actuarial justification is provided
    • Actuarial Reporting & Portfolio Monitoring (25%)
      • Perform loss ratio analysis by line of business, territory, and risk characteristics to identify profitable segments and areas of concern
      • Develop and maintain reporting requirements, including bordereaux and portfolio reporting, coordinating with internal teams and external partners on data accuracy and timely delivery
      • Support workers’ compensation statistical reporting obligations, including WCSTAT and WCPOLS
    • Data Analytics (25%)
      • Write SQL queries to extract and analyze data related to premium volumes, loss ratios, exposure metrics, and rate change impacts from internal PostgreSQL databases
      • Create interactive BI dashboards using Metabase or similar platforms to track key product performance metrics
      • Support data transformation processes using dbt for analytics and reporting workflows
    But note nested lists: we have outer li for each category with inner ul. That's okay. Alternatively we could keep each bullet as top-level with the category as part of text. Simpler: each responsibility bullet includes the category and sub-bullets as separate li? Might be messy. I'll keep nested. Now Qualifications:

    Qualifications

    • 2-5 years of experience in commercial P&C insurance product analysis