Description Our client is one of the United States' largest insurers, providing a 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 and nearly 18,500 employees. Finally, our client is part of one the largest Insurance Groups in the world. Job Summary:
We are looking for a skilled
Data Engineer
to design, build, and maintain data pipelines that support analytics and business intelligence initiatives. This role involves both enhancing existing pipelines and developing new ones to integrate data from diverse internal and external sources. The adecuado candidate will have advanced SQL and Informatica skills, experience in ETL development, and a foundational understanding of dimensional data modeling. Experience with DBT is a plus.
Requirements
Key Responsibilities:
Design, develop, and maintain
data pipelines and ETL workflows




to ensure reliable data integration across platforms. Enhance and optimize
existing data pipelines
by adding new attributes, improving performance, or increasing maintainability. Build
new data ingestion pipelines
from a variety of structured and semi-structured sources. Use
Informatica
to develop and manage ETL processes in alignment with business requirements. Write and optimize complex
SQL queries
for data transformation, validation, and extraction. Apply basic knowledge of
dimensional data modeling
to support reporting and data warehousing needs. Collaborate with data analysts, data scientists, and business teams to understand data needs and deliver clean, structured datasets. Participate in
code reviews, documentation, and testing
to ensure quality and accuracy in data delivery. Work in agile or project-based environments to deliver on sprint goals and project timelines.
Required Skills & Quali

📌 FBS Data Engineer-ETL (Xochimilco)
🏢 Capgemini
📍 Xochimilco