{"schemaVersion":"jobsearcher.job.v1","id":"74ee05a339bada715040b403","url":"https://jobsearcher.com/jobs/74ee05a339bada715040b403","canonicalUrl":"https://jobsearcher.com/jobs/74ee05a339bada715040b403","title":"US_East | Application Consultant - Application Server Technologies_L3","description":"Role Name: BSA (Technical Business Systems Analyst – ADF/Databricks) Location: Jersey City JOB DESCRIPTION Role: Technical Business Systems Analyst (ADF / Databricks Migration – Mid/Senior Level) Summary We are seeking a mid-to-senior Technical Business Systems Analyst with strong SQL and SSIS expertise to support the migration of legacy SSIS ETL pipelines to Azure Data Factory (ADF) and Databricks. This role focuses on reverse engineering SSIS packages and SQL transformations and producing developer-ready mapping and functional specification documents to enable accurate rebuilding of pipelines in ADF/Databricks. Key Responsibilities:Reverse engineer SSIS control/data flows, SQL stored procedures, views, configurations, and dependenciesCreate source-to-target mapping (STTM) documentation with field-level transformation logic and business rulesTranslate existing logic into ADF/Databricks implementation guidance including orchestration, incremental loads, error handling, and audit patternsDocument data lineage across Snowflake, on-prem staging, and Databricks curated layersCollaborate with business stakeholders (actuary, claims, ops) and data engineering teams to validate business rules and define acceptance criteriaDefine reconciliation checks and test plans to ensure parity between SSIS and rebuilt pipelines Required Skills:Advanced SQL (complex joins, CTEs, window functions, performance optimization)Hands-on experience analyzing and documenting SSIS packages (Derived Column, Lookup, Conditional Split, Merge Join, Aggregate, Script tasks)Proven ability to create developer-ready mapping/specification documents with minimal back-and-forthStrong understanding of ETL concepts: incremental/full loads, SCD, deduplication, data quality rules, audit columns, error handling Preferred / Nice to Have:Familiarity with ADF pipelines, Databricks, Delta Lake, Medallion Architecture, Unity CatalogExperience with Snowflake and on-prem connectivity patterns (Self-hosted Integration Runtime)Insurance domain experience (claims, policy, billing, underwriting, reinsurance, producer/agent data) Tools & Documentation Expectations: Candidates should be able to produce engineering-grade documentation, including:STTM (Excel/Confluence) with traceability IDs (e.g., Rule001, Transform010)Process/lineage diagrams (Visio, Lucidchart, Miro)Validation packs (SQL scripts or Databricks notebook checks) \"All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.\"","company":"Datum Software","rawCompany":"datum software","city":"Des Plaines","state":"IL","isRemote":false,"isActive":false,"createdAt":"2026-05-04T06:46:33.566Z","occupations":[{"code":"15-1243.01","title":"Data Warehousing Specialists","slug":"data-warehousing-specialists"},{"code":"15-1211.00","title":"Computer Systems Analysts","slug":"computer-systems-analysts"},{"code":"15-1299.08","title":"Computer Systems Engineers/Architects","slug":"computer-systems-engineers-architects"}],"industries":[{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"541511","title":"Custom Computer Programming Services","slug":"custom-computer-programming-services"},{"code":"513210","title":"Software Publishers","slug":"software-publishers"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"US_East | Application Consultant - Application Server Technologies_L3","description":"Role Name: BSA (Technical Business Systems Analyst – ADF/Databricks) Location: Jersey City JOB DESCRIPTION Role: Technical Business Systems Analyst (ADF / Databricks Migration – Mid/Senior Level) Summary We are seeking a mid-to-senior Technical Business Systems Analyst with strong SQL and SSIS expertise to support the migration of legacy SSIS ETL pipelines to Azure Data Factory (ADF) and Databricks. This role focuses on reverse engineering SSIS packages and SQL transformations and producing developer-ready mapping and functional specification documents to enable accurate rebuilding of pipelines in ADF/Databricks. Key Responsibilities:Reverse engineer SSIS control/data flows, SQL stored procedures, views, configurations, and dependenciesCreate source-to-target mapping (STTM) documentation with field-level transformation logic and business rulesTranslate existing logic into ADF/Databricks implementation guidance including orchestration, incremental loads, error handling, and audit patternsDocument data lineage across Snowflake, on-prem staging, and Databricks curated layersCollaborate with business stakeholders (actuary, claims, ops) and data engineering teams to validate business rules and define acceptance criteriaDefine reconciliation checks and test plans to ensure parity between SSIS and rebuilt pipelines Required Skills:Advanced SQL (complex joins, CTEs, window functions, performance optimization)Hands-on experience analyzing and documenting SSIS packages (Derived Column, Lookup, Conditional Split, Merge Join, Aggregate, Script tasks)Proven ability to create developer-ready mapping/specification documents with minimal back-and-forthStrong understanding of ETL concepts: incremental/full loads, SCD, deduplication, data quality rules, audit columns, error handling Preferred / Nice to Have:Familiarity with ADF pipelines, Databricks, Delta Lake, Medallion Architecture, Unity CatalogExperience with Snowflake and on-prem connectivity patterns (Self-hosted Integration Runtime)Insurance domain experience (claims, policy, billing, underwriting, reinsurance, producer/agent data) Tools & Documentation Expectations: Candidates should be able to produce engineering-grade documentation, including:STTM (Excel/Confluence) with traceability IDs (e.g., Rule001, Transform010)Process/lineage diagrams (Visio, Lucidchart, Miro)Validation packs (SQL scripts or Databricks notebook checks) \"All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.\"","datePosted":"2026-05-04T06:46:33.566Z","dateModified":"2026-05-04T06:46:33.566Z","hiringOrganization":{"@type":"Organization","name":"Datum Software","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Des Plaines","addressRegion":"IL","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"74ee05a339bada715040b403"},"url":"https://jobsearcher.com/jobs/74ee05a339bada715040b403"}}