Key Facts

Remote From:

Full time

85 - 90K yearly

English

Hard Skills

Pricing Strategies SQL (Programming Language) Analytical Dashboard Data Modeling Microsoft Access Presentation Design Data Manipulation Underwriting Database Analysis Insurance Regulatory Law Vlookups Power BI Actuarial Science Online Communication Project Management Organizational Structure

Other Skills

•
Financial Acumen
•
Microsoft Office
•
Non-Verbal Communication
•
Time Management
•
Teamwork

Roles & Responsibilities

Bachelor's degree or equivalent required; major in Math, Economics, or Finance preferred.
Experience creating, modifying and running SQL scripts.
Intermediate to advanced Excel (VLOOKUPs, PivotTables) and Access; knowledge of Power BI a plus.
Strong analytical skills with financial acumen; excellent verbal and written communication; excellent organization and time management.

Requirements:

Develop reports and product dashboards to monitor the FAIR Plan’s profitability, efficiency, and growth of new products/enhancements.
Collaborate with actuarial staff to prepare state rate filings and respond to state insurance department inquiries.
Query databases to conduct ad-hoc analysis and support research, analysis, and testing of product changes and channel enhancements.
Lead cross-department projects to explore business problems and drive improvements in underwriting processes and performance.

California FAIR Plan Association

Insurance

About California FAIR Plan Association

The California FAIR Plan is a private association comprised of all insurers authorized to write property insurance in California. The FAIR Plan was established in July 1968 following the 1960s brush fires and riots as the state’s insurer of last resort, created to ensure access to basic property insurance for California homeowners who have been unable to obtain homeowners insurance from the voluntary market for reasons outside of their control. The FAIR Plan will write fire insurance coverage for these homeowners, regardless of a property’s wildfire risk. The FAIR Plan is committed to strengthening consumer choices in the voluntary insurance market, while ensuring that all homeowners, including those who live in areas threatened by wildfires, can obtain basic property coverage and the peace of mind they deserve.

Company type: SME

Industry: Insurance

Founded: 2018

Company size: 51 - 200

Website LinkedIn See all jobs →

Job description

POSITION SUMMARY
The Product Analyst is primarily responsible for querying the data necessary for the development, production, maintenance, enhancement of key performance and operational reports and data requests. The Product Analyst assists with the preparation of state rate filings and responds to state insurance department inquiries. This position will participate in research projects and analyze pricing initiatives. The Product Analyst will model data and use insights to recommend new business strategies and reporting.

PRINCIPAL DUTIES & RESPONSIBILITIES
• Develop reports (and product dashboards) necessary to monitor the FAIR Plan’s profitability, efficiency, growth of new products/enhancements.
• Collaborate with actuarial staff to prepare state rate filings and respond to state insurance department inquiries.
• Support research, analysis, and testing of product changes, roll outs, and channel enhancements, including maintenance of Rate and Rule manuals.
• Query databases to conduct ad-hoc analysis on specified or varied metrics.
• Analyze metrics regarding Underwriting practices and recommend efficiencies in work processes and vendor/internal tools.
• Identify trends and recommend product enhancements. Use data to identify efficient investigation of risk practices.
• Prepare presentations in support of rate changes and other strategic decisions.
• Use knowledge of state regulatory guidelines and constraints to assure product compliance.
• Lead project efforts, collaborating with other departments, to explore business problems, resulting in improvements to underwriting processes and performance results.
• Generate insights that equip decision makers with knowledge to optimize business performance.
• Perform additional duties and/or special projects as required.

EDUCATION & EXPERIENCE
• Bachelor’s degree or equivalent required. Major in Math, Economics, or Finance preferred.
• Actuarial coursework / exam a plus.
• Strong analytical skills and financial acumen.
• Ability to manipulate and analyze data, using reason and logic to draw conclusions.
• Experience creating, modifying and running SQL scripts is required.
• Intermediate to Advanced Access and Excel (V-lookups, Pivot tables, etc.), skills. Knowledge of PowerBI is a plus.
• Proficiency in Microsoft Office Suite.
• Excellent organization and time management skills.
• Experience in pricing techniques and making rate filings.
• Excellent verbal and written communication.