Data Engineer – SQL & Power BI for P&C Insurance

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

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