Senior Product Analyst
About The Position
The Senior Product Analyst conducts complex quantitative analysis of property and casualty insurance products to improve product performance and support PEMCO’s and Product’s initiatives. The role partners with Product Managers and the Actuarial team to develop and implement analytical strategies, analyze product results, identify trends and issues, and recommend actionable improvements. The position also supports product and rating reviews, pricing recommendations, and rate filings. The analyst plans and manages complex projects, documents system workflows and business processes, and develops queries, dashboards, tools, and processes for analyzing product success and improving efficiency. The role consults on data fields, calculations, methodology, data strategy, and warehousing, and communicates the value of analysis to business stakeholders. It may also include assisting less experienced analysts and performing other assigned duties. Applicants must reside and work in Washington, Oregon, Ohio, Illinois, Minnesota, North Carolina, South Carolina, Florida, Texas, or Idaho. Occasional travel to PEMCO’s Seattle, Washington headquarters is required. The position supports PEMCO’s policies, values, brand, and mission, and contributes to a workplace committed to diversity, equity, inclusion, and belonging.
Requirements
- Bachelor of Arts or Bachelor of Science degree, or equivalent work experience, in economics, business, information technology, mathematics, or an equivalent quantitative field.
- At least 3 years of experience in the property and casualty insurance industry.
- At least 6 years of experience in analytical roles of increasing scale, scope, and complexity involving pricing insurance products or similar work, including integrating, managing, and manipulating large data files from corporate systems and external sources.
- Ability to analyze, diagnose, and collaboratively resolve complex, unstructured problems quickly and efficiently.
- Ability to organize data visually and present clearly and persuasively to peer groups and senior management.
- Strong attention to detail and accuracy.
- Excellent time-management and organizational skills, including managing multiple tasks, activities, and projects.
- Proficiency in Excel, Word, PowerPoint, and Outlook.
- Proficiency in SQL, SQL Server, and data visualization.
- High-level quantitative modeling skills, knowledge of data structures, and ability to write complex SQL queries.
- Self-motivation and ability to work independently with limited direction and communicate relevant information to appropriate levels during uncertainty.
- Ability to work with disparate datasets, combine data to answer business questions, translate data into meaningful insights, work with external vendors on data integration, and build efficient, scalable infrastructure and data models.
- Knowledge and understanding of relevant laws, rules, and regulations.
- Clear and informative verbal and written communication with colleagues, customers, and the community in technical and non-technical professional language.
- Analytical, structured approach to root-cause analysis and development of high-quality, consistent metrics that support strategic objectives and priorities.
Nice To Haves
- Graduate or other professional degree, or equivalent work experience.
- Proficiency in Power BI, Tableau, and WTW Radar.
Responsibilities
- Plan and manage large-scale, complex projects with support.
- Document complex system workflows and business processes.
- Develop and implement analytical strategies in partnership with Product Managers and the Actuarial team.
- Create queries, dashboards, and tools to analyze and track product success.
- Identify enhancements and efficiency gains in data strategy and warehousing; consult on data fields, calculations, and methodology.
- Compile and submit materials for rate filings.
- Communicate analysis and its value to business stakeholders.
- Build tools and processes that improve efficiency, especially in metric analysis.
- Assist less experienced analysts as needed or assigned.
- Assist in product and rating reviews, including making pricing recommendations.
- Analyze product performance, identify trends and issues, and make actionable recommendations for improvement.
- Demonstrate conduct consistent with PEMCO policies, values, ethics, and business conduct.
- Support the PEMCO brand and help identify talent aligned with the company’s mission.
- Perform other duties as assigned.
Benefits
- Medical, dental, and vision coverage for eligible employees and eligible family members, with employer premium cost shares.
- Employer-paid basic life and accidental death and dismemberment insurance.
- Long- and short-term disability coverage.
- 401(k) plan with employer match of 2-for-1 on the first 6% of employee pre-tax and/or Roth deferrals, up to federal maximums.
- Vacation and eight paid holidays.
- Four floating holidays and up to ten days of sick leave upon hire, prorated based on hire date and full-time or part-time status.
- Paid leave for bereavement, jury duty, and employee volunteering in the community.
- Education Assistance Program after one year of service.
- Scholarship program for employees’ children after one year of service and a children’s birthday gift program.
- Flexible Spending Accounts.
- Employee Assistance Program.
- Charitable gift matching.
- Discretionary bonuses may be offered depending on role, contributions, and performance.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
