Job Details

Senior Systems Analyst/Data Analyst
Job Title: Senior Systems Analyst/Data Analyst
Job Category: Business Analysis (functional and technical)
Job Type: Contract
Location: Hartford, Connecticut, United States
No.Openings: 1

Description:

Senior Systems Analyst/Data Analyst

Position Description
Seeking an experienced Senior Systems Analyst/Data Analyst to join our team and support of data conversion initiatives within policy administration and multi line complex P&C claims systems. This role requires strong analytical skills, attention to detail, and the ability to collaborate across multiple teams to ensure accurate and complete data migration.

This role is based in in Hartford, CT (Preferred) or New York, NY in a hybrid model with occasional travel to client site.

Your future duties and responsibilities
Discovery & Requirements
. Partner with SMEs, ETL/engineering, QA, and operations, and use SQL daily to profile, reconcile, and prove outcomes.
. Elicit conversion rules, edge cases, and data quality tolerances; define acceptance criteria.
. Produce source-to-target mapping (S2T), code crosswalks, and transformation rules with examples.
. Analysis & Specifications Write pseudo code for complex transformations; maintain data dictionaries and lineage. Define balancing logic (control totals, record counts, financial sums-premium, reserves, payments).
. Validation & Reconciliation Must be proficient in authoring simple to complex SQL queries to profile data, locate anomalies, and validate field-level conversions. Build reconciliation queries (counts/sums by key), difference checks (source vs. target), and exception lists.
. Testing & Readiness Define test scenarios/cases; support mock runs, triage defects, and track remediation. Prepare sign-off packs with evidence (SQL outputs, balancing sheets, variances with rationale).
. Cutover Support Contribute to runbooks, rollback criteria, checkpoints, and post-cutover validation.

Required qualifications to be successful in this role
. 3-7+ years in insurance data conversions (policy admin and/or claims), with strong understanding of policy lifecycle, coverages, endorsements, losses/reserves, payments, and financial controls and Insurance claim system.
. dvanced SQL (SQL Server preferred; Oracle welcome): complex joins, window functions, aggregations, set-based comparisons, performance-minded query design.
. Proven experience delivering S2T mappings, pseudo code, and reconciliation/balancing artifacts for multiple mock conversions and go-live.
. Hands-on data validation and UAT support; clear documentation and stakeholder communication.

Education: Bachelor's degree in computer science or related field.