Location: Pittsburgh, PA 15222 - Hybrid, mostly remote, must be local to Pittsburgh
Purpose:
This position is responsible for the analysis of company data and database systems in order to design, develop, and support custom reports for business units and external customers. Functions include planning, designing, coding, testing, and deploying of custom reports using Microsoft SSRS, Power BI, and other toolsets. This position also works with Data Engineers and Administrators to assist with application database support and/or escalate incidents when appropriate. • Assist Data & Analytics team with resolution of data issues across a suite of technologies as required to meet a 99% uptime SLA. • Develop, maintain, and support a large number of reports using MSSQL Reporting Services, Power BI and other toolsets. • Manage multiple reporting requests in a deadline-driven, high-pressure environment. • Analyze, evaluate and interpret data from key business systems. • Develop, model, and design data architecture solutions, integration, and access in collaboration with engineers, admins and other IT groups. • Work with business analysts and data consumers to translate business requirements into data design. • Develop process automation solutions using Microsoft Power Automate
Qualifications: • 8-10+ years of hands-on experience with reporting development, management, support, and implementation in a Microsoft SQL environment. • Education: Associates Degree in a technical discipline and/or 8+ years of industry experience OR a Bachelor's Degree in a technical discipline and 5+ years of industry experience.
High level of expertise in the following areas:
o Microsoft SSRS 2012/2016/2019 (SQL Server Reporting Services)
o Microsoft Power BI
o Microsoft Visual Studio and Report Builder
o Microsoft SQL Server (2008, 2012, 2016, 2019) administration