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

Capgemini; United States; Híbrido; USD 110.000 - 150.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Bonuses

Benefits package

Flexible work

Inclusive culture

Health insurance

Paid Time Off

Training & Development

Descripción de la vacante

Capgemini partners with Farmers to recruit and manage data engineering initiatives. We seek a Data Engineer with a strong P&C insurance background to translate business needs into clear analytics requirements and ensure reporting, data quality, and downstream consumption meet business needs.

The role involves gathering requirements, documenting functional specs, supporting UAT, and working with data teams to deliver enterprise-wide analytics solutions.

Formación

• Experience translating business needs into functional specs for analytics.
• Background in financial services data and reporting is a plus.
• Ability to document requirements and validate data solutions.

Responsabilidades

• Gather, analyze, and document business requirements for analytics solutions.
• Translate business data stories into functional specifications for data products.
• Support source-to-target mapping and business rule validation.
• Assist with UAT planning and issue tracking.
• Collaborate with data engineering to implement requirements and ensure data quality.
• Develop and maintain analytics dashboards and reports to meet needs.

Conocimientos

Data analysis

Requirements gathering

Stakeholder collaboration

UAT planning

Data quality improvement

Documentation

Herramientas

SQL

ETL tooling

Data modeling

Data warehousing

Descripción del empleo

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.