Skip to content
mimi

Technical Data Business Analyst

New York Technology Partners

Jersey City ยท On-site Contract Mid Level 1mo ago

About the role

Role: Technical Business Systems Analyst ADF Databricks

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 Databricks implementation guidance orchestration incremental loads error handling audit patterns
  • Document data lineage across Snowflake on prem staging curated Databricks
  • Partner with stakeholders 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
  • Handson 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 Databricks Delta Lake medallion architecture Unity Catalog
  • Experience with Snowflake as a source and on prem connectivity patterns Selfhosted IR
  • Insurance domain exposure claims policy billing underwriting reinsurance produceragent 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 line age diagram Visio Lucid chart Miro
  • Validation pack SQL scripts or Databricks notebook checks

Skills

ADFDatabricksETLSQLSSISSnowflake

Don't send a generic resume

Paste this job description into Mimi and get a resume tailored to exactly what the hiring team is looking for.

Get started free