Strategic Compensation Analyst — Data & BI Expert

Frankenmuth Insurance Company; Northern (KY); Hybrid; USD 70,000 - 100,000; Full time

Job summary

Frankenmuth Insurance Company is seeking a Business Analyst to design, implement, and administer agency compensation programs. You will analyze large datasets, reconcile figures, and develop reporting in Power BI, Tableau, or SAP BO, collaborating with executives and cross-functional teams.

This role emphasizes data-driven decision making, process improvement, and clear communication. A Bachelor's degree and insurance industry familiarity are preferred.

Qualifications

• Strong Excel skills and ability to reconcile large data sets.
• Experience building reports in SAP BO, Power BI or Tableau.
• Experience collaborating with all levels of an organization.
• Process orientation with a continuous improvement mindset.

Responsibilities

• Oversee and lead agency compensation programs by gathering data to analyze competitive positions.
• Collaborate with executives to set strategic objectives and model compensation.
• Extract and cleanse data, and implement program changes with other teams.
• Develop and maintain agency compensation reports and dashboards.
• Provide SME guidance to staff, partners, and auditors.

Skills

Excel

Data reconciliation

Data modeling

Cross-functional collaboration

Process improvement

Education

Bachelor's degree or higher

Tools

SAP Business Object

Power BI

Tableau

Job description

Frankenmuth Insurance Company is seeking a Business Analyst to design, implement, and administer agency compensation programs. You will analyze large datasets, reconcile figures, and develop reporting in Power BI, Tableau, or SAP BO, collaborating with executives and cross-functional teams.

This role emphasizes data-driven decision making, process improvement, and clear communication. A Bachelor's degree and insurance industry familiarity are preferred.