Senior SQL Developer

Life in Pittsburgh; Monroeville (Allegheny County); Hybrid; USD 110,000 - 140,000; Full time

Job summary

Pittsburgh Tomorrow is seeking a Senior SQL Developer in Monroeville, PA, for designing, developing, and optimizing SQL Server databases, ETL processes, and reporting solutions.

Responsibilities include advanced SQL development, performance tuning, backups and security, plus ETL using SSIS and reporting via SSRS/Power BI. Strong Power BI and Microsoft Fabric familiarity are preferred.

Qualifications

• 7 years of SQL Server experience.
• 4 years of SSIS and SSRS experience.
• Power BI familiarity or experience strongly preferred.

Responsibilities

• Design, develop, and optimize SQL Server databases.
• Create complex SQL queries, stored procedures, functions, triggers, views.
• Manage performance tuning, backups, recovery, and troubleshooting.
• Maintain schemas, tables, indexes, data integrity, and security.
• Identify performance issues and implement database optimization solutions.
• Develop and maintain ETL processes using SSIS.
• Support data integration, transformation, and automation.
• Develop SSRS reports and Power BI dashboards.
• Utilize Microsoft Fabric for data management and analytics as needed.
• Ensure reporting accuracy, usability, and data visualization best practices.
• Document database structures, ETL processes, reporting logic, and procedures.
• Maintain technical standards and best practices.
• Improve data quality, reporting accuracy, and operational efficiency.
• Stay updated on SQL Server, SSIS, SSRS, Power BI, and Microsoft Fabric technologies

Skills

SQL Server

ETL

Reporting

Performance tuning

Tools

SSIS

SSRS

Power BI

Microsoft Fabric

Job description

Hybrid - 3 days onsite

Senior SQL Developer

Monroeville, PA

The Sr. SQL Developer will design, develop, maintain, and optimize SQL Server databases, ETL processes, and reporting solutions.

• Strong SQL queries, stored procedures, ETL, and reporting skills
• Develop complex SQL queries, stored procedures, functions, triggers, and views.
• Manage SQL Server databases, performance tuning, backups, recovery, and troubleshooting.
• Maintain database schemas, tables, indexes, data integrity, and security.
• Identify performance issues and implement database optimization solutions.

ETL, Data Integration & Reporting

• Develop and maintain ETL processes using SSIS.
• Support data integration, transformation, and automation.
• Develop and maintain SSRS reports and Power BI dashboards.
• Utilize Microsoft Fabric for data management and analytics as needed.
• Ensure reporting accuracy, usability, and data visualization best practices.
• Document database structures, ETL processes, reporting logic, and procedures.
• Maintain technical standards and best practices.
• Improve data quality, reporting accuracy, and operational efficiency.
• Stay updated on SQL Server, SSIS, SSRS, Power BI, and Microsoft Fabric technologies
• 7 years of SQL Server experience.
• 4 years of SSIS and SSRS experience.
• Power BI familiarity or experience strongly preferred.