Guidewire DBCC Specialist (PolicyCenter & BillingCenter)

Job Title:
Guidewire DBCC Data Integrity Specialist (PolicyCenter & BillingCenter)

Overview / Summary:
We are seeking a highly skilled Guidewire DBCC (Data Integrity) Specialist with expertise in identifying, analyzing, and resolving DBCC errors in PolicyCenter and BillingCenter. This role focuses on ensuring data integrity, system stability, and production support by proactively addressing DBCC issues and preventing recurrence.

Key Responsibilities:

• Analyze DBCC (Database Consistency Check) errors in PolicyCenter and BillingCenter
• Identify root causes of data inconsistencies and integrity issues
• Resolve DBCC errors using Guidewire-supported approaches (scripts, Gosu, SQL updates where applicable)
• Ensure consistency across policy, billing, and financial data
• Validate fixes to prevent downstream impacts on rating, billing, and reporting
• Maintain auditability and compliance during data corrections
• Identify recurring DBCC patterns and implement preventive solutions
• Recommend data validation rules and process improvements
• Automate DBCC monitoring and alerting where possible
• Collaborate with business analysts, architects, and offshore/onshore teams
• Document root cause analysis (RCA), fixes, and best practices
• Support knowledge sharing and continuous improvement initiatives
• Validate fixes through functional and regression testing
• Work with QA teams for verification

Required Qualifications:

• 10+ years of experience in Guidewire implementation/support projects
• Hands-on experience resolving DBCC errors in PolicyCenter and BillingCenter
• Strong understanding of Guidewire data model and entity relationships
• Experience with Gosu scripting and Guidewire Studio
• Knowledge of Guidewire Cloud or on-prem implementations
• Strong SQL skills (Oracle / SQL Server)
• Experience in data correction scripts and database debugging
• Understanding of transactions, data integrity, and referential constraints
• Good understanding of P&C insurance (policy lifecycle, billing, payments, commissions)
• Experience in Commercial or Personal Lines preferred
• Ability to validate fixes through functional and regression testing
• Experience working with QA teams for verification