This job has closed.

Frankenmuth Insurance · 4 days ago

Business Analyst (Marketing-Agency Compensation)

United States

Full-time

Remote

Mid Level

4+ years exp

Frankenmuth Insurance is seeking a Business Analyst to enhance their agency compensation programs. The role involves analyzing data, collaborating with leaders to set strategic objectives, and implementing compensation program changes while ensuring accurate documentation and reporting.

Auto InsuranceInsurance

Growth Opportunities

No H1B

Responsibilities

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

Qualification

ExcelData modelingReporting toolsInsurance experienceProcess orientationAnalytical mindsetChange managementInsurance designationsCompensation designationCollaboration

Required

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

Ability to work legally in the United States