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

Capgemini; México; Hybrid; MXN 600,000 - 900,000; Full time

Benefits offered by this job

Competitive compensation

Comprehensive benefits

Flexible work arrangements (remote/ons

Inclusive culture

Private Health Insurance

Paid Time Off

Training & Development opportunities

Job summary

Capgemini, on behalf of Farmers' operations, is seeking a Data Engineer with a strong P&C insurance background to translate business needs into clear, actionable requirements for reporting and analytics. You will partner with business stakeholders, product owners, and technology teams to ensure reliable data solutions.

Core responsibilities include gathering and documenting requirements, supporting data product certification, validating business rules, planning UAT, and collaborating with data

Qualifications

• Experience as a Data Engineer in insurance domains.
• Ability to gather and document business requirements.
• Focus on data quality, reporting, and analytics.

Responsibilities

• Develops moderately complex analytics solutions for data quality and reporting.
• Collaborates with cross-functional teams to define analytics requirements.
• Creates detailed business plans and documentation for stakeholders.
• Liaises between IT, Product Management, and data teams.
• Implements data integration strategies across data marts and warehouses.
• Improves dashboards, reports, and data platforms to meet evolving needs.
• Supports UAT planning and execution with SMEs and stakeholders.
• Applies standards for data elements and regulatory-compliant storage.
• Manages data from multiple sources and tracks issues and decisions.

Skills

Data engineering

P&C insurance

Requirements gathering

Documentation

Job description

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

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.

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.