FBS - Consultant Marketing DATA (Insights Partner) - Capgemini

FBS – Farmer Business Services is part of Farmers operations with the purpose of building a global approach to identifying, recruiting, hiring, and retaining top talent. By combining international reach with US expertise, we build diverse and high-performing teams that are equipped to thrive in today’s competitive marketplace.

We believe that the foundation of every successful business lies in having the right people with the right skills. That is where we come in—helping Farmers build a winning team that delivers consistent and sustainable results.

Since we don’t have a local legal entity, we’ve partnered with Capgemini, which acts as the Employer of Record. Capgemini is responsible for managing local payroll and benefits.

What to expect on your journey with us:

• A solid and innovative company with a strong market presence
• A dynamic, diverse, and multicultural work environment
• Leaders with deep market knowledge and strategic vision
• Continuous learning and development

Team and Role Descriptions

Team Function:

• The Consumer Direct Analytics team provides analytical support across our direct to consumer sales channels, delivering the reporting, insights, and data models that drive business decisions. The team owns the semantic layer and certified metrics that power dashboards and self service analytics for marketing, operations, and product stakeholders.

Role Description:

• TheDecision Scientist provides analytics support for Consumer Direct, building reports and dashboards in excel and PowerBI, writing SQL against our cloud data warehouse, and maintaining dbt models and semantic layers that power business reporting.
• This role partners directly with stakeholders to translate business questions into analytical solutions and present findings clearly to both technical and executive audiences.

Requirements:
Other Critical Skills

• Analytical thinking and problem solving - Intermediate
• Stakeholder Communication and presentation skills - Intermediate
• Data storytelling (translating analysis into clear business narratives) - Intermediate
• Dimensional data modeling (star schema, semantic layer design) - Intermediate
• Attention to detail and data quality rigor - Intermediate

Software / Tool Skills
• Power BI - Entry Level
• Excel - Intermediate
• SQL - Intermediate
• Data Modeling - Intermediate

Benefits:
This position comes with a competitive compensation and benefits package.

• A competitive salary and performance-based bonuses.
• Comprehensive benefits package.
• Flexible work arrangements (remote and/or office-based).
• You will also enjoy a dynamic and inclusive work culture within a globally renowned group.
• Private Health Insurance.
• Paid Time Off.
• Training & Development opportunities in partnership with renowned companies.