SSIS ETL Engineer (Temporary Project Role)

UNIFY Financial Credit Union is one of the nation’s largest credit unions with a reputation for being innovative, financially sound and growth oriented. At UNIFY, our team members work together to strive toward a common goal, “providing superior service to our members.” And we are

#hiring.

Already a UNIFY Team Member?

Apply with your UNIFY email to be tagged as an internal candidate.

SSIS ETL Engineer (Temporary Project Role) 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)

UNIFY is proud to be a drug‑free, EOE including disability/vets.

If you need assistance applying due to a disability, please email application to assistance@unifyfcu.com

#J-18808-Ljbffr