FBS Application Subject Matter Expert III (Power BI & Finance Reporting)

Capgemini; United States; On-site; USD 90,000 - 130,000; Full time

Benefits offered by this job

Competitive salary and bonuses

Health Insurance

Pension Plan

Paid Time Off

Training & Development

Career development

Job summary

Farmers Insurance is seeking an Application Subject Matter Expert III in the SAP Finance domain to advance Power BI reporting across the Finance organization. You will design, develop, and optimize dashboards, KPIs, and executive reports and partner with Finance leaders to translate business needs into analytics solutions.

You will connect SAP and other data sources, drive automation and AI enhancements with Copilot, and ensure production reporting reliability while supporting platform

Qualifications

• 4-6 years of experience in BI, Reporting, Analytics, or a related field.
• Strong Power BI development skills (data modeling, DAX, Power Query).
• Ability to translate business needs into reporting solutions.
• Experience collaborating with Finance leaders and stakeholders.
• Knowledge of SAP data environments preferred but not required.

Responsibilities

• Design, develop, and maintain Power BI dashboards.
• Develop Financial Reporting, Executive Dashboards, KPI Dashboards, and Operational Reporting solutions.
• Partner with Finance leadership to gather requirements and translate business needs into reporting solutions.
• Connect, transform, and model data from SAP and other database environments.
• Support and maintain production reporting environments.
• Enhance reporting capabilities through automation, AI, and Copilot technologies.
• Drive continuous improvements to reporting processes and platform functionality.

Skills

Power BI

Data Modeling

DAX

Power Query

Dashboard Development

Data Visualization

Stakeholder Communication

Education

Bachelor's degree

Tools

SAP

GitHub

Copilot

Power Automate

Job description

OurClientis one of the United States’ largest insurers,providinga 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 andnearly18,500employees. Finally, ourClientis part of one the largest Insurance Groups in the world.

Job Summary

The SAP Finance team supports data, analytics, and financial reporting across the Farmers Finance organization. The team is responsible for developing, supporting, and enhancing the Power BI reporting platform used by Finance stakeholders to support reporting, analytics, and business decision‑making.

The Application Subject Matter Expert III will serve as a key contributor to the SAP Finance reporting ecosystem, supporting the design, development, maintenance, and enhancement of Power BI reporting solutions. This role partners directly with Finance leaders and business stakeholders to deliver impactful analytics and reporting capabilities while helping modernize the platform through automation, AI, and Microsoft Copilot integration.

Key Responsibilities

Design, develop, and maintain Power BI dashboards and reporting solutions.

Develop Financial Reporting, Executive Dashboards, KPI Dashboards, and Operational Reporting solutions.

Partner directly with Finance leadership and business stakeholders to gather requirements and translate business needs into reporting solutions.

Connect, transform, and model data from SAP and other database environments.

Support and maintain production reporting environments.

Troubleshoot reporting, data quality, and system issues.

Enhance reporting capabilities through automation, AI, and Microsoft Copilot technologies.

Drive continuous improvements to reporting processes and platform functionality.

4-6 years of experience in Business Intelligence, Reporting, Analytics, Application Development, or a related field.

Fluent English, both written and verbal.

Bachelor's degree in Computer Science, Information Systems, Business Analytics, Finance, Accounting, or a related discipline preferred.

Technical Skills

4-6 years of hands‑on experience with Power BI development, including:

• Data Modeling
• DAX
• Power Query
• Dashboard and Report Development
• Data Visualization Best Practices

Experience working with reporting environments and database platforms; SAP experience is preferred but not required.

Knowledge of enterprise reporting architectures and data integration concepts.

Familiarity with Microsoft Copilot and AI-enabled productivity solutions.

Experience with Microsoft Power Automate preferred.

Exposure to GitHub or source control tools preferred.

Business Knowledge

Ability to work directly with stakeholders across multiple levels of the organization.

Understanding of Finance and Accounting principles and reporting requirements.

Familiarity with financial reporting, P&L analysis, and business performance metrics.

Insurance industry knowledge is a plus.

Strong analytical, problem‑solving, and communication skills.

Ability to translate complex business requirements into technical reporting solutions.

Competitive compensation and benefits package:

1. Competitive salary and performance-based bonuses
2. Comprehensive benefits package: Grocery vouchers, saving funds, SGMM, etc.
3. Career development and training opportunities
4. Dynamic and inclusive work culture within a globally renowned group
5. Private Health Insurance
6. Pension Plan
7. Paid Time Off
8. 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.