Personal Lines - Product Analyst I

About the role

The Personal Lines department is seeking a product analyst to implement and monitor state rate changes, rules, and forms to support profitable growth. You will develop and maintain reports to help in the planning of rate strategies.

Responsibilities

• Refresh existing reports and perform quality checks on results
• Provide small enhancements on existing reports as directed
• Build simple reports based on existing data sources (e.g., Pivot tables, bar charts, and line graphs)
• Run simple queries on existing datasets using SAS/SQL
• Make minor modifications on more advanced tools (Python, Power BI, R)
• Answer basic questions from the business using existing data sources and reports
• Utilize RMC and Rating Config to calculate impacts of simple rate changes
• With assistance, complete more advanced rate changes
• Become proficient in either the home or auto rating plans
• Answer rate change questions from Sales, Underwriting, or Operations
• Create and review rate pages and other filing materials
• Review bulk test runs for CCC states, answer basic/intermediate questions

Requirements

• Demonstrated ability to extract, manipulate, and analyze data
• Excellent communication skills, both written and verbal
• Advanced skills in Microsoft® Excel
• Proven time management skills and the ability to multi-task and prioritize projects
• Ability to work independently

Qualifications

• Bachelor’s degree in business or an analytical field of study (math, economics, finance, statistics, actuarial science) or relevant work experience
• For experienced job roles: technical proficiency in data manipulation tools such as SAS, SQL, R, or equivalent
• Experience in rate-making methodologies

Benefits

Eligible associates may receive an annual cash bonus and stock incentives based on company and individual performance. Cincinnati provides tools and training for success, promoting a lifelong learning approach. Many departments offer hybrid work options, empowering associates to work from home several days a week.

Pay

The pay range for this position is $50,000–$110,000 annually. Pay determination is based on the applicant’s education, experience, location, knowledge, skills, and abilities.