Stagiaire Product Analyst H/F

PEMCO; Orangeburg (SC); Hybride; USD 120 000 - 180 000; Plein temps

Avantages offerts par ce poste

401(k) match

Paid time off

Health benefits

Flexible spending accounts

Résumé du poste

PEMCO is seeking a Principal Product Analyst to perform advanced quantitative analyses of property & casualty products and guide product strategy with actionable insights. You will lead cross-functional data projects, mentor analysts, and shape data warehousing practices to drive healthier product performance.

The role requires 10+ years in analytics, expert SQL, data visualization, and strong communication to executives. Occasional travel to the Seattle HQ is expected.

Qualifications

• 10+ years in corporate analytical roles with pricing insurance products or similar.
• Experience integrating and manipulating large data from multiple sources.
• Proficient in SQL, data visualization tools, and MS Office.

Responsabilités

• Lead complex quantitative analysis to improve product performance.
• Represent Product in cross-functional projects and data strategy discussions.
• Present data visualizations to stakeholders and executives.
• Mentor junior analysts and develop best practices in data warehousing.
• Develop and document complex workflows and data processes.

Connaissances

SQL

SQL Server

Data visualization

Power BI

Tableau

Excel

Communication

Analytical thinking

Formation

Bachelor’s degree or equivalent in business/ economics/ mathematics

Graduate degree preferred

Outils

WTW Radar

Description du poste

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 Principal Product Analyst position is responsible for conducting complex quantitative analysis of property & casualty products to improve product performance and support PEMCO's and Product's initiatives. As a principal level role, this position helps to shape Product strategy through data analysis and guide product development with relevant analytical insights.
Serve as a thought leader for new, complex, and ambiguous business questions; represent Product in cross-functional projects.
Represent the Product department in development of company data strategy; serve as catalyst of change for Product data warehousing and processes.
Proactively lead complex analysis to evaluate the performance of our products; maintain a constant pulse on health of the business and Product department by tracking key performance indicators against targets and investigating key trends and their underlying drivers.
Present analysis and data visualizations to stakeholders and executives clearly and persuasively.
Plan and manage large-scale, complex projects independently.
Pioneer best practices in PEMCO product builds, tools, and processes to improve analysis and efficiencies.
Lead the development and implementation of analytical strategies with our Product Manager(s) and Actuarial team.
Develop and document complex system workflows and business processes.
identify enhancements and efficiency gains in data strategy and warehousing; consult on data fields, calculations, and methodology.
Mentor less experienced analysts, helping them improve and sharpen their skills by sharing best practices.
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) is required
• ~ Graduate or other professional degree or equivalent work experience is preferred
• ~10+ years of experience in corporate analytical roles with increasing scale, scope and complexity involving pricing insurance products (or similar work) including experience in integrating, managing and manipulating large data files from various corporate systems and external sources is required
• ~ Organized: Has excellent time management skills and easily manages multiple tasks, activities, and projects is required
• ~ MS Office: Skilled proficiency in Excel, Word, PowerPoint, Outlook is required
• ~ Skilled proficiency in SQL, SQL Server, and data visualization 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
• ~ Organizes data visually and speaks clearly and persuasively in group presentations and meetings with multiple peer groups and senior management is required
• ~ Ability to demonstrate high level of skill in quantitative modeling, knowledge of data structures and ability to write complex SQL queries 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
• ~ 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
• ~ Proficiency in Power BI, Tableau, and WTW Radar is preferred

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

Requests are considered on a case by case basis in accordance with applicable disability laws, including the ADAAA.

Family and Medical Leave Act (FMLA)