SSIS / ETL Developer

Where You’ll Work

This is an onsite , 6-month temporary project assignment at our client's office in Allen, TX .

The project is tied to the maintenance and integration of two disparate, corporate SQL environments, due to a recent merger & acquisition.

Candidates must be commutable to the Dallas–Fort Worth area , to work M-F onsite daily, and also for a final in-person interview.

What You’ll Do

In this role, you will be the primary engineer responsible for building, tuning, and modernizing our SSIS ecosystem and streamlining our SQL Server infrastructure. Your core focus will be on SSIS ETL optimization, across multiple VM-based SQL Server instances.

SSIS, ETL & Data Pipeline Engineering (Primary Focus)

• Develop, enhance, and document SSIS packages supporting enterprise-wide ingestion, transformation, and load workflows
• Rebuild or refactor legacy SSIS packages for performance, reliability, and maintainability
• Optimize SQL Agent job workflows and SSIS runtime performance
• Diagnose and resolve ETL failures, bottlenecks, and dependency issues
• Adapt pipelines to support evolving business logic and new data sources
• Lead efforts to consolidate two disparate data environments into a unified, well-governed ETL framework

SQL Server Administration (On-Prem Environment)

Analytics & Reporting Integration

What You’ll Bring