Business Analyst (Agency Compensation)

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

Posted Wednesday, June 24, 2026 at 4:00 AM

Summary

Do you nerd out when analyzing complex data? Is Excel your work bestie? When presented with a problem, do you roll up your sleeves and dive into the data? If you are a self-starterwho is comfortable working withlimited supervision and significant independent judgment, then this role may be for you!

The Business Analyst position will foster cross-departmental collaboration to design, implement, and administer competitive agency compensation programs for Frankenmuth Insurance and its subsidiary companies. This role requires leveraging data, technology, and resources to provide tools designed to optimize agency compensation oversight and departmental reporting. Additionally, attention to detail, organization, and effective communication skills are essential for performing key job functions.

Essential Job Functions

• Oversee and lead agency compensation programs by:
• Gathering data to analyze the competitive position of agency incentive compensation programs.
• Collaborating with executive leaders and business development to set strategic objectives.
• Extracting and cleansing data, and modeling compensation programs that align to strategic objectives.
• Presenting analyses and recommendations to executive leaders.
• Implementing and administering approved agency compensation program changes in collaboration with other Business Analyst(s) and departments.
• Maintaining reconciliations, approvals, and other documentation, in accordance with company policy.
• Overseeing and maintaining accurate agency compensation agreements, policies, procedures, and related marketing materials.
• Serve as an agency compensation subject matter expert to internal staff, agency partners, and auditors.
• In collaboration with leadership and other business analyst(s) develop and maintain Marketing department and agency compensation reports.
• Serve as a business lead and/or resource on complex corporate projects representing departmental function.
• May provide leadership to junior staff through guidance and training.
• Performs other duties as assigned.

Qualifications

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below represent the knowledge, skills, and/or abilities required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Education Requirements

Bachelor’s degree and/or four or more years of experience in property and casualty insurance, preferably in finance, accounting, agency administration, and/or agency compensation.

Special Skill Requirements

• Strong Excel skills and experience reconciling large data sets and modeling data with a combination of formulas such as lookups, sumifs, index match, and other functions.
• Experience building reports in a reporting tool such as SAP Business Object, Power BI, or Tableau.
• Experience in collaborating with all levels of an organization.
• Process orientation and continuous improvement mindset.

Nice-to-haves

• Curious, analytical, and strategic mindset.
• Aptitude for challenging the status quo and effectuating change.
• Experience building reports in Power BI.
• Insurance designations, such as AINS, AAI, or AIDA.

A minimum requirement for this position is the ability to work legally in the United States. No visa sponsorship/support is available for this position, including for any type of U.S. permanent residency (green card) process.