Senior Insurance Product Analyst — Data-Driven Insights

PEMCO; Austin (TX); On-site; USD 90,000 - 120,000; Full time

Benefits offered by this job

Medical-dental-vision plans

401(k) with company match

Paid holidays and vacation

Paid time off for sick leave

Bereavement leave

Job summary

PEMCO in Seattle, WA, is seeking a Product Analyst to work with Product Managers and Actuaries to analyze data and develop actionable recommendations that support PEMCO's initiatives.

You will perform semi-complex analyses, document workflows, and support rate and form filings. You’ll also plan and manage small to medium projects, and translate data into clear insights for business decisions. Strong communication and SQL/Excel skills are essential.

Qualifications

• 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

Responsibilities

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

Skills

Excel

SQL

Data analysis

Communication

Data visualization

Power BI

Tableau

Education

B.S. degree or equivalent (Business, Economics, mathematics, or related quantitative field)

Tools

SQL Server

Power BI

Tableau

Job description

PEMCO in Seattle, WA, is seeking a Product Analyst to work with Product Managers and Actuaries to analyze data and develop actionable recommendations that support PEMCO's initiatives.

You will perform semi-complex analyses, document workflows, and support rate and form filings. You’ll also plan and manage small to medium projects, and translate data into clear insights for business decisions. Strong communication and SQL/Excel skills are essential.