Senior Product Analyst-Insurance

PEMCO; Lorida (FL); Presencial; USD 75.000 - 120.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

401(k) match

Paid holidays

Floating holidays

Paid sick leave

Bereavement leave

Employee volunteering time off

Scholarship program

Descripción de la vacante

PEMCO in Seattle, WA seeks a Product Analyst to partner with Product Managers and Actuaries to deliver data-driven insights that support profitability and growth. You will perform semi-complex analyses, document workflows, and manage small to mid-scale projects while translating data into actionable recommendations.

Strong Excel, SQL, and data visualization skills (PowerBI/Tableau) are required, with excellent communication and a collaborative mindset to engage with stakeholders across the

Formación

• Degree or equivalent work experience in business, economics, mathematics, or other quantitative fields.
• Strong Excel/Office proficiency required.
• Experience with SQL and data analysis to support product initiatives.
• Ability to translate data into actionable insights for product teams.
• Excellent written and verbal communication across technical and non-technical audiences.
• Experience with data visualization tools preferred (PowerBI/Tableau).
• Knowledge of relevant laws, rules, and regulations (compliance).

Responsabilidades

• Analyze product performance and identify trends and issues to drive improvements.
• Document workflows and business processes for product initiatives.
• Collaborate with Product Managers and Actuaries on data-driven recommendations.
• Prepare materials for rate and form filings and support project delivery.
• Develop scalable data models and integrate data with external vendors as needed.

Conocimientos

MS Office

SQL

Analytical thinking

Communicator

Data-driven

Compliance knowledge

Educación

S. degree or equivalent work experience (Business, Economics, mathematics, or other quantitative fields of study)

Herramientas

Microsoft Excel

SQL Server

PowerBI

Tableau

Descripción del empleo

Applicants must be a resident and work from one of the following states: WA, OR, OH, IL, MN, NC, SC, FL, AZ, TX or ID, with occasional travel to our headquarters, located in Seattle, WA.

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. Recognized by Forbes as one of America’s Best Insurance Companies in both Auto and Home for 2026, based on customer survey feedback, and by Newsweek as one of America’s Greatest Midsize Workplaces 2025. We are consistently recognized for our outstanding customer service, employee expertise, community partnerships, and social impact programs. 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.

The Product Analyst position is responsible for working closely with our Product Managers and Actuaries to provide analyses and to contribute to the development of recommendations that will support PEMCO's and Product's initiatives.

• Perform semi-complex analysis to evaluate the performance of and identify trends and issues for our products and make actionable recommendations for improvements.
• Document system workflows and business processes.
• Contribute to the achievement of short and long-term strategies to achieve profitable growth leveraging quantitative and qualitative data.
• Compile and submit materials for rate and form filings.
• Plan and manage small to medium scale projects.
• Query databases to generate scheduled and ad hoc reports and analysis to support department goals.
• Demonstrate behaviors consistent with PEMCO's policies, values, code of ethics and business conduct.
• Authentically support the PEMCO Brand and constantly are on the lookout for top talent to join us to achieve our Mission to Worry Less and Live More.

S. degree or equivalent work experience (Business, Economics, mathematics, or other quantitative fields of study)

• ~MS Office: Skilled proficiency in Excel, Word, PowerPoint, Outlook is required
• ~ Experience in SQL and SQL Server is required
• ~ Highly Analytical: Is passionate about working with disparate datasets bringing data together to answer business questions. Collaborates to create, manage, and translate data to meaningful insights. Can work with external vendors to integrate data for analysis; knows how to build efficient and scalable infrastructure and data models is required
• ~ Communicator: The ability to communicate clearly and informatively, verbally and in writing, with colleagues, customers, and the community in both technical and non-technical professional language is required
• ~ Analytical and data-driven: a structured thinker who can put complex ideas into clear frameworks; uses data to conduct root cause analysis and develops high quality, consumable, and consistent metrics that drive strategic objectives and priorities is required
• ~ Experience in data visualization, PowerBI, and Tableau is preferred
• ~ Compliance: Knowledge and understanding of relevant laws, rules, and regulations

• Greater Seattle area target pay range: $Outside Greater Seattle area target pay range: $Regular part-time PEMCO employees working at least 24 hours per week and regular full-time PEMCO employees are eligible to elect coverage under medical, dental, and vision plans for themselves and their eligible family members with generous employer premium cost shares. covered by employer-paid basic life and accidental death & dismemberment insurance policies as well as long- and short-term disability benefit coverages.
• eligible to participate in PEMCO’s 401(k) plan, which includes a generous employer match (2 for 1 on the first 6% employee pre-tax and/or Roth deferral, up to federal maximums).
• Vacation and eight (8) paid holidays.
• Granted four (4) floating holidays and up to ten (10) days of sick leave immediately upon hire (pro-rated based on hire date and full-time/part-time status).
• In addition, PEMCO provides paid time off for bereavement, jury duty, and employee volunteering in the community.
• Scholarship program for children of PEMCO employees after one year of service; children’s birthday gift program
• Flexible Spending Accounts, Employee Assistance Program, and charitable gift matching
• Other compensation depending on role, contributions, and performance may include:
• Discretionary bonuses.

We know employing a team rich in diverse thoughts, experiences, and opinions allows our employees, our products, and our community to flourish. 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.

At PEMCO, people are at the heart of our business. Requests are considered on a case by case basis in accordance with applicable disability laws, including the ADAAA.

Applicants have rights under Federal Employment Laws:

Family and Medical Leave Act (FMLA)