LiftmyCVLiftmyCV
DT

Data Analyst with Guidewire Policy Center

Derex Technologies IncRemoteErie, US
AI job summary

Derex Technologies Inc is looking for a Data Analyst with expertise in Guidewire PolicyCenter. The ideal candidate should have over 12 years of IT experience, including 8+ years as a Data Analyst and 5+ years working with Guidewire. Responsibilities include validating schemas and data models, supporting ETL processes, demonstrating expertise in PolicyCenter data structures, enabling developers with SQL query support, ensuring data quality and reconciliation, and maintaining documentation. This role is remote with a focus on collaboration across various client industries.

Job description

Description

Derex Technologies Inc specializes in providing IT consulting, staffing solutions and software services. Globally headquartered in Harrison New Jersey since 1996 Derex delivers the highest quality technology professionals and an array of customized IT talent solutions designed to improve productivity and drive results to global clients throughout North America.

Role: Data Analyst with Guidewire PolicyCenter

Location: Erie, PA (Remote)

Must have working experience on Guidewire PolicyCenter.

Experience:

  • Overall, 12 of IT experience with 8+ years of experience working as a Data Analyst and 5+ years of experience working on Guidewire application.

Updated Responsibilities (Associate – PolicyCenter Data & Reporting)

  • Schema, Data Model & Mapping Validation
  • Validate database schemas and data models supporting Guidewire PolicyCenter reporting and downstream consumption (ODS/DWH/reporting marts).
  • Perform source-to-target validation for PolicyCenter entities to reporting tables, ensuring correct field mappings, transformations, and business rules.
  • Review and validate data dictionaries, entity relationships, and model assumptions (grain, keys, effective dating approach, history handling).
  • SSIS Extract & ETL Validation Support

Validate SSIS extract packages and feed outputs for completeness, accuracy, and timeliness:

  • Row counts, key integrity, delta/incremental logic, and load schedules
  • Error handling, rejects, and reconciliation totals
  • Execute ETL smoke tests after code releases and configuration/product model changes to ensure no downstream data regressions.
  • Collaborate with ETL developers to troubleshoot failures by identifying the break point (source query, transformation, staging, load, or reporting layer).
  • Deep PolicyCenter Table & Data Domain Expertise
  • Demonstrate deep understanding of PolicyCenter table structures and key relationships, including effective-dated patterns and core entities (e.g., Account/Policy/PolicyPeriod/Job and related risk, coverage, and transaction tables).
  • Support interpretation of policy transaction behaviour in data, including New Business, Renewal, Endorsement, Cancellation, Reinstatement, and Rewrite scenarios.
  • Ensure accurate representation of coverages, modifiers, and risk attributes in extracts and reporting datasets.
  • Developer Enablement (SQL Query Support)

Assist developers and analysts by providing guidance and examples for writing optimized SQL queries to retrieve records by:

  • Coverage selection (coverage patterns/terms, limits/deductibles, endorsements)
  • Effective dates / as-of dates (policy period effective windows, transaction effective dates)
  • Transaction/job types and policy status conditions
  • Help teams correctly interpret data grain (policy vs policy period vs job vs coverage/risk row) to avoid double-counting and misreporting.
  • Recommend indexing/filters and query patterns to improve performance for high-volume reporting and extracts.
  • Data Quality, Reconciliation & Controls

Define and execute recurring data quality checks:

  • Completeness (required fields populated)
  • Valid values (domain/code set adherence)
  • Referential integrity (key relationships)
  • Duplicate detection and outlier checks

Reconcile totals across layers (PolicyCenter source → SSIS staging → target reporting tables) for:

  • Policy counts, transaction counts, exposures, and premium totals
  • Document findings and partner with Guidewire/config/integration teams to resolve data defects.
  • Documentation & Knowledge Sharing

Maintain and update documentation such as:

  • Table relationship guides, join paths, and common query patterns
  • Data lineage notes and reconciliation playbooks
  • Known data caveats (effective-dated nuances, cancellation/rewrite handling, quote vs issued distinctions)
  • Contribute to a reusable library of SQL snippets and validation checklists for the team.

Skills / Qualifications to Add (Aligned to the Above)

Required

  • Strong SQL skills (multi-table joins, CTEs, window functions; ability to debug logic and performance).
  • Experience validating SSIS extracts / ETL outputs (counts, deltas, reconciliation, error triage).
  • Working knowledge of data modeling (keys, grain, dimensions/facts, history/effective-dated concepts).
  • Hands-on exposure to Guidewire PolicyCenter data and ability to navigate PolicyCenter tables for reporting.

Preferred (Nice-to-have)

  • Familiarity with downstream reporting layers (ODS/DWH/marts) and BI tools (SSRS/Power BI/Tableau).
  • Experience creating data validation scripts and repeatable reconciliation controls.
  • Understanding of P&C policy lifecycle and transaction types.

Job details

Published
March 17, 2026
Last checked
May 1, 2026
Job source
smartrecruiters
Workplace
Remote · Erie, US
First seen
March 17, 2026
AI match explained

See how well you match this job

Log in or sign up and Eva will compare your profile with this role, explain your strengths and show what to improve.

Sign up to see your matchAlready have an account? Log in

More at Derex Technologies Inc

Similar jobs from this company

None listed.

Across the market

Similar jobs from other companies

Third-party content disclaimer

Full job descriptions are sourced directly from third-party applicant tracking systems (ATS), job boards, recruitment platforms, and employer career pages.

LiftmyCV does not claim ownership of this content or guarantee its accuracy or current availability. All original content is the intellectual property of the respective employers or other rights holders.

LiftmyCV hiring intelligence, availability checks, and related-job recommendations are generated from LiftmyCV data and public sources.

If you prefer, you may apply directly via the original listing for transparency.