BSA

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

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

• Hands-on 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
  

Preferred 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 producer agent data
  

Tools Documentation Expectations:

• We value candidates who can produce crisp engineering grade documentation Examples

• STTM in Excel Confluence with traceability IDs Rule001 Transform010

• Processlineage diagram VisioLucid chartMiro

• Validation pack SQL scripts or Databricks notebook checks
  
  

The pay range that the employer in good faith reasonably expects to pay for this position is $35.60/hour - $55.62/hour. Our benefits include medical, dental, vision and retirement benefits. Applications will be accepted on an ongoing basis.

Tundra Technical Solutions is among North America’s leading providers of Staffing and Consulting Services. Our success and our clients’ success are built on a foundation of service excellence. We are an equal opportunity employer, and we do not discriminate on the basis of race, religion, color, national origin, sex, sexual orientation, age, veteran status, disability, genetic information, or other applicable legally protected characteristic. Qualified applicants with arrest or conviction records will be considered for employment in accordance with applicable law, including the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act. Unincorporated LA County workers: we reasonably believe that criminal history may have a direct, adverse and negative relationship with the following job duties, potentially resulting in the withdrawal of a conditional offer of employment: client provided property, including hardware (both of which may include data) entrusted to you from theft, loss or damage; return all portable client computer hardware in your possession (including the data contained therein) upon completion of the assignment, and; maintain the confidentiality of client proprietary, confidential, or non-public information. In addition, job duties require access to secure and protected client information technology systems and related data security obligations.

Salary : $36 - $56