Product Analyst

Job Description

Who We Are:

At PEMCO we're all about people - our customers, our employees, and the community. We're a mutual insurance company owned by our Northwest policyholders. We provide auto, home, renters, and boat coverage. Recently, Forbes named PEMCO as one of America's Best Insurance Companies 2022 and ranked PEMCO as the #1 auto insurer in the nation based on customer survey feedback. We are consistently recognized for our outstanding customer service, employee expertise, diverse community partnership and engagement, and social impact as well.

Our social impact programs motivate high achievement by youth in education; build stronger and greener communities; and increase safety at home, on the road, and at play. We're committed to diversity, equity, inclusion, and belonging, and to fostering an inspiring and inclusive workplace. These efforts create and cultivate an environment that builds fairness and understanding, encourages collaboration and flexibility, and celebrates all the ways in which we're different and the same - enabling all individuals to achieve their full potential.

Why We Need You:

Come join our dynamic Product team as we execute product initiatives using technology to make a difference! In this role, you'll have the opportunity to collaborate with other teams across the business to help the company achieve success in our various product lines. Work closely with our Product Managers and Actuaries to provide support on analyses and to develop recommendations that will support the Company's and Product Department's initiatives. You'll bring with you experience analyzing data to solve complex business problems and making actionable recommendations for improvements.

What You'll Be Doing

• Contribute to the achievement of short and long-term strategies to achieve profitable growth leveraging quantitative and qualitative data
• Perform semi-complex analysis to evaluate the performance of and identify trends and issues for our products and make actionable recommendations for improvements
• Assist in product and rating reviews, including making pricing recommendations
• Compile and submit materials for rate and form filings
• Query databases to generate scheduled and ad hoc reports and analyses to support department goals
• Plan and manage small to medium-scale, complex projects
• Build tools to create efficiencies, especially in analyzing metrics
• Document system workflows and business processes
• Manage expectations; prioritize own workload and communicate status

What You'll Bring

• Two or more (2+) years of data analysis and modeling experience required
• Requires Bachelor's degree; preference to Business, Economics, Mathematics, or other quantitative fields of study
• Proficient in Microsoft Office Suite (Outlook, Word, Excel, and PowerPoint)
• Advanced proficiency with Microsoft Excel (create pivot tables, use lookup formulas, etc.)
• Intermediate proficiency with database software (SQL Server, Teradata, SAS, etc.) required
• Business intelligence software experience is a plus (Tableau, Power BI, Microstrategy, etc.)
• Property and casualty insurance industry experience desired and knowledge of insurance contracts, forms, product pricing, and how state regulations impact the business are a plus!

What We Value:

PEMCO has identified the below competencies as critical for employees and the future of our business. The competencies are intended to define skills or abilities expected of our employees, and behaviors that employees can develop, and be evaluated against in their job. Proficiency levels include Beginner, Skilled, Advanced, and Mastery. Not every employee is expected to master every competency. Instead, we expect that employees will build skills in these areas as they progress through their roles and career at PEMCO.

• Agility: Handles risk and uncertainty, shifts gears with ease and speed, copes with and manages change well
• Growth Mindset: Develops abilities through dedication and hard work, views challenges and failures as opportunities to learn and improve skills
• Service Passion: Provides excellent service to others and seeks ways to improve that service; ensures the customer experience (internal and external) is a key consideration in policies, procedures, and decision-making
• Complex Problem Solving: Solves ill-defined, ambiguous problems in complex settings using logic, process, and experience

We've Got You Covered

• Competitive salary
• 200% match on your 401(k) up to 6% of your pay
• Generous medical, dental, disability, and life insurance plans
• A commitment to community through social impact and diversity, equity, inclusion, and belonging programs
• A work environment built on integrity, where customer service is top priority and being friendly, inspiring, and good-humored is how we get things done

Work Location:

This position has a flexible work location It can be hybrid out of the Greater Seattle and Spokane areas, or remote from Washington, Oregon, Idaho, Ohio, or South Carolina.

COVID-19

At PEMCO, the safety and health of our community are a top priority. Effective February 1, 2022, all PEMCO employees who come into contact with others for work purposes will be required to submit proof of full vaccination against COVID-19. Requests for medical or religious accommodations should be addressed directly to Human Resources at [email protected], and reasonable accommodations will be provided.

Equal Employment Opportunity

At PEMCO, we celebrate and support our differences. We know employing a team rich in diverse thoughts, experiences, and opinions allows our employees, our products and our community to flourish. PEMCO is honored to be an equal opportunity workplace. We are dedicated to equal employment opportunities regardless of race, color, ancestry, religion, sex, national orientation, age, citizenship, marital status, disability, gender identity, sexual orientation, or veteran status.