Strategic Insurance Data and Compensation Analyst

Frankenmuth Insurance Company; United States; On-site; USD 60,000 - 80,000; Full time

Job summary

Frankenmuth Insurance Company is seeking a Business Analyst to lead and oversee agency compensation programs. The role requires strong Excel skills and the ability to model and analyze complex data for strategic decision-making.

Ideal candidates will have a Bachelor’s degree or equivalent experience in insurance and possess an analytical mindset. The position involves collaboration with various departments to enhance agency performance and reporting.

Qualifications

• Bachelor’s degree or 4+ years of experience in property and casualty insurance.
• Strong analytical and strategic mindset.
• Ability to work independently and with significant judgment.

Responsibilities

• Oversee agency compensation programs.
• Gather and analyze compensation data.
• Collaborate with executives on strategic objectives.
• Present analyses to executive leaders.
• Maintain accurate agency compensation agreements.

Skills

Strong Excel skills

Experience in reconciling large data sets

Experience in building reports (SAP Business Object, Power BI, Tableau)

Process orientation

Collaboration skills

Education

Bachelor's degree in finance, accounting, or related field

4+ years in property and casualty insurance

Tools

Excel

SAP Business Object

Power BI

Tableau

Job description

Frankenmuth Insurance Company is seeking a Business Analyst to lead and oversee agency compensation programs. The role requires strong Excel skills and the ability to model and analyze complex data for strategic decision-making.

Ideal candidates will have a Bachelor’s degree or equivalent experience in insurance and possess an analytical mindset. The position involves collaboration with various departments to enhance agency performance and reporting.