Hi, This is Srikanth from Reliable Software. We have an opportunity with one of our direct clients, and I''d like to share the details with you. Please review the information below and let me know if you''re interested. Kindly share your updated resume if you''d like to be considered.
Job Title: Senior Data Engineer (SQL Server, SSIS, Guidewire)
Location: PA - Onsite
Long Term
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.
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.
Educational Qualifications:
· Required - Bachelor’s degree in Computer Science, Information Technology, Computer Engineering or closely related or equivalent.
· Preferred - Master’s degree in Management Information Systems (MIS), Computer Science, Big Data or Analytics or equivalent.
Travel:
· Open to travel based-up on the nature of the engagement.
Thanks & Regards
Srikanth Donkani
Lead Talent Acquisition Specialist
(w):
(E):
2260 Haggerty Road, Suite 285 Northville, MI 48167
Equal Employment Opportunity
Reliable Software employment does not discriminate on the basis of race, religion, gender, sexual orientation, age or any other basis as covered by federal, state, or local law.
Employment decisions are based solely on qualifications, merit and business needs.
Never miss an opportunity! Create an alert based on the job you applied for.
