Our Client is one of the United States’ largest insurers, providing a wide range of insurance and financial services products with gross written premiums well over US$25 Billion (P&C). They proudly serve more than 10 million U.S. households with more than 19 million individual policies across all 50 states through the efforts of over 48,000 exclusive and independent agents and nearly 18,500 employees. Finally, our Client is part of one the largest Insurance Groups in the world.
Team Function:
- The Incentive Analysis and Validation team is responsible for the creation and maintenance of data feeds relevant to calculating agent compensation for over 9000 insurance agents across the United States.
- In addition to working closely with our partners in IT to develop and implement changes to agent incentive programs, the Incentive Analysis and Validation team is responsible for regularly working with business leadership to perform cost modeling related to potential changes to agent compensation programs.
- Responsible for developing business segment, function, and process knowledge, an understanding of business-area data and advanced analytics to successfully implement solutions that improves profitable growth.
- Provides collaborative support for planning, development, testing, implementation, and monitoring predictive or prescriptive analytics solutions to strategic business problems and drive home future innovation.
Role Description:
- An analyst in this role will be expected to:
-Understand how to retrieve data from a data warehouse using SQL queries.
-Able to communicate well in BOTH verbal and written English.
-Independently drive the completion of assigned projects, including arranging meetings with relevant stakeholders.
-Create and share documentation with team members.
- Provides analytic and operational support for plans to implement user-centered, advanced analytical solutions to strategic business problems.
- Key ownership areas may include market and competitive intelligence, user-centered solutions and implementation of advanced analytics projects; and support of strategy, planning and visioning.
- Executes against project plans or agile user stories on time and effectively communicates the status of analytical solutions to key stakeholders.
- Supports business objectives for acquisition, retention, cross-selling, profitability, and agency development by assisting in advanced analytic projects.
- Researches market and competitive intelligence to drive strategy at Farmers and identifies opportunities for innovation and advanced analytical solutions. Performs other duties as assigned.
Requirements
English Proficiency
- Minimum Required: Fluent (Written and Spoken)
Software / Tool Skills
- SQL - Advances
- Power BI - Advanced
- Excel - Entry Level
Benefits
- Competitive salary and performance-based bonuses
- Comprehensive benefits package
- Career development and training opportunities
- Dynamic and inclusive work culture within a globally renowned group
- Private Health and Dental Insurance
- Pension Plan
- Meals tickets
- Life Insurance
Skills Required
- Fluent in English (written and spoken)
- Advanced SQL skills
- Advanced Power BI skills
- Entry level Excel skills
Capgemini Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Capgemini and has not been reviewed or approved by Capgemini.
-
Healthcare Strength — Health coverage is positioned as comprehensive, spanning medical, dental, and vision alongside life and AD&D options. Additional wellbeing supports like employee assistance programs, gym discounts, and pet insurance broaden the value beyond core insurance.
-
Parental & Family Support — Family-related benefits include maternity/paternity leave and broader family-forming support such as fertility and surrogacy assistance in some locations. Inclusive caregiving supports like back-up child and elder care and out-of-state medical travel are also highlighted.
-
Equity Value & Accessibility — Equity participation is available through recurring employee share ownership or purchase programs, creating a longer-term wealth-building option in addition to salary. Eligibility and local access can vary, so confirming participation windows and requirements is important.
Capgemini Insights
What We Do
Capgemini is a global leader in partnering with companies to transform and manage their business by harnessing the power of technology. The Group is guided everyday by its purpose of unleashing human energy through technology for an inclusive and sustainable future. It is a responsible and diverse organization of 270,000 team members in nearly 50 countries. With its strong 50 year heritage and deep industry expertise, Capgemini is trusted by its clients to address the entire breadth of their business needs, from strategy and design to operations, fueled by the fast evolving and innovative world of cloud, data, AI, connectivity, software, digital engineering and platforms. The Group reported in 2020 global revenues of €16 billion.








