
Data Engineer at Capgemini. Our Client is one of the United States’ largest insurers, providing a wide range of insurance and financial services products with gross written premium 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.. Essential Job Functions. Consults on data projects of intermediate complexity, with limited coaching and guidance, to understand design requirement and existing business processes to lead in the design, development, and implementation of data products. Practices code management and integration with current architectural and data governance guidelines with reduced oversight required of leadership. Produces data building blocks, data models, and data flows for varying client requests such as dimensional data, standard and ad hoc reporting, data feeds, dashboard reporting, and data science research and exploration with limited assistance and coaching. Creates business user access methods to structured and unstructured data. Utilizes techniques such as mapping data to a common data model, natural language processing, transforming data as necessary to satisfy business rules, AI, statistical computations, and validation of data content. Translates business data stories into a technical story breakdown structure and work estimates for a schedule or planned agile sprint. Projects are of increasing complexity but require less coaching and assistance from leadership. Develops and maintains moderately complex scalable data pipelines for both streaming and batch requirements and builds out new API integrations to support increased demands of data volume and complexity. Preps/cleanses data to optimize for downstream reporting via Farmers standard visualization or AI/ML tools with coaching and feedback. Applies sound knowledge of data governance concepts with limited experience in application. Executes on mid size projects and large tasks within timelines. Develops data project plans and executes with some supervision. Performs other duties as assigned.. Total Work Experience: . Minimum Required: 4-6 / Preferred: 7-9. Work Experience in This Field: . Minimum Required: 4-6 / Preferred: 7-9. English Proficiency: . Fluent. Required Education: . Minimum Required: Bachelor. Required Branch(es) of study: . Computer Science / Related. Additional Preferred Branch(es) of Study: . Insurance P&C knowledge. Software / Tool Skills. SQL/PLSQL - Advanced (7+ Years). Data Warehousing - Intermediate (4-6 Years). Oracle Data Integrator ETL - Intermediate (4-6 Years). Oracle Platform - Intermediate (4-6 Years). Office Suite - Intermediate (4-6 Years). .Net - Entry Level (1-3 Years) . . Company Location: Mexico.