Analyzes data and models competitive agency compensation programs for an insurance organization. Responsibilities include data extraction and cleansing, compensation reporting, reconciliations, executive presentations, program administration, documentation, audit support, and cross-departmental collaboration. The role also serves as a compensation subject matter expert, supports corporate projects, and may guide junior staff.
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
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.
Similar Jobs
Information Technology
Provides advanced networking expertise to support sales teams, engage customers, recommend technical solutions, qualify opportunities, and drive networking solution growth. Presents networking concepts, advises on competitive solutions, identifies related technology opportunities, supports sales enablement, collaborates with solution teams and partners, and maintains relevant certifications and technical knowledge.
Top Skills:
Cloud ConnectivityData CenterLoad BalancingNetworkingSd-WanSecurityWireless
Information Technology
Designs, implements, configures, tests, supports, and troubleshoots physical security systems including video surveillance, access control, sensors, and integrations. Consults with clients, leads design workshops, develops network architectures, executes test plans, supports sales, manages project expectations, and serves as a technical customer contact. Requires hands-on security systems engineering, network infrastructure experience, client communication, travel, and occasional off-hours work.
Top Skills:
Access Control SystemsAxisEnvironmental SensorsGenetecIot DevicesLanMeraki MvMilestoneNetwork SecurityVerkadaVideo Surveillance SystemsWan
Information Technology
Designs, implements, configures, tests, supports, and troubleshoots enterprise physical security systems, including video surveillance, access control, sensors, and integrations. Consults with clients, develops network and system architectures, leads design workshops, creates test plans and documentation, supports sales activities, and serves as a technical customer contact. Requires hands-on security systems engineering, network infrastructure experience, client communication skills, and travel of 25%–50%.
Top Skills:
Access Control SystemsAxisEnvironmental SensorsGenetecIot DevicesLanMeraki MvMilestoneNetwork SecurityVerkadaVideo Surveillance SystemsWan
What you need to know about the Austin Tech Scene
Austin has a diverse and thriving tech ecosystem thanks to home-grown companies like Dell and major campuses for IBM, AMD and Apple. The state’s flagship university, the University of Texas at Austin, is known for its engineering school, and the city is known for its annual South by Southwest tech and media conference. Austin’s tech scene spans many verticals, but it’s particularly known for hardware, including semiconductors, as well as AI, biotechnology and cloud computing. And its food and music scene, low taxes and favorable climate has made the city a destination for tech workers from across the country.
Key Facts About Austin Tech
- Number of Tech Workers: 180,500; 13.7% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Dell, IBM, AMD, Apple, Alphabet
- Key Industries: Artificial intelligence, hardware, cloud computing, software, healthtech
- Funding Landscape: $4.5 billion in VC funding in 2024 (Pitchbook)
- Notable Investors: Live Oak Ventures, Austin Ventures, Hinge Capital, Gigafund, KdT Ventures, Next Coast Ventures, Silverton Partners
- Research Centers and Universities: University of Texas, Southwestern University, Texas State University, Center for Complex Quantum Systems, Oden Institute for Computational Engineering and Sciences, Texas Advanced Computing Center
