Lead Data Analyst - SQL, Dashboards & Insights

New York State Electric & Gas; Town of Oneonta (NY); On-site; USD 106,000 - 133,000; Full time

Job summary

NY STATE ELECTRIC & GAS CORP seeks a Lead Analyst – Database Support to analyze, process, and visualize financial and operational data for NYSEG and RG&E. You will develop and maintain SQL databases, data-processing apps, reporting tools, and dashboards to enable timely business decisions.

Collaborating with business users, IT, vendors, and other technical partners, you will ensure data accuracy and alignment with reporting requirements and business rules across multiple sites in New York.

Qualifications

• Bachelor’s degree in computer science, engineering, mathematics, data analytics, finance, business analytics, or a related field and a minimum of seven (7) years of relevant experience.
• Proficiency analyzing large volumes of data from various sources and platforms.
• Understanding of SQL programming and database fundamentals, including multidimensional and relational database design.
• Ability to create applications from scratch and maintain existing applications using Microsoft .NET.
• Proficiency with Microsoft Office applications, including advanced Excel skills.
• Ability to learn and configure new applications.

Responsibilities

• Develop and document SQL databases, data models, related 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, application enhancements, automated data processes, dashboards, and reporting platforms that improve efficiency, reliability, scalability, usability, and transparency.
• Monitor database and application performance to support uninterrupted service, data availability, and timely reporting for supported business areas.
• Maintain dashboards, reporting platforms, and data visualization tools that translate database outputs into actionable insights for business users and leadership.
• Ensure dashboards, reporting tools, source data, reporting logic, and outputs are accurate, current, complete, and aligned with business rules, database structures, and reporting requirements.
• Build datasets, recurring reports, management dashboards, ad hoc analyses, and data products tailored to evolving business priorities, leadership requests, and performance management needs.
• Partner with business users and technical stakeholders to gather requirements, validate data sources, define dashboard needs, and align data infrastructure, applications, and report products with operational and financial decision-making needs.
• Support the timely processing, payment, reporting, and analysis of critical financial data through accurate source data, reporting logic, dashboard outputs, and data availability.
• Coordinate with Avangrid database administrators, IT teams, vendors, auditors, and other technical resources to resolve database, application, reporting, dashboard, extraction, documentation, and validation needs.
• Evaluate new applications, reporting platforms, and data visualization solutions by understanding department needs and recommending practical databases, application, and reporting solutions.

Skills

Data analysis

Analytical thinking

Learn new applications

Education

Bachelor’s degree in computer science, engineering, mathematics, data analytics, finance, business analytics, or related field

Tools

SQL

Microsoft .NET

Excel

Power BI

Job description

NY STATE ELECTRIC & GAS CORP seeks a Lead Analyst – Database Support to analyze, process, and visualize financial and operational data for NYSEG and RG&E. You will develop and maintain SQL databases, data-processing apps, reporting tools, and dashboards to enable timely business decisions.

Collaborating with business users, IT, vendors, and other technical partners, you will ensure data accuracy and alignment with reporting requirements and business rules across multiple sites in New York.