Property Product Analyst (Remote)

California FAIR Plan Association•Los Angeles, CA

9d•$85,000 - $90,000•Remote

About The Position

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.

Requirements

Bachelor’s degree or equivalent required. Major in Math, Economics, or Finance preferred.
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.

Nice To Haves

Actuarial coursework / exam a plus.
Knowledge of PowerBI is a plus.

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.