Apply on Employer Site

PamTen Inc · 1 month ago

Senior Systems Analyst/Data Analyst

Hartford, CT

Full-time

Hybrid

Mid, Senior Level

3+ years exp

PamTen Inc is seeking an experienced Senior Systems Analyst/Data Analyst to support data conversion initiatives within policy administration and complex P&C claims systems. The role requires strong analytical skills and collaboration across multiple teams to ensure accurate data migration.

Enterprise Software

Growth Opportunities

H1B Sponsor Likely

Responsibilities

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

Write pseudo code for complex transformations; maintain data dictionaries and lineage

Define balancing logic (control totals, record counts, financial sums—premium, reserves, payments)

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

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)

Contribute to runbooks, rollback criteria, checkpoints, and post-cutover validation

Qualification

SQLData conversionS2T mappingsData validationInsurance domain knowledgeStakeholder communicationDocumentation

Required

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

Advanced 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

Bachelor's degree in computer science or related field

Company

PamTen Inc

PAMTEN is established in the year 2007 as a technology services company, and a Women Owned Business Enterprise registered in New Jersey.

Founded in 2007

Princeton, New Jersey, USA

51-200 employees

http://www.pamten.com/

H1B Sponsorship

PamTen Inc has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2025 (84)

2024 (112)

2023 (100)

2022 (100)

2021 (109)

2020 (237)

Funding

Current Stage

Growth Stage

Leadership Team

Chaya Pamula

Co-Founder, President & CEO

Anthony Pirozzi

Chief Financial Officer

Recent News

NJBIZ

Presenting the 2023 Companies to Watch (slideshow) (updated)

2023-12-23

Company data provided by crunchbase