Stability Technology
Where Youll 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 DallasFort Worth area , to work M-F onsite daily, and also for a final in-person interview.
What Youll 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 Youll 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)
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 in-person interview.
What Youll 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 Youll 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)