Business Analyst (Agency Compensation)

Frankenmuth Insurance Company

11d

About The Position

The Business Analyst will foster cross-departmental collaboration to design, implement, and administer competitive agency compensation programs for Frankenmuth Insurance and its subsidiary companies. The role uses data, technology, and other resources to provide tools that support agency compensation oversight and departmental reporting. The position requires attention to detail, organization, effective communication, independent judgment, and the ability to work with limited supervision. The analyst oversees agency compensation programs, including gathering and analyzing data, collaborating with executive leaders and business development to establish strategic objectives, modeling compensation programs, presenting recommendations, and implementing approved changes. The role also maintains program documentation and agreements, serves as a subject matter expert to staff, agency partners, and auditors, develops and maintains reports, and contributes business expertise to complex corporate projects. The position may provide guidance and training to junior staff and includes other duties as assigned.

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.
Strong Excel skills and experience reconciling large data sets and modeling data using formulas such as lookups, SUMIFS, INDEX MATCH, and other functions.
Experience building reports in a reporting tool such as SAP BusinessObjects, Power BI, or Tableau.
Experience collaborating with all levels of an organization.
Process orientation and a continuous improvement mindset.
Ability to work legally in the United States; visa sponsorship or support is unavailable, including for permanent residency processes.

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.
Compensation designation.

Responsibilities

Gather data to analyze the competitive position of agency incentive compensation programs.
Collaborate with executive leaders and business development to set strategic objectives.
Extract and cleanse data, and model compensation programs aligned with strategic objectives.
Present analyses and recommendations to executive leaders.
Implement and administer approved agency compensation program changes in collaboration with other Business Analysts and departments.
Maintain reconciliations, approvals, and other documentation in accordance with company policy.
Oversee and maintain 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.
Develop and maintain Marketing department and agency compensation reports in collaboration with leadership and other Business Analysts.
Serve as a business lead and/or resource on complex corporate projects representing the departmental function.
May provide leadership to junior staff through guidance and training.
Perform other duties as assigned.