Product Analytics Intern — Shape Strategy with Data

PEMCO; Minnesota; On-site; USD 120,000 - 180,000; Full time

Benefits offered by this job

401(k) plan with match

Paid holidays

Paid time off

Floating holidays

Bereavement leave

Volunteer time off

Employee assistance program

Job summary

PEMCO in Seattle seeks a Principal Product Analyst to drive complex quantitative analysis of property & casualty products, guiding product strategy with actionable insights. You will lead cross-functional projects, mentor analysts, and shape data strategy and warehousing efforts.

The role requires 10+ years in corporate analytics for pricing insurance products, strong SQL and data visualization skills, and exceptional communication ability to translate data into strategic recommendations.

Qualifications

• 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

Responsibilities

• Lead complex analysis to evaluate product performance and inform PEMCO initiatives
• Represent Product in cross-functional projects and in data strategy development
• Proactively manage large-scale, complex projects independently
• Develop and implement analytical strategies with Product Managers and Actuarial team
• Document complex system workflows and business processes
• Identify enhancements in data strategy and warehousing; consult on data fields and methodology
• Mentor less experienced analysts by sharing best practices
• Present analysis and visualizations to stakeholders and executives clearly and persuasively
• Demonstrate PEMCO values and support brand and mission to Worry Less and Live More

Skills

SQL

Data visualization

Power BI

Tableau

Communication

Quantitative modeling

Data analysis

Problem solving

Education

Bachelor's degree

Graduate degree preferred

Tools

SQL Server

Power BI

Tableau

Job description

PEMCO in Seattle seeks a Principal Product Analyst to drive complex quantitative analysis of property & casualty products, guiding product strategy with actionable insights. You will lead cross-functional projects, mentor analysts, and shape data strategy and warehousing efforts.

The role requires 10+ years in corporate analytics for pricing insurance products, strong SQL and data visualization skills, and exceptional communication ability to translate data into strategic recommendations.