Lead ETL Developer with SSIS

Hybrid in Pittsburgh, PA, US • Posted 5 hours ago • Updated 1 hour ago
Contract W2
Contract Corp To Corp
Contract Independent
12 Months
No Travel Required
Able to Sponsor
On-site
Depends on Experience
Fitment

Dice Job Match Score™

🤯 Applying directly to the forehead...

Job Details

Skills

  • SQL
  • Mapping
  • Microsoft SSIS
  • Performance Tuning
  • Recovery
  • Data Quality
  • Data Governance
  • Data Engineering
  • Reporting
  • IT Management
  • Collaboration
  • Release Management
  • Extract, Transform, Load
  • Data Integration
  • Data Migration
  • Scalability

Summary

Title: Lead ETL Developer with SSIS

Duration: 1 + year

Location: Pittsburgh/Hermitage PA (Onsite 5 days)

 

Job Summary:

Client is looking for an experienced Lead ETL Developer with 14 + years of experience in designing, developing, and managing enterprise data solutions. The ideal candidate will have strong expertise in SQL and SSIS, along with deep experience in data integration, ETL development, database design, performance tuning, and leading data engineering initiatives. This role requires both hands-on technical capability and the ability to guide teams, define best practices, and support business-critical data platforms.

 

Key Responsibilities

  • Design, develop, and maintain scalable data pipelines and ETL workflows using SSIS.
  • Build, optimize, and manage complex SQL queries, stored procedures, functions, and database objects.
  • Lead data engineering projects involving data migration, integration, transformation, and consolidation.
  • Architect and maintain robust data solutions for enterprise reporting, analytics, and operational systems.
  • Collaborate with business analysts, data analysts, developers, and stakeholders to understand data requirements and deliver effective solutions.
  • Monitor and improve database and ETL job performance, reliability, and scalability.
  • Ensure data quality, consistency, and integrity across multiple source systems and target platforms.
  • Troubleshoot production issues and provide root cause analysis for ETL and database-related problems.
  • Create and maintain technical documentation including data flow diagrams, mapping documents, and process definitions.
  • Implement best practices for data governance, security, backup, recovery, and compliance.
  • Mentor junior and mid-level data engineers and provide technical leadership to the team.
  • Participate in solution design, code reviews, release planning, and deployment activities
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 10111282
  • Position Id: 9009298
  • Posted 5 hours ago
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Pittsburgh, Pennsylvania

Today

Easy Apply

Third Party, Contract

70 - 75

Pittsburgh, Pennsylvania

Today

Easy Apply

Contract, Third Party

Depends on Experience

Remote

10d ago

Easy Apply

Contract

Depends on Experience

Remote

10d ago

Easy Apply

Contract

Depends on Experience

Search all similar jobs