Job Title- Business Data Analyst
Visa- Any
Duration- 12+ Months
Interview- Virtual
Client Location- Jersey City, NJ Onsite
Job Requirements:Job TitleTechnical Business Systems Analyst ADF Databricks Mid SeniorSummaryWe are looking for a midsenior Technical DataBusiness 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 developerready mapping and functional specification documents so engineering teams can rebuild pipelines accurately in ADFDatabricksKey ResponsibilitiesReverse engineer SSIS controldata flows SQL stored proceduresviews configs and dependenciesCreate sourcetotarget mapping STTM docs with fieldlevel transformation logic and business rulesTranslate existing logic into ADFDatabricks implementation guidance orchestration incremental loads error handling audit patternsDocument data lineage across Snowflakeon prem staging curated DatabricksPartner with stakeholders business actuaryclaims 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
 performanceaware logicHandson experience analyzing and documenting SSIS packages Derived Column Lookup Conditional Split Merge Join Aggregate ScriptProven ability to produce mappingspec documents that developers can build from with minimal backandforthStrong understanding of ETL concepts incrementalfull loads SCDdeduping data quality rules audit columns error handlingPreferred NicetoHaveFamiliarity 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 engineeringgrade documentation ExamplesSTTM in ExcelConfluence with traceability IDs Rule001 Transform010Processlineage diagram VisioLucid chartMiroValidation pack SQL scripts or Databricks notebook checks
Thanks & Regards
Vicky Yadav
Sr. Technical Recruiter
Contact -201-354-2897
Email – <a href="mailto:vicky.y@wonese.com" id="m_3455549022066684142OWAfc9d66a2-45ba-dc9e-e6ae-2c6c988366ab" title="mailto:vicky.y@wonese.com” style=”border:0px;font:inherit;margin:0px;padding:0px;vertical-align:baseline” target=”_blank”>vicky.y@wonese.com
