Senior SQL Developer - Optimize Databases, ETL & Power BI

Pittsburgh Tomorrow; 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

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.