FBS Data Engineer (SQL & Power BI) (Remote)

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

Requirements

Summary:

We seek a Data Engineer with a strong P&C insurance background to partner with business stakeholders, product owners, and technology teams to translate business needs into clear, actionable requirements for financial loss reporting and analytics solutions. The ideal candidate will analyze business data stories, document functional requirements, support data product certification, validate business rules, and ensure delivered solutions meet reporting, data quality, and downstream consumption needs. Core Responsibilities: Gather, analyze, and document business requirements; facilitate discussions with SMEs and stakeholders; translate business data stories into functional specifications; support source-to-target mapping and business rule validation; assist with UAT planning and execution; track issues, decisions, and approvals; and collaborate with data engineering teams to ensure requirements are implemented accurately.

Responsibilities:

• Develops moderately complex value-based analytics solutions for quality, business process functionality, or other strategic/data/analytic initiatives of moderate complexity.

• Collaborates with cross-functional teams to identify and establish analytics requirements.

• Creates detailed documentation and business plans that address stakeholder needs.

• Liaises between IT and Product Management for data solutions.

• Develops and implements moderately complex enterprise-wide data integration strategies that utilize various data-marts and data warehouse applications to enhance reporting.

• Continuously works to improve data platforms, dashboards, and reports to meet emerging and changing business demands and guidelines.

• Consults with limited guidance from Principal on UAT, technical specifications, strategic planning, contract design, technical support, testing updates, and trainings.

• Uses intermediate understanding of data elements, structures, standards typically involved in financial services transactions, reporting, and cloud-based data storage/sharing to adopt and apply standards in a way that satisfies and balances regulatory and compliance requirements with business needs.

• Manages data from multiple sources and uses project management skills to complete moderately complex projects with minimal coaching and guidance.

• Transmits data and proactively works to ensure data quality. Troubleshoots data issues and devises creative and effective ways to avoid or mitigate issues.

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.