Farmers Insurance 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, Farmers Insurance is part of one the largest Insurance Groups in the world.
About the Role
We are seeking a highly skilled Customer Experience Analytics Engineer to join our analytics team. This role focuses on designing and building automated data pipelines that power dashboards, metrics, and KPI reporting across the organization.
The ideal candidate will have extensive experience working with modern data platforms and analytics technologies, including SQL, Python, dbt, and Snowflake, and will be responsible for transforming complex data into actionable business insights. You will collaborate with cross-functional teams to support customer experience initiatives through data analysis, automation, and scalable reporting solutions.
What You'll Do
- Design, develop, and maintain automated data pipelines for analytics and reporting.
- Source, extract, transform, and load data using SQL, Python, dbt, and Snowflake.
- Build and optimize data models to support business intelligence and dashboarding needs.
- Develop and maintain dashboards, metrics, and KPI reporting solutions.
- Perform ad hoc data analysis to identify trends, opportunities, and business insights.
- Collaborate with business stakeholders to understand reporting requirements and translate them into scalable data solutions.
- Support the development of business cases by providing data-driven recommendations.
- Ensure data quality, integrity, and reliability across analytics environments.
- Partner with analytics and business teams to improve customer experience measurement and reporting.
Requirements
- Bachelor's degree in a related field.
- Fluent English communication skills.
- Hands-on experience with:
- SQL (Advanced)
- Python (Advanced)
- dbt (Advanced)
- Snowflake (Advanced)
- Excel (Advanced)
- Power BI (Intermediate)
- Advanced experience using Visual Studio Code (VS Code).
- Strong understanding of data transformation, modeling, and pipeline automation.
- Experience building scalable data solutions to support business intelligence and analytics initiatives.
Benefits
This position comes with benefits package:
- Comprehensive benefits package
- Home Office model
- Career development and training opportunities
- Private Health Insurance
- Pension Plan
- Paid Time Off
- Training & Development
- Note: Benefits differ based on employee level
By applying for this position, candidates acknowledge and agree that:
• Personal Data Processing: The personal data provided during the recruitment and selection process will be collected, processed, and retained for legitimate recruitment and compliance purposes, in accordance with applicable data protection and privacy laws and FBS internal policies.
• Legal Authorization to Work: Employment with FBS is conditional upon the candidate having valid, local legal authorization to work in the country where the role is based at the time of hire. FBS does not sponsor or obtain work authorization unless explicitly stated.
• Exclusivity of Employment and Conflict of Interest: Upon acceptance of an offer and during employment with FBS, employees will not be permitted to engage in parallel employment, professional activities, or paid work for other entities. Any ownership, partnership, directorship, or participation in other businesses or companies must be fully disclosed and formally reviewed in accordance with FBS internal conflict‑of‑interest and external engagement policies prior to the start date or as soon as such circumstances arise.
Failure to comply with these conditions may impact the hiring decision or employment continuation.
Skills Required
- Bachelor's degree in a related field
- Fluent English communication skills
- Advanced SQL experience
- Advanced Python experience
- Advanced dbt experience
- Advanced Snowflake experience
- Advanced Excel experience
- Intermediate Power BI experience
- Advanced experience using Visual Studio Code
- Strong understanding of data transformation, modeling, and pipeline automation
- Experience building scalable data solutions for business intelligence and analytics initiatives
- Valid local legal authorization to work in the country where the role is based
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.
