Lead ETL/SSIS Engineer

Pittsburgh, PA, US • Posted 4 hours ago • Updated 4 hours ago
Contract Corp To Corp
Contract Independent
Contract W2
On-site
Depends on Experience
Fitment

Dice Job Match Score™

🧠 Analyzing your skills...

Job Details

Skills

  • ETL/SSIS
  • SQL
  • performance tuning
  • data governance

Summary

Title: Lead ETL/SSIS Engineer

Duration: 1 + year

Location: Pittsburgh/Hermitage PA (Onsite 5 days)

Job Summary:

Experienced Lead Engineer with 14 + years of experience in designing, developing, and managing enterprise data solutions, 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.

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: 10101369
  • Position Id: 9009212
  • Posted 4 hours ago
Contact the job poster
Ana San

Ana San

Recruiter @ Bahwan CyberTek Inc.
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Hybrid in Pittsburgh, Pennsylvania

Today

Easy Apply

Third Party, Contract

Depends on Experience

Pittsburgh, Pennsylvania

Today

Easy Apply

Third Party, Contract

70 - 75

Pittsburgh, Pennsylvania

29d ago

Easy Apply

Full-time

Depends on Experience

Maryland

Yesterday

Third Party, Contract

Search all similar jobs