> Markdown version of [/jobs/ext/178547-data-migration-analyst](https://www.wearedevelopers.com/jobs/ext/178547-data-migration-analyst). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Migration Analyst - **Company:** CYNET SYSTEMS INC. - **Location:** Jersey City, NJ, United States - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** .NET Framework, Microsoft Excel, Confluence, Microsoft Azure, C Sharp (Programming Language), Information Engineering, Extract Transform Load (ETL), Data Migration, Document-Oriented Databases, Github, Intrusion Detection Systems, Microsoft Visual Studio, Microsoft Visio, OAuth, Lucidchart, Reverse Engineering, Simple Object Access Protocol (SOAP), SQL Stored Procedures, SQL Databases, SQL Server Integration Services, Data Logging, Sql Optimization, GitHub Copilot, Snowflake, Backend, Git, Build Management, Containerization, Data Lakes, Kubernetes, Api Design, Interactive Whiteboards, Restful APIs, Terraform, Dynatrace, Databricks, Microservices - **Published:** May 30, 2026 - **Apply:** https://www.dice.com/job-detail/be02866e-8eea-41ab-af22-63ef461ed514 ## About the Role * 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). ## Description * 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., 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. ## Related Videos - [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94) - [Keeping applications secure by evolving OAuth 2.0 and OpenID Connect](https://www.wearedevelopers.com/videos/100152-keeping-applications-secure-by-evolving-oauth-2-0-and-openid-connect) - [Innovating Developer Tools with AI: Insights from GitHub Next](https://www.wearedevelopers.com/videos/1268-innovating-developer-tools-with-ai-insights-from-github-next) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [Git for Code Reviews](https://www.wearedevelopers.com/videos/429-git-for-code-reviews) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) ## Related Articles - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Dev Digest 120 - Apple and peers](https://www.wearedevelopers.com/magazine/455-dev-digest-120-apple-and-peers) - [Dev Digest 121 - AI goes offline](https://www.wearedevelopers.com/magazine/456-dev-digest-121-ai-goes-offline) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Dev Digest 132 - Binging WADFlix?](https://www.wearedevelopers.com/magazine/473-dev-digest-132-binging-wadflix)