Pie’s Pricing & Product Analyst position is responsible for competitive analysis, and researching market pricing and pricing levels to ensure profitability  for commercial lines. This role will monitor metrics, pricing and models for a new commercial auto product line for Pie Insurance. The Pricing & Product  Analyst is also responsible for assisting in the building and development of product lines while gauging the performance  through monitoring the market to ensure the competitiveness over the market pricing over time. Pie is an incredibly collaborative team with constant communication. You will work across teams and collaborate with stakeholders and team members. Great communication and coordination skills are key to your success.   

How You’ll Do It

Data Analytics, Data Manipulation

• 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 - such as competitor filings, subscriber services, and service offering tools - for gathering and developing information.
• Support ongoing process of filing new programs within individual states.
• Assist in the building, monitoring, and distributing BI tools for Underwriting and Pricing leads that aid in goal tracking and execution.
• Monitor portfolio performance as it relates to growth, retention, and profitability. Provide information to the team enabling them to make well informed pricing segmentation changes. 

Team Data Resource

• Highlighting areas of concern and bringing forward to senior management for review.
• Effectively communicate information from large data sets and be able to explain the why behind the information.
• Supports all functions of the commercial auto team with data analysis.
• Networks and collaborates on ideas and challenges with business units such as Business Development, Product, and Data Engineering.

The Right Stuff

• 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.