Cynet Systems
Cynet Systems

Senior Data Migration Analyst

Jersey City, NJ, US • Posted 1 day ago • Updated 1 day ago
Contract W2
Contract Corp To Corp
7 Months
On-site
Depends on Experience
Fitment

Dice Job Match Score™

👤 Reviewing your profile...

Job Details

Skills

  • Data Migration Analyst

Summary

We are looking for a Senior Data Migration Analyst for our client in Jersey City, NJ
Job Title: Senior Data Migration Analyst
Job Location: Jersey City, NJ
Job Type: Contract
Job Overview:
Pay Range: $55hr - $60hr
Responsibilities:
  • Reverse engineer SQL stored procedures/views, configs, and dependencies.
  • Create source-to-target mapping (STTM) docs with field-level transformation logic and business rules.
  • Translate existing logic into ADF/Databricks implementation guidance (orchestration, incremental loads, error handling, audit patterns).
  • Document data lineage across Source staging curated (Databricks).
  • Partner with stakeholders (business, actuary/claims ops, data engineering) to validate business rules and define acceptance criteria.
  • Define reconciliation checks to validate parity between SSIS and rebuilt pipelines.
Required Skills:
  • Advanced SQL (complex joins, CTEs, window functions, performance-aware logic).
  • Hands-on experience analysing and documenting SSIS packages (Derived Column, Lookup, Conditional Split, Merge Join, Aggregate, Script).
  • Proven ability to produce mapping/spec documents that developers can build from with minimal back-and-forth.
  • Strong understanding of ETL concepts: incremental/full loads, SCD/deduping, data quality rules, audit columns, error handling.
Nice-to-Have:
  • Familiarity with ADF pipelines, Databricks (Delta Lake), medallion architecture, Unity Catalog.
  • Experience with Snowflake as a source, and on prem connectivity patterns (Self-hosted IR).
  • Insurance domain exposure: claims, policy, billing, underwriting, reinsurance, producer/agent data.
  • Tools / Documentation Expectations:
  • We value candidates who can produce crisp, engineering-grade documentation.
  • STTM in Excel/Confluence with traceability IDs (Rule-001, Transform-010).
  • Process/lineage diagram (Visio/Lucid chart/Miro).
  • Validation pack (SQL scripts or Databricks notebook checks).
Skills and Experience:
  • 5+ years C# .NET coding experience.
  • Lead or Sole Developer experience.
  • Containerisation and deployment with microservices including centralised logging.
  • Full REST API Design and delivery and experience using SOAP backend interfaces.
  • Familiarity with OAuth / MSAL Authentication and Authorization.
  • Full understanding and capability using and managing Azure DevOps, Github and Git for build and deploy automation.
  • IDE experience with Visual Studio Code and GitHub Copilot.
  • Plus would be experience in Terraform using Azure DevOps and Dynatrace logging and Kubernetes (AKS).
Scope of Work:
  • General.
  • API Design & Build (C#/.NET 8)
  • REST endpoints (versioned) for: Create Policy, Amend/MTA, Renew, Bind, Cancel, GetStatus.
  • Idempotency, request validation, correlation IDs, and deterministic error contracts.
  • Callback endpoints to accept booking/bind confirmations from IRIS/PC.
  • Integration Adapters.
  • Desirable - IRIS adapter for skeleton/policy endpoints; handle optional/mandatory field variability.
Security and Identity/Observability:
  • Azure AD (MSAL) client credentials flow; per-endpoint authorization policies.
  • Dynatrace integration.
  • Health checks (liveness/readiness), feature flags (e.g., gradual cutover).
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 10516350
  • Position Id: NJ_SDMA_0529
  • Posted 1 day ago
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Database Migration Specialist / Database Architect

Jersey City, New Jersey

•

Yesterday

Easy Apply

Contract

Depends on Experience

Data Analyst

Remote or New York, New York

•

Yesterday

Contract

160

ETL SQL Data Engineer (Snowflake)-Senior

Jersey City, New Jersey

•

2d ago

Easy Apply

Contract, Third Party

Senior Data Warehouse Developer

Jersey City, New Jersey

•

Today

Easy Apply

Contract

$68.00 - $68.25 per hour

Search all similar jobs