The Pricing & Product Analyst position is responsible for developing data and analytics that support the profit and loss of Pie’s workers compensation book of business. This role will closely monitor growth, pricing, and profitability metrics to help formulate and implement new strategies.
The Pricing & Product Analyst is also responsible for analyzing competitor behaviors and marketplace dynamics to ensure Pie’s competitiveness over time.

How You’ll Do It

Being able to extract and analyze data is the key to success for the Pricing & Product Analyst position. Understanding basic actuarial concepts such as ratemaking, predictive modeling, and loss development is a plus, as this knowledge will help inform pricing and appetite strategies when paired with competitor information. You will also aid in streamlining both existing and new reports to reduce redundancy and increase accuracy. 

Data Analytics, Data Manipulation

• Use online resources - such as competitor filings, subscriber services, and service offering tools - for gathering and developing information.
• Compare internal pricing against competitor pricing to determine market competitiveness.
• Analyze funnel metrics to identify underserved markets and industries for growth opportunities. 
• Monitor portfolio performance as it relates to growth, retention, and profitability to make well informed pricing segmentation changes. 
• Build, monitor, and distribute BI tools for Underwriting and Pricing leads that aid in goal tracking and execution.
• Write Snowflake/SQL queries to extract and manipulate data sets to achieve certain results.
• Participate in the ongoing development and documentation of all pricing and appetite related processes. 
• Support ongoing process of filing new programs within individual states.

Team 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.
• Directly supports the Underwriting and Pricing teams 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.
• Background in statistics, mathematics, economics, actuarial science or other quantitative major field of study is highly desirable.
• 3+ years of analytical work experience in the P&C commercial insurance industry, specifically workers compensation, is preferred.
• Advanced Excel skills are required (complex formulas, data linking, macro writing, pivot tables, ODBC connections).
• Basic knowledge of using Snowflake, SQL, or other data query tools (sourcing, relationships, derivations).
• Proficient in designing, implementing, and navigating reports in BI analytical tools such as Looker, Tableau, Anaplan, or Qlikview.
• Sense of creativity and strategic thinking about how analytics relate to business outcomes now and into the future.
• Problem solving skills to work through numerical issues with data sets.
• Comfortable with ambiguity and self starter.
• Likes variety and not repetition, but can build repetition in process for scalability purposes.
• Attention to detail and ability to perform reasonability checks.
• Strong written and verbal communication skills.
• Proven ability to effectively present technical concepts to non-technical audiences.

#LI-JF1