Technical Data Business Analyst

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