The demand for robust data pipelines has exploded as companies race to become data‑driven, making ETL expertise more valuable than ever. As an ETL SSIS Lead you’ll shape the backbone that moves critical business data, positioning yourself at the intersection of technology and strategy. This contract role offers the chance to showcase leadership while working remotely on high‑impact integration projects.

Job Summary

We are seeking an experienced ETL SSIS Lead to design, develop, and optimize end‑to‑end data integration solutions using SQL Server Integration Services (SSIS). The candidate will mentor a small team, enforce best practices, and ensure reliable data flow across on‑premise and cloud environments. This contract position is remote and billed at $55/hr on a C2C basis.

Top 3 Critical Skills Table

Interview Preparation

1. Explain how you would design an SSIS package to handle slowly changing dimensions.
   What the interviewer is looking for: Understanding of CDC patterns, use of lookup transformations, and versioning logic.
2. Describe your approach to performance tuning a large‑volume SSIS package.
   What the interviewer is looking for: Knowledge of data flow buffer settings, parallelism, indexing, and logging.
3. How do you manage error handling and logging in SSIS to ensure data quality?
   What the interviewer is looking for: Use of event handlers, custom logging, and fail‑over strategies.
4. What strategies would you employ to migrate on‑premise SSIS solutions to Azure Data Factory?
   What the interviewer is looking for: Awareness of lift‑and‑shift, re‑architecting pipelines, and compatibility considerations.
5. Give an example of how you have mentored junior developers on ETL best practices.
   What the interviewer is looking for: Coaching style, concrete examples, and measurable outcomes.

Resume Optimization

• ETL
• SSIS
• Data Integration
• SQL Server
• Performance Tuning
• Data Warehousing
• Team Leadership
• C2C Contract
• Remote Work
• Slowly Changing Dimensions

Application Strategy

When reaching out to the recruiter, send a concise email that starts with a friendly greeting, attaches your updated resume, and clearly highlights your top qualifications. Make sure to mention related skills you possess, such as SSIS development, ETL architecture, and team leadership, and reference any relevant projects where you delivered high‑performance data pipelines.

Career Roadmap