Senior Data Engineer

About the job

ABOUT UTIS United Technologies & Information Services LLC (UTIS) is a boutique IT staffing and consulting firm headquartered in Irvine, California. We specialize in data engineering, ETL architecture, and enterprise analytics solutions built on the Microsoft data stack. Our consultants deliver hands-on technical work for Fortune 500 clients across semiconductor, financial services, and real estate technology verticals. We are investing in AI-assisted development workflows — including Claude Code by Anthropic — to accelerate delivery and set a new standard for how ETL modernization projects are executed. We are seeking an experienced Senior Data Engineer based in India to lead the conversion of approximately 100 legacy SSIS (SQL Server Integration Services) packages to Microsoft Fabric notebooks and pipelines. You will build and operate an AI-augmented migration framework using Claude Code that automates the repetitive structural conversion of SSIS packages while applying your data engineering expertise to handle the edge cases, validate output quality, and ensure production-grade results. This role combines deep SSIS knowledge with modern PySpark/Fabric skills and comfort with agentic AI development tooling. Responsibilities: • Analyze and inventory the existing SSIS package portfolio (~100 .dtsx files), documenting all data flows, control flows, connection managers, variables, expressions, and dependencies. • Execute the migration of ~100 SSIS packages to Microsoft Fabric using the accelerator framework, triaging packages by complexity tier (simple linear flows, lookup/transform-heavy, complex control flow). • Perform reconciliation testing: row counts, data type validation, transformation logic parity, and end-to-end data quality checks against source SSIS package behavior. • Generate side-by-side conversion documentation for each package with confidence scoring and manual review notes.