Data Engineer.

San Jose, CA - USA

Monthly Salary: Not Disclosed

Posted on: 13 hours ago

Vacancies: 1 Vacancy

Job Summary

Role : Data Engineer

Location : San Jose CA

Duration : Long term

Key Responsibilities

Support and enhance the Enterprise Data Warehouse (EDW) built on Microsoft SQL Server.
Develop maintain and optimize SSIS-based ETL batch processes.
Design and implement robust data transformation logic to integrate Guidewire PolicyCenter data into the EDW.
Analyze complex Guidewire data models and map operational structures into dimensional warehouse models.
Ensure high data quality performance tuning and optimization of SQL queries and ETL jobs.
Collaborate with business and insurance stakeholders to understand workflows and reporting needs.
Create documentation for data models mappings and transformation rules.
Troubleshoot data discrepancies and resolve production issues.
Recommend improvements to ETL processes and warehouse architecture.

Required Qualifications

12 years of experience as a Data Engineer or similar role.
Strong expertise in Microsoft SQL Server (T-SQL indexing query optimization stored procedures).
Hands-on experience with SSIS for batch ETL development.
Deep familiarity with Guidewire PolicyCenter data models.
Strong understanding of insurance domain workflows especially within Property & Casualty (P&C).
Experience designing and maintaining Enterprise Data Warehouses (EDW).
Strong analytical and problem-solving skills.
Excellent communication skills and ability to work with cross-functional teams.

Role : Data Engineer Location : San Jose CA Duration : Long term Key Responsibilities Support and enhance the Enterprise Data Warehouse (EDW) built on Microsoft SQL Server. Develop maintain and optimize SSIS-based ETL batch processes. Design and implement robust data transformation logic to ...