Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Actuarial Data Analyst

$110k - $140k

Shepherd

Actuarial Analyst

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-functional, 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.

Key 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
Required Qualifications

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
What We Offer
  • 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
Vacancy posted 21 hours ago
Similar jobs that could be interesting for youBased on the Actuarial Data Analyst in Chicago, IL vacancy
  •  ...Senior Actuarial AnalystThe Senior Actuarial Analyst contributes to development, delivery and related consulting on health and welfare financial work for...  ...Lockton's Midwest Series. They will leverage and analyze data in collaboration with other financial and client... 
    Suggested
    Local area

    Lockton

    Chicago, IL
    2 days ago
  • $57.5k - $103.8k

     ...maintenance, and basic analysis of models, studies, and systems that use actuarial principles for the purposes of pricing, underwriting,...  ...insurance actuarial experience preferred Strong analytical and data modeling skills This is a Hybrid role with a 3 day in office... 
    Suggested
    Full time
    Work at office
    Visa sponsorship
    Flexible hours
    3 days per week

    HCSC

    Chicago, IL
    21 hours ago
  •  ...Entry-Level Health Actuarial AnalystEntry-level analyst in a broad insurer function closer to a large-carrier analyst track than a reserving cycle role because the scope spans several actuarial functions rather than one reporting process. Entry-level Health actuarial... 
    Suggested
    Internship
    Work at office
    Remote work
    Visa sponsorship

    Acturhire

    Chicago, IL
    17 hours ago
  •  ...Job Summary We are seeking an Actuarial Analyst to provide actuarial pricing support for Westfield's US Specialty lines of business. In...  ...enhancements for unique structures and implementing more comprehensive data capture Collaborate with underwriting teams to perform... 
    Suggested
    Internship
    Work at office

    ohio farmers insurance

    Chicago, IL
    17 hours ago
  •  ...Culture, Great Rewards, and Great Careers.About the Role:GEICO is looking for a Senior Actuarial Analyst to join the Reserving Team. The Reserving team is responsible for analyzing claims data and recommending reserves. Reserving books reserves monthly, performs in-depth... 
    Suggested
    Hourly pay
    Work experience placement
    Local area

    GEICO

    Chicago, IL
    3 days ago
  •  ...Senior Health Actuarial Consulting RoleClient-facing health actuarial consulting closer to client consulting than a modelling-heavy individual...  ...group health clients. You'll analyze claims and utilization data, contribute to pricing, reserving, plan design modeling and... 

    Acturhire

    Chicago, IL
    2 days ago
  •  ...GRS has an opening for a full-time Actuarial Analyst in its Chicago, Illinois office providing technical support and assistance to consultants...  ...at GRS are as follows: Prepare client information and data for analysis Prepare and complete actuarial valuations... 
    Full time
    Work at office

    Gabriel Roeder Smith & Co.

    Chicago, IL
    21 hours ago
  • $120k - $135k

    Senior Actuarial AnalystDRIVE PROFITABLE GROWTH FOR THE BUSINESSAbout At-BayAt-Bay is the world...  ...Pricing team:As an Senior Actuarial Analyst on the Pricing team, you will be working...  ...- to support key business decisions with data backed insights and a deep understanding... 

    At-Bay

    Chicago, IL
    2 days ago
  • $20.91 - $45.04 per hour

     ...and sensor solutions enable the distribution of power, signal and data to advance next-generation transportation, renewable energy,...  ...through advanced analytics partnering closely with the Senior Analyst and cross-functional business stakeholders to drive insights across... 
    Remote job
    Work experience placement
    Summer work
    Internship
    Local area

    TE Connectivity

    Chicago, IL
    1 day ago
  •  ...talented individual to join Mercer’s Health Actuarial and Financial Group (AFG). This is a...  ..., consistent approaches to benchmarking, data analytics, financial management, marketing...  ...responsibilities comparable to full‑time analysts with support from experienced colleagues... 
    Permanent employment
    Full time
    Internship
    Work at office
    Local area
    Remote work
    Flexible hours
    3 days per week
    1 day per week

    Marsh

    Chicago, IL
    4 days ago
  • Mercer seeks a driven student to join its Health Actuarial and Financial Group in a hybrid role requiring three days in the office weekly. You will analyze health care data, assist in client communications, and help develop pricing for plan designs under supervision. This... 
    Work at office

    Marsh

    Chicago, IL
    4 days ago
  • $122.5k

     ...Applicants: Please submit your application through our online portal by our deadline: August 11, 2026 for consideration. The Data Analyst Role This role is open to candidates in Boston, New York, Washington, D.C., Chicago, LA, Silicon Valley, and San Francisco.... 
    Full time
    Work experience placement
    H1b
    Work at office
    Local area
    Visa sponsorship

    Cornerstone Research

    Chicago, IL
    17 hours ago
  • $47k - $78k

     ...Actuarial Position You have a clear vision of where your career can go. And we have the leadership to help you get there. At CNA, we...  ...guidelines: Analyzes financial, statistical and mathematical data and performs actuarial calculations to identify trends driving... 
    Work experience placement
    Work at office

    CNA

    Chicago, IL
    1 day ago
  •  ...Financial Analyst Intern Lockton is looking for summer interns to join our Financial team...  ...'s benefit offering against normative data Become familiar with contracts, communications...  ...in December 2027 or May 2028 Major in actuarial science preferred, but open to majors in... 
    Summer work
    Internship
    Summer internship
    Local area

    Lockton

    Chicago, IL
    4 days ago
  •  ...OP) cycle, which is used to align business functions and drive strategic decision-making. Job Description The Supply Chain Data Analyst Intern will have the opportunity to manage a portion of a Demand Analyst portfolio, which offers real-time experience in demand... 
    Summer work
    Internship
    Summer internship
    Relocation

    Motorola Solutions

    Chicago, IL
    4 days ago
  • $98.99k - $137.13k

     ...place you can engage in meaningful work and grow your career. Let’s see what we can achieve. Together.SummaryThe Senior Financial Data Analyst, working in collaboration with and in support of the firm’s strategic initiatives, in the Data Analytics group is responsible... 
    Full time
    Work at office
    Remote work
    Relocation
    Visa sponsorship
    Relocation package

    DLA Piper

    Chicago, IL
    4 days ago
  • $116.88k - $151.25k

     ...iconic areas. Role Overview: We are seeking a Senior Quantitative Analyst with a strong product development mindset to analyze exchange...  ...The ideal candidate brings experience in quantitative finance, data analytics, and statistical modeling, with the ability to turn complex... 
    Full time
    Work at office
    Immediate start

    Cboe Exchange

    Chicago, IL
    22 hours ago
  •  ...Front-Office Risk Data Quality Analyst Company Overview Business Integration Partners (BIP) is Europe’s fastest growing digital consulting company and are on track to reach the Top 20 by 2030, with an expanding global footprint in the US (New York, Charlotte, Chicago... 
    Temporary work
    Remote work
    Worldwide

    BIP US

    Chicago, IL
    3 days ago
  • $110k - $150k

     ...Reinsurance Actuarial Senior Analyst and or Associate Director Location: New York City, Chicago IL, Philadelphia PA, Bloomington MN, Virtual...  ...services Inventory and manage client as well as industry data Analyze the costs and benefits of risk transferred under... 
    Full time
    Temporary work
    Part time
    Local area

    AON

    Chicago, IL
    17 hours ago
  • $162k - $212k

     ...integrity of our marketsand our partners' programs by catching fraud and abuse before it costs anyone money. As aStaff Product Data Analyst, you'll own building and maintaining the in-house detection layer— the models and rules that flag wash trading, collusion, and eval... 
    Work at office
    Remote work
    Worldwide
    Monday to Friday
    Flexible hours

    NinjaTrader Group

    Chicago, IL
    2 days ago
  •  ...Unified Communications (UC) Group. We are unifying siloed voice and data networks into an ecosystem that provides actionable intelligence...  ...fieldExperience: 2 to 4 years of experience as a data analyst, financial analyst, strategy analyst, or in a product growth/management... 
    Full time
    Shift work

    Indigo Vision

    Chicago, IL
    17 hours ago
  • $150k - $175k

     ...StatesSchedule: DayPosted: 2026-10-12Great decisions start with trusted data. In this role, you will help build the enterprise reporting and...  ..., and run the business with confidence.As Lead Finance Data Analyst - Enterprise Performance Reporting, you will turn complex... 
    Full time
    Work at office
    3 days per week

    UL Company

    Chicago, IL
    1 day ago
  •  ...Graycor is seeking a Construction Technology & Data Analyst to support the Construction Technology Manager in managing data, improving processes, developing companywide reporting tools, and evaluating, implementing, and continuously improving technology. Technology... 
    Full time

    Graycor

    Chicago, IL
    1 day ago
  •  ...An established financial firm is adding to its data team as the business continues to invest in its analytics capabilities. This is an opportunity for someone who enjoys working with data but also wants to understand the business behind it. The position offers a lot... 

    Access Search, Inc.

    Chicago, IL
    15 days ago
  •  ...We are partnering with a highly quantitative, data-driven organization seeking a Data Analyst to support reporting, analytics, and data management initiatives across a complex business environment. This role sits at the intersection of data, operations, and business stakeholders... 

    Selby Jennings

    Chicago, IL
    15 days ago
  •  ...JCW Group is partnering with a leading financial institution to find a Data Governance Analyst to join their growing data team. This is a great opportunity for someone early in their data career who wants to learn from experienced leaders and help shape how a large organization... 
    Full time

    JCW Group

    Chicago, IL
    17 hours ago
  • $71.7k - $131.91k

     ...broader Milliman Medicaid Consulting Group consisting of 600+ professionals, including actuaries, healthcare consultants, attorneys, and statisticians.ResponsibilitiesAnalyzing healthcare data, including:Claims datasets including services such as hospital, physician, and... 
    Full time
    Temporary work
    Work experience placement
    Work at office
    Remote work
    Worldwide
    Flexible hours

    Milliman

    Chicago, IL
    4 days ago
  • IT - Data Analyst - ExpertJob#: 3052578Job Description:IT - Data Analyst - ExpertLocation: Chicago, Illinois (Hybrid)Role OverviewOur organization is seeking an AML Reporting, Data Governance & Analytics Lead to support the U.S. AML Transformation, Delivery, and Insights... 

    Apex Systems

    Chicago, IL
    9 hours ago
  •  ...Data Analyst The Data Analyst is responsible for collecting, analyzing, interpreting, and presenting clinical, operational, financial, and organizational data to support effective decision-making and continuous improvement across the organization. The Data Analyst... 
    Flexible hours

    Alivio Medical Center

    Chicago, IL
    21 hours ago
  •  ...supporting our medical insurance client, Blue Cross Blue Shield Association (BCBSA) in Chicago, IL!! BCBSA is seeking a fully remote SQL Data Analyst with a completed bachelor's degree, along with healthcare industry experience and 8+ years coding in SQL, Python and R Language... 
    Contract work
    Remote work

    3B Staffing LLC

    Chicago, IL
    21 hours ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Actuarial Data Analyst. Be the first to apply!