Delta System & Software, Inc.
Senior Data Engineer
⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for a Senior Data Engineer with 12+ years of experience, focusing on SQL Server, SSIS, and Guidewire. It offers a long-term W2 contract in Erie, PA (Hybrid). Key skills include ETL development and insurance domain expertise.
🌎 - Country
United States
💱 - Currency
$ USD
-
💰 - Day rate
Unknown
-
🗓️ - Date
March 4, 2026
🕒 - Duration
Unknown
-
🏝️ - Location
Hybrid
-
📄 - Contract
W2 Contractor
-
🔒 - Security
Unknown
-
📍 - Location detailed
Erie, PA
-
🧠 - Skills detailed
#Documentation #SQL Queries #Data Warehouse #EDW (Enterprise Data Warehouse) #Indexing #Microsoft SQL Server #SQL Server #Data Quality #Data Engineering #SSIS (SQL Server Integration Services) #"ETL (Extract #Transform #Load)" #MS SQL (Microsoft SQL Server) #Batch #Microsoft SQL #SQL (Structured Query Language) #Scala
Role description
Hi ,
Hope you ae doing good ,
Position : Senior Data Engineer (SQL Server, SSIS, Guidewire)
Duration : Long term contract (W2 Contract)
Location : Erie, PA (Hybrid)
Should have minimum 12+ years experience
Key Words – SQL Server, SSIS, Guidewire and ETL development, along with deep familiarity with Guidewire Policy Center data models and insurance workflows .
Job Description:
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.
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.
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.
Hi ,
Hope you ae doing good ,
Position : Senior Data Engineer (SQL Server, SSIS, Guidewire)
Duration : Long term contract (W2 Contract)
Location : Erie, PA (Hybrid)
Should have minimum 12+ years experience
Key Words – SQL Server, SSIS, Guidewire and ETL development, along with deep familiarity with Guidewire Policy Center data models and insurance workflows .
Job Description:
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.
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.
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.
