Validate database schemas and data models supporting PolicyCenter reporting and downstream systems
Perform source-to-target mapping validation to ensure accurate data transformations and business logic
Validate ETL/SSIS processes for data accuracy, completeness, and timeliness
Work extensively with PolicyCenter data structures, such as Account, Policy, and PolicyPeriod
Write and optimize complex SQL queries and support developers and analysts with query logic
Develop and execute data quality checks and reconcile data across systems

8+ years of experience as a Data Analyst
Hands-on experience with Guidewire PolicyCenter data
Strong SQL skills (complex joins, CTEs, performance tuning)
Experience validating ETL processes (SSIS or similar tools)
Solid understanding of data modeling concepts (keys, grain, dimensions/facts, effective dating)

Data Analyst

Key skills