Lead Data & SQL Analytics - Dashboards & Reporting

iberdrola; City of Rochester (NY); On-site; USD 106,000 - 133,000; Full time

Job summary

NY STATE ELECTRIC & GAS CORP in Rochester, NY, seeks a Lead Analyst - Database Support to analyze, process, and visualize financial and operational data. You will develop and maintain SQL databases, data-processing apps, reporting tools, and dashboards in collaboration with IT, vendors, and business users.

The role emphasizes data accuracy, reliability, and timely reporting to support business decisions. Office-based, requires cross-team coordination and strong data skills.

Qualifications

• Bachelor's degree in computer science, engineering, mathematics, data analytics, finance, business analytics, or a related field with at least seven years of experience.
• Proficiency analyzing large volumes of data from various sources and platforms.
• Understanding of SQL programming and database fundamentals, including multidimensional and relational design.
• Ability to create applications from scratch and maintain existing applications using Microsoft .NET.
• Proficiency with Microsoft Excel and Office applications.

Responsibilities

• Develop and document SQL databases, data models, data structures, code, queries, automated processes, dashboards, and reporting logic to support financial, operational, and reporting needs.
• Design, build, test, deploy, and support database solutions, automated data processes, dashboards, and reporting platforms.
• Monitor database and application performance to ensure uptime, data availability, and timely reporting.
• Maintain dashboards and data visualization tools to translate outputs into actionable insights for leadership.
• Ensure dashboards and reporting align with business rules and data sources.
• Coordinate with stakeholders to gather requirements and validate data sources for reporting needs.

Skills

SQL

Data analysis

.NET

Excel

Power BI

Education

Bachelor's degree in CS/Engineering/Data Analytics/Finance

Tools

SQL Server

Microsoft .NET Framework

Job description

NY STATE ELECTRIC & GAS CORP in Rochester, NY, seeks a Lead Analyst - Database Support to analyze, process, and visualize financial and operational data. You will develop and maintain SQL databases, data-processing apps, reporting tools, and dashboards in collaboration with IT, vendors, and business users.

The role emphasizes data accuracy, reliability, and timely reporting to support business decisions. Office-based, requires cross-team coordination and strong data skills.