Data Engineer

Delta is emerging as one of the fastest growing IT Staffing and professional services company specializing in SAP, Guidewire, Cloud, SRE, data and applications development. Headquartered in Texas, we are a global company with offices in Canada, India, Europe, Middle East, Australia. We help clients transform through business and technology consulting, digital solutions, applications development, maintenance and support services. Visit www.deltassi.com to learn more. Delta is an equal opportunity employer and considers all applicants irrespective of race, color, religion, citizenship, national origin, ancestry, age, sex, sexual orientation, gender identity, or any other characteristic protected by law. We are committed to creating a diverse and inclusive environment for all employees. Senior Data Engineer (SQL Server, SSIS, Guidewire) Long Term Contract Erie, PA Requirement: • 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. Thank You Kanishk Pratap kanishk.pratap@deltassi.biz