Business Analyst (Agency Compensation)

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-starter who is comfortable working with limited 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. Compensation designation. #LI-DNI