Apply Now

Senior SSIS/SSRS/ETL Developer

Pittsburgh, PA, US • Posted 3 hours ago • Updated 2 hours ago

Full Time

75% Travel Required

On-site

$140,000 - $160,000/yr

Fitment

Dice Job Match Score™

📋 Comparing job requirements...

Job Details

Skills

ETL
SSIS
SSRS

Summary

As an SSIS Lead Developer, you will lead the design, development, and implementation of robust ETL (Extract, Transform, Load) processes using Microsoft SQL Server Integration Services (SSIS). This role involves working with large-scale financial data, ensuring data integrity, and enabling reliable reporting and analytics for business decision-making.

Key Responsibilities:

Lead the end-to-end design, development, and deployment of SSIS packages for data integration and warehouse projects.
Collaborate with data architects, business analysts, and application teams to gather and refine ETL requirements.
Develop and maintain complex T-SQL scripts, stored procedures, and functions to support transformation logic.
Ensure strong data quality controls, error handling, and performance optimization within ETL processes.
Manage and mentor a team of SSIS developers, providing technical guidance, code reviews, and best practices.
Coordinate with the DBA and infrastructure teams to monitor performance, resolve bottlenecks, and maintain high system availability.
Implement automation and scheduling using SQL Agent or third-party tools.
Create and maintain technical documentation and data flow diagrams.
Support data migration, consolidation, and compliance initiatives as per Client’s security and regulatory standards (

Required Skills and Qualifications:

8+ years of experience with SSIS and SQL Server in a data integration or BI environment.
Expertise in data warehousing design principles, dimensional modeling, and performance tuning.
Proven ability to handle large financial datasets and maintain data confidentiality.
Strong knowledge of T-SQL, indexing, and stored procedure optimization.
Experience leading teams in Agile or Scrum environments.
Familiarity with CI/CD practices and tools such as Azure DevOps or Git.
Excellent analytical thinking, communication, and leadership abilities.

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: 91134724
Position Id: 8966735
Posted 3 hours ago

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

SSIS Lead Developer

Pittsburgh, Pennsylvania

•

Today

you will lead the design, development, and implementation of robust ETL (Extract, Transform, Load) processes using Microsoft SQL Server Integration Services (SSIS). This role involves working with large-scale financial data, ensuring data integrity, and enabling reliable reporting and analytics for business decision-making. Key Responsibilities: Lead the end-to-end design, development, and deployment of SSIS packages for data integration and warehouse projects. Collaborate with data architects,

Easy Apply

Contract, Third Party

Depends on Experience

SAS Developer

Pittsburgh, Pennsylvania

•

5d ago

Role : SAS Developer Location: Pittsburgh, PA Duration: Full-time MOI : Telephonic & Skype Primary Skills: SAS Need Candidates with a Minimum of 10 Years of Experience. This is a full-time hire by the Client. Core Technical Skills: Proficiency in Base SAS, SAS Macro, PROC SQL, data steps, and proc steps for data manipulation, creation, and analysis.Knowledgeable in SAS Hash programming.Experienced in extracting, transforming, and loading (ETL) data from diverse sources using SAS.Skilled in perfo

Easy Apply

Full-time

Depends on Experience

DBA/Data Warehouse & Pipeline Architect

Pittsburgh, Pennsylvania

•

Today

Health Sciences Research IT is seeking a DBA/Data Warehouse & Pipeline Architect to join our team serving the schools of the health sciences. The candidate will work with other team members and research groups to design pipelines for data ingestion/transformation and implement the designs and execute them. This will be for ingesting thousands of files and others single large files in various formats. They will help support a large number of different research groups on many projects. The candida

Full-time

Senior Data Engineer (Informatica & PySpark)

Hybrid in Pittsburgh, Pennsylvania

•

18d ago

Senior Data Engineer (Informatica & PySpark) Position Title: Senior Data Engineer Location: Cleveland, OH or Pittsburgh, PA (3 days onsite) Job Duties:- Experience: 8 10 years in Data Engineering and Data Analysis.Informatica Expertise: Strong hands-on experience in Informatica PowerCenter/IDQ for ETL design, development, and optimization.PySpark Development: Advanced skills in PySpark for large-scale data processing, transformation, and analytics.Hadoop Ecosystem: Solid working knowledge of Had

Full-time

$130,000 - $145,000

Search all similar jobs