echnical Business Systems Analyst ADF Databricks
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 Databricks 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 Databricks📍 Role: Technical Business Systems Analyst ADF Databricks📌 Type: Long Term Contract📍 Location: Jersey City, NJ🛠️ Key ResponsibilitiesReverse engineer SSIS control data flows SQL stored procedures views configs and dependenciesCreate source to target mapping STTM docs with field level transformation logic and business rulesTranslate existing logic into ADF Databricks implementation guidance orchestration incremental loads error handling audit patternsDocument data lineage across Snowflake on prem staging curated DatabricksPartner with stakeholders business actuary claims ops data engineering to validate business rules and define acceptance criteriaDefine reconciliation checks and test plans to validate parity between SSIS and rebuilt pipelinesRequired SkillsAdvanced SQL complex joins CTEs window functions performance aware logicHandson experience analyzing and documenting SSIS packages Derived Column Lookup Conditional Split Merge Join Aggregate ScriptProven ability to produce mapping spec documents that developers can build from with minimal back and forthStrong understanding of ETL concepts incremental full loads SCD deduping data quality rules audit columns error handlingNice to HaveFamiliarity with ADF pipelines Databricks Delta Lake medallion architecture Unity CatalogExperience with Snowflake as a source and on prem connectivity patterns Selfhosted IRInsurance domain exposure claims policy billing underwriting reinsurance produceragent dataTools Documentation ExpectationsWe value candidates who can produce crisp engineering grade documentation ExamplesSTTM in Excel Confluence with traceability IDs Rule001 Transform010Process line age diagram Visio Lucid chart MiroValidation pack SQL scripts or Databricks notebook checks📩 Interested or open to new opportunities?Please send your updated resume with contact details to vikas@nytpcorp.comThanks and RegardsVikas Mahindrakar📞 Direct: 201-604-3998New York Technology Partners120 Wood Avenue S | Suite 504 | Iselin, NJ 08830