SSIS Lead Developer

Job Title: SSIS Lead Developer

Location: Pittsburgh, PA (Onsite 5 Days a week)

Duration: 6+ Months

Description:

Role Overview:

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 FNB’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.