We are looking for a mid-senior Technical Data Business Analyst with strong SQL and SSIS expertise to support migration of legacy SSIS ETL pipelines to Azure Data Factory ADF and Data bricks The core of this role is to reverse engineer SSIS packages and SQL transformations and produce developer ready mapping and functional specification documents so engineering teams can rebuild pipelines accurately in ADF Data bricks
Role: Technical Business Systems Analyst ADF Data bricks
Type: Long Term Contract
Location: Jersey City, NJ
Key Responsibilities
Reverse engineer SSIS control data flows 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 data bricks implementation guidance orchestration incremental loads error handling audit patterns
Document data lineage across Snowflake on prem staging curated Data bricks
Partner with stakeholder s business actuary claims ops data engineering to validate business rules and define acceptance criteria
Define reconciliation checks and test plans to validate parity between SSIS and rebuilt pipelines
Required Skills
Advanced SQL complex joins CTEs window functions performance aware logic
Hands-on experience analyzing 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 Data bricks Delta Lake medallion architecture Unity Cata log
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 Examples
STTM in Excel Confluence with traceability IDs Rule001 Transform010
Process lineage diagram Visio Lucid chart Miro
Validation pack SQL scripts or Data bricks notebook checks
Interested or open to new opportunities?
Please send your updated resume with contact details to
Thanks and Regards
Vikas Mahindrakar
Direct:
New York Technology Partners
120 Wood Avenue S | Suite 504 | Iselin, NJ 08830
Never miss an opportunity! Create an alert based on the job you applied for.
