FBS - Sr Analytics Engineer

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.