More jobs:
Senior Data Engineer; SQL Server, SSIS, Guidewire
Job in
Indianapolis, Hamilton County, Indiana, 46262, USA
Listed on 2026-03-12
Listing for:
MetaRPO
Full Time
position Listed on 2026-03-12
Job specializations:
-
IT/Tech
Data Engineer, Data Analyst -
Engineering
Data Engineer
Job Description & How to Apply Below
Location: Indianapolis
We are seeking a Senior Data Engineer with strong expertise in SQL Server and ETL development, along with deep familiarity with Guidewire Policy Center 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 Policy Center 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.
- 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 Policy Center 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.
Position Requirements
10+ Years
work experience
To View & Apply for jobs on this site that accept applications from your location or country, tap the button below to make a Search.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
Search for further Jobs Here:
×