Job Title: Senior Data Engineer (SQL Server, SSIS, Guidewire)
Location: Erie PA
Long Term Conract - W2 Only
Job Summary
We are seeking a Senior Data Engineer with strong expertise in SQL Server and ETL development, along with deep familiarity with Guidewire PolicyCenter data models and insurance workflows.
This role will support and enhance our MS SQL Server–based Enterprise Data Warehouse (EDW), which is loaded through SSIS batch processes. The ideal candidate must be able to translate complex Guidewire operational data structures into well-designed, scalable warehouse solutions. While strong SQL Server and ETL skills are required, deep knowledge of Guidewire data structures and insurance domain workflows is a key differentiator for this position.
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.
Never miss an opportunity! Create an alert based on the job you applied for.
