Data Analyst with Guidewire Policy Center

Schema, Data Model & Mapping Validation:

• Validate database schemas and data models supporting Guidewire PolicyCenter reporting and downstream consumption.
• Perform source-to-target validation for PolicyCenter entities to reporting tables.
• Review and validate data dictionaries, entity relationships, and model assumptions.

SSIS Extract & ETL Validation:

• Validate SSIS extract packages and feed outputs for completeness, accuracy, and timeliness.
• Execute ETL smoke tests after code releases and configuration changes.
• Collaborate with ETL developers to troubleshoot failures.

Data Quality, Reconciliation & Controls:

• Define and execute recurring data quality checks.
• Reconcile totals across layers for policy counts, transaction counts, exposures, and premium totals.
• Document findings and partner with Guidewire/config/integration teams to resolve data defects.