Senior Product Analyst – Insurance Data & Strategy

PEMCO; Orangeburg (SC); On-site; USD 100,000 - 140,000; Full time

Benefits offered by this job

401(k) match

Paid vacation

Eight holidays

Job summary

PEMCO is seeking a Senior Product Analyst to conduct advanced quantitative analysis of property & casualty products, partnering with Product Managers and Actuarial teams. You will lead large-scale projects, document workflows, and drive data-driven improvements in pricing and performance.

The role requires 6+ years in analytics, strong SQL/Power BI/Tableau skills, and the ability to translate insights for senior stakeholders while complying with regulations.

Qualifications

• S. degree or equivalent work experience (economics, business, information technology, mathematics, or equivalent quantitative field of study) is required
• Graduate or other professional degree or equivalent work experience is preferred
• 6+ years of experience in 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
• Organizes data visually and speaks clearly and persuasively in group presentations and meetings with multiple peer groups and senior management is required
• Precision: Is detail orientated and has a strong desire for accuracy and thoroughness is required
• MS Office: Skilled proficiency in Excel, Word, PowerPoint, Outlook is required
• Proficiency in SQL, SQL Server, and data visualization 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
• Knowledge and understanding of relevant laws, rules, and regulations 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
• Proficiency in Power BI, Tableau, and WTW Radar is preferred

Responsibilities

• Plan and manage large-scale, complex projects with support.
• Document complex system workflows and business processes.
• Develop and implement analytical strategies as a partner to our Product Managers and Actuarial team.
• Identify enhancements and efficiency gains in data strategy and warehousing; consult on data fields, calculations, and methodology.
• Compile and submit materials for rate filings.
• Communicate analysis with business stakeholders to understand its value.
• Perform complex analysis to evaluate the performance of and identify trends and issues for our products and make actionable recommendations for improvements.

Skills

SQL

Power BI

Tableau

Data visualization

Excel

Communication

Data modeling

Education

Bachelor's degree

Graduate degree preferred

Tools

SQL Server

Power BI

Tableau

WTW Radar

Job description

PEMCO is seeking a Senior Product Analyst to conduct advanced quantitative analysis of property & casualty products, partnering with Product Managers and Actuarial teams. You will lead large-scale projects, document workflows, and drive data-driven improvements in pricing and performance.

The role requires 6+ years in analytics, strong SQL/Power BI/Tableau skills, and the ability to translate insights for senior stakeholders while complying with regulations.