Data Engineer (SSIS)

Data engineer (SSIS)

Rate - $60-$62 per hour

Location - Plano TX

Experience - 7+ Years

Job Description -

Key Responsibilities

SSIS Migration & Modernization (Mandatory)

• Analyze and assess existing SSIS packages, ETL workflows, and dependencies.
• Design migration strategies for SSIS workloads to modern cloud-based or enterprise data platforms.
• Re-engineer ETL logic while preserving business functionality.
• Develop migration accelerators, reusable frameworks, and automation solutions.
• Perform end-to-end migration, testing, deployment, and production support.

Data Engineering

• Design and build scalable data pipelines.
• Develop data ingestion, transformation, and orchestration processes.
• Implement data quality and validation frameworks.
• Support batch and near-real-time data processing requirements.

Database Development

• Develop and Eligible to workimize complex T-SQL queries, views, procedures, and functions.
• Perform SQL performance tuning and troubleshooting.
• Implement data reconciliation and validation processes.

Data Warehousing

• Design and support enterprise data warehouse solutions.
• Work with Fact, Dimension, Star Schema, and Snowflake Schema models.
• Implement CDC and SCD strategies.

Cloud Data Platforms

• Develop and support cloud-native data integration solutions.
• Participate in migration of on-premises data workloads to cloud environments.
• Support CI/CD implementation for data pipelines.

Required Skills

Core Technologies

• SQL Server
• T-SQL
• SSIS Package Development
• SSIS Package Analysis and Migration
• ETL/ELT Design
• Data Migration
• SQL Performance Tuning

Data Warehousing

• Dimensional Modeling
• Star Schema
• Snowflake Schema
• Fact and Dimension Modeling
• CDC
• SCD

Cloud & Modern Data Engineering

Experience in one or more:

• Azure Data Factory (ADF)
• Azure Synapse Analytics
• Microsoft Fabric
• Azure Data Lake Storage (ADLS)
• Databricks
• Apache Spark / PySpark

Reporting & Analytics

• SSRS
• Power BI

Programming & Scripting

• Python
• PowerShell
• C#
• .NET

DevOps

• Azure DevOps
• Git
• CI/CD Pipelines

Preferred Experience

• 5+ years of experience in ETL/Data Engineering.

• 3+ years of SSIS development experience.

• Hands-on experience migrating SSIS workloads to:

• Azure Data Factory

• Microsoft Fabric

• Databricks

• Synapse Analytics

• Experience with data validation and reconciliation during migration projects.

• Ability to estimate migration effort and identify dependencies.

Disclaimer: Diverse Lynx LLC is an Equal Opportunity Employer. All applicants and employees are evaluated without discrimination, based solely on their qualifications, ability, competence and performance. This email and its attachments may contain confidential or proprietary information and is intended only for the recipient(s). If you received this message in error, please disregard it and notify the sender. If you no longer wish to receive our communications, you may unsubscribe at any time.

Security Notice: Our official website is www.diverselynx.com We do not operate or authorize any other websites representing Diverse Lynx LLC.