SQL Server / Power BI Reporting Lead

Overview

Remote
Depends on Experience
Contract - W2
Contract - 24 Month(s)
No Travel Required

Skills

ELT
Extract
Transform
Load
Microsoft Power BI
Microsoft SQL Server Management Studio (SSMS)
Microsoft SSRS
Transact-SQL
Stored Procedures
Reporting
SQL
Snow Flake Schema
Database
Data Visualization
Microsoft SQL Server
Performance Tuning
Dashboard
Data Modeling
Data Quality

Job Details

Title: SQL Server / Power BI Reporting Lead

Location: Remote

Client: NYC DOE
We are seeking a highly skilled Reporting Data Lead with strong technical expertise in SQL Server to manage and enhance our enterprise reporting infrastructure. This role will be responsible for leading the design, development, and delivery of data-driven reports and dashboards, ensuring high data quality and accuracy across multiple business units.
As the Reporting Data Lead, you will collaborate with cross-functional teams to translate business requirements into effective data solutions, lead reporting initiatives, and drive continuous improvement in data processes and reporting tools.
Key Responsibilities:
Lead the development, maintenance, and optimization of complex SQL Server databases, stored procedures, views, and functions to support business reporting.
Ensure high data quality, performance tuning, and integrity across multiple systems and platforms.
Translate business requirements into efficient SQL queries and data models.
Best practices for reporting.
Support ETL/ELT processes and assist with troubleshooting data pipeline issues.
SQL and data visualization practices.
Drive continuous improvement in reporting frameworks and suggest new data technologies.
Skills:
10+ years of experience in data reporting and analytics, including at least 3 years as a lead or senior role.
Deep technical expertise in SQL Server (T-SQL, SSMS, indexing, performance tuning).
Proficient in Power BI, SSRS, or other enterprise reporting platforms.
Data modeling concepts (star/snowflake schemas).

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.

About Prutech Solutions