SSIS ETL Engineer

3 weeks ago

Allen, United States UNIFY Financial Credit Union Full time

SSIS ETL Engineer (Temporary Project Role) 6-Month Contract * Onsite in Allen, TX (M-F, 9:00 AM-6:00 PM CST) Do you specialize in building and optimizing SSIS-driven ETL pipelines in complex, on-prem SQL Server environments? Join the Data & Analytics team at UNIFY Financial Credit Union, where your work will directly power critical decision-making across the organization. Where You'll Work This is an onsite, 6-month temporary project assignment at UNIFY's Operations Center in Allen, TX. The project is tied to the maintenance and integration of two disparate, corporate SQL environments, due to CommunityAmerica Credit Union's recent merger with UNIFY. 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) Administer and support multiple on-prem VM-based SQL Server instances Tune queries, indexes, and stored procedures to improve ETL throughput Monitor server health, job schedules, storage utilization, and performance baselines Implement and maintain SQL Server security, access controls, and encryption best practices Support patching, configuration, and general environment hygiene (Preferred, but not required) Assist with Azure SQL Managed Instance components Analytics & Reporting Integration Work with analysts to ensure clean, complete, well-modeled datasets flow into Power BI and SSRS Validate data accuracy throughout ETL stages and support semantic model improvements Contribute to data governance, lineage tracking, and documentation initiatives What You'll Bring 5+ years of hands-on SSIS ETL pipeline development in enterprise Microsoft SQL Server environments with particular expertise in building, tuning, and troubleshooting complex ETL pipelines Strong T-SQL proficiency, including stored procedures, functions, and performance tuning 3+ years administering SQL Server (on-prem preferred) Ability to analyze complex data flows and engineer stable, well-documented solutions Familiarity with analytics/reporting platforms such as Power BI or Tableau Strong communication and stakeholder collaboration skills Preferred: Some experience with Azure SQL (Managed Instance or Azure SQL Database) #IND123

  • SSIS / ETL Developer

    2 weeks ago

    Allen, United States Stability Technology Full time

    Where You’ll WorkThis 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...

  • SSIS / ETL Developer

    2 weeks ago

    Allen, United States Stability Technology Full time

    Where You'll WorkThis 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...

  • SSIS / ETL Developer

    3 weeks ago

    Allen, United States Stability Technology Full time

    Where You’ll WorkThis 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...

  • SSIS / ETL Developer

    1 week ago

    Allen, TX, United States Stability Technology Full time

    Where You'll WorkThis 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...

  • SSIS / ETL Developer

    1 week ago

    Allen, TX, United States Stability Technology Full time

    Where You'll WorkThis 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...

  • SSIS / ETL Developer (Allen)

    2 weeks ago

    Allen, United States Stability Technology Full time

    Where Youll WorkThis 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 DallasFort Worth area, to work M-F onsite daily, and also for a final...

  • SSIS / ETL Developer

    2 weeks ago

    Allen, TX, United States Stability Technology Full time

    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...

  • SSIS / ETL Developer

    2 weeks ago

    Allen, TX, United States Stability Technology Full time

    Where You’ll Work This is an onsite , 6-month temporary project assignment at our client's office in Allen, TX . Check all associated application documentation thoroughly before clicking on the apply button at the bottom of this description. The project is tied to the maintenance and integration of two disparate, corporate SQL environments, due to a recent...

  • SSIS / ETL Developer

    3 weeks ago

    Allen, TX, United States Stability Technology Full time

    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...

  • SSIS ETL Engineer

    2 weeks ago

    Allen, TX, United States UNIFY Financial Credit Union Full time

    SSIS ETL Engineer (Temporary Project Role) 6-Month Contract * Onsite in Allen, TX (M-F, 9:00 AM-6:00 PM CST) Do you specialize in building and optimizing SSIS-driven ETL pipelines in complex, on-prem SQL Server environments?Join the Data & Analytics team at UNIFY Financial Credit Union, where your work will directly power critical decision-making across the...