Analyst, Pricing & Product - Commercial Auto
Pie Insurance
·
Posted:
July 31, 2023
·
Hybrid
About the position
The job overview for the Pie's Pricing & Product Analyst position is to conduct competitive analysis and research market pricing to ensure profitability for commercial lines. The analyst will monitor metrics, pricing, and models for a new commercial auto product line and assist in the building and development of product lines. Collaboration and communication skills are essential as the analyst will work across teams and collaborate with stakeholders. The role also involves data analysis, highlighting areas of concern, and supporting the commercial auto team with data analysis. A bachelor's degree and analytical work experience are required, along with knowledge of statistics and mathematics. Proficiency in data query tools and advanced Excel skills are necessary, and experience in P&C insurance is preferred.
Responsibilities
- Compare internal pricing against competitor pricing to determine market competitiveness.
- Analyze funnel metrics to identify underserved markets and industries for growth opportunities.
- Use online resources for gathering and developing information on competitor filings, subscriber services, and service offering tools.
- Support ongoing process of filing new programs within individual states.
- Assist in the building, monitoring, and distributing BI tools for Underwriting and Pricing leads.
- Monitor portfolio performance as it relates to growth, retention, and profitability.
- Highlight areas of concern and bring them forward to senior management for review.
- Effectively communicate information from large data sets and explain the why behind the information.
- Support all functions of the commercial auto team with data analysis.
- Network and collaborate on ideas and challenges with business units such as Business Development, Product, and Data Engineering.
- Have a background in statistics and mathematics, statistics or economics is highly desirable.
- Have demonstrated work experience in P&C insurance, specifically personal or commercial auto lines.
- Have basic knowledge of using SAS, SQL, snowflake or other data query tools.
- Have advanced Excel skills (formulas, importing large data sets, pivots, macros and automation).
- Have a sense of creativity and strategic thinking about how analytics relate to business outcomes.
- Have problem-solving skills to work independently through simple to moderately complex problems within data sets.
- Be comfortable with ambiguity and be a self-starter.
- Like variety and not repetition, but can build repetition in process for scalability purposes.
- Have basic data mining and analysis skills to provide relevant data points and analytics.
- Have developed written and verbal communication skills.
- Have the ability to effectively present technical concepts to non-technical individuals within the organization.
Requirements
- Bachelor's Degree is required. Master's Degree may be considered in lieu of required work experience.
- 2 years of analytical work experience with a Bachelor's Degree in quantitative field of study. OR 3-4 years of analytical work experience with a Bachelor's Degree in an unrelated field of study.
- Background in statistics and mathematics, statistics or economics is highly desirable.
- Demonstrated work experience in P&C insurance- specifically personal or commercial auto lines is highly preferred.
- Basic knowledge of using SAS, SQL, snowflake or other data query tools.
- Advanced Excel skills are required (formulas, importing large data sets, pivots, macros and automation).
- Sense of creativity and strategic thinking about how analytics relate to business outcomes now and into the future.
- Growing understanding of the iterative workflow process to work collaboratively on global tasks.
- Problem solving skills to work independently through simple to moderately complex problems like numerical issues within data sets.
- Comfortable with ambiguity and self starter.
- Likes variety and not repetition, but can build repetition in process for scalability purposes.
- Basic data mining and analysis skills to provide relevant data points and analytics.
- Developed written and verbal communication skills. Ability to effectively present technical concepts to non-technical individuals within the organization.
Benefits
- Competitive cash compensation
- Equity in the company
- Comprehensive health plans
- Generous PTO (Paid Time Off)
- Future focused 401k match
- Generous parental and caregiver leave
- Discretionary bonuses based on company performance
- Hybrid or remote work options
- Equal opportunity employer
- Participation in the E-Verify program
- Commitment to protecting personal data