Remote Data Analyst

Data Analyst (Guidewire PolicyCenter) Location:Remote (U.S.-based preferred) Type: ContractOverview We are seeking an experiencedData Analyst with strong Guidewire PolicyCenter expertiseto support data validation, reporting, and ETL processes within a complex insurance environment. This role will work closely with data engineering, reporting, and application teams to ensure accuracy, integrity, and usability of PolicyCenter data across downstream systems.Key Responsibilities Data Modeling & Mapping ValidationValidate database schemas and data models supporting PolicyCenter reporting and downstream systems (ODS, data warehouse, reporting marts)Perform source-to-target mapping validation to ensure accurate data transformations and business logicReview data dictionaries, entity relationships, and model assumptions (keys, grain, effective dating, history handling)ETL & SSIS ValidationValidate ETL/SSIS processes for data accuracy, completeness, and timelinessPerform checks on row counts, key integrity, incremental/delta logic, and load schedulesSupport ETL testing cycles and troubleshoot failures across source, staging, and reporting layersPolicyCenter Data ExpertiseWork extensively with PolicyCenter data structures, including key entities such as Account, Policy, PolicyPeriod, and JobInterpret policy lifecycle transactions including New Business, Renewals, Endorsements, Cancellations, Reinstatements, and RewritesEnsure accurate representation of coverage, risk attributes, and policy-level data in reporting outputsSQL Development & SupportWrite and optimize complex SQL queries (joins, CTEs, window functions)Support developers and analysts with query logic for coverage selection, effective dates, and transaction-based reportingEnsure proper understanding of data grain to avoid duplication and misreportingRecommend performance improvements (indexing, filtering, query tuning)Data Quality & ReconciliationDevelop and execute data quality checks (completeness, validity, referential integrity, duplicates)Reconcile data across systems (source staging reporting layers)Analyze discrepancies and partner with technical teams to resolve data issuesDocumentation & Knowledge SharingMaintain documentation including data lineage, table relationships, and query best practicesCreate reusable SQL scripts, validation checklists, and reconciliation frameworksDocument known data nuances and business logic considerationsRequired Qualifications8+ years of experience as a Data AnalystHands-on experience withGuidewire PolicyCenter dataStrong 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)Preferred QualificationsExperience with data warehouses, ODS, and reporting layersFamiliarity with BI tools such as Power BI, Tableau, or SSRSExperience building data validation frameworks or reconciliation processesUnderstanding of Property & Casualty (P&C) insurance domain and policy lifecycleWhy Join UsWork on high-impact data initiatives in a complex enterprise environmentCollaborate with cross-functional teams across data, engineering, and business domainsOpportunity to contribute to scalable data quality and reporting frameworks#J-18808-Ljbffr