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.

With over two decades of unparalleled experience, Derex provides supports to its clientele, across such industries as Systems Integration, Banking and Finance, Telecommunications, Pharmaceutical and Life Sciences, Energy, Healthcare, Technology, Transportation, and local and federal Government agencies.

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)

1) Schema, Data Model & Mapping Validation

1. Validate database schemas and data models supporting Guidewire PolicyCenter reporting and downstream consumption (ODS/DWH/reporting marts).
2. Perform source-to-target validation for PolicyCenter entities to reporting tables, ensuring correct field mappings, transformations, and business rules.
3. Review and validate data dictionaries, entity relationships, and model assumptions (grain, keys, effective dating approach, history handling).

2) SSIS Extract & ETL Validation Support

1. Validate SSIS extract packages and feed outputs for completeness, accuracy, and timeliness:
   1. Row counts, key integrity, delta/incremental logic, and load schedules
   2. Error handling, rejects, and reconciliation totals
2. Execute ETL smoke tests after code releases and configuration/product model changes to ensure no downstream data regressions.
3. Collaborate with ETL developers to troubleshoot failures by identifying the break point (source query, transformation, staging, load, or reporting layer).

3) Deep PolicyCenter Table & Data Domain Expertise

1. 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).
2. Support interpretation of policy transaction behaviour in data, including New Business, Renewal, Endorsement, Cancellation, Reinstatement, and Rewrite scenarios.
3. Ensure accurate representation of coverages, modifiers, and risk attributes in extracts and reporting datasets.

4) Developer Enablement (SQL Query Support)

1. Assist developers and analysts by providing guidance and examples for writing optimized SQL queries to retrieve records by:
   1. Coverage selection (coverage patterns/terms, limits/deductibles, endorsements)
   2. Effective dates / as-of dates (policy period effective windows, transaction effective dates)
   3. Transaction/job types and policy status conditions
2. Help teams correctly interpret data grain (policy vs policy period vs job vs coverage/risk row) to avoid double-counting and misreporting.
3. Recommend indexing/filters and query patterns to improve performance for high-volume reporting and extracts.

5) Data Quality, Reconciliation & Controls

1. Define and execute recurring data quality checks:
   1. Completeness (required fields populated)
   2. Valid values (domain/code set adherence)
   3. Referential integrity (key relationships)
   4. Duplicate detection and outlier checks
2. Reconcile totals across layers (PolicyCenter source → SSIS staging → target reporting tables) for:
   1. Policy counts, transaction counts, exposures, and premium totals
3. Document findings and partner with Guidewire/config/integration teams to resolve data defects.

6) Documentation & Knowledge Sharing

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

Skills / Qualifications to Add (Aligned to the Above)

Use this as an add-on under “Required Skills” or “Qualifications”:

Required

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

Preferred (Nice-to-have)

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

Regards,

Manoj

Derex Technologies INC

Contact : 973-834-5005 Ext 206

All your information will be kept confidential according to EEO guidelines.