Lead Analyst - Database Support

NY STATE ELECTRIC & GAS CORP; Gates Center (NY); On-site; USD 106,000 - 133,000; Full time

Job summary

NY STATE ELECTRIC & GAS CORP Mobility Information seeks a Lead Analyst – Database Support to manage SQL databases, data pipelines, and dashboards for financial and operational data. You will develop data models and reporting logic, ensuring accuracy and timely insights for business decisions across NYSEG and RG&E contexts.

You will collaborate with business users, IT teams, vendors, and auditors to align data systems with operational needs, build datasets and reports, and continually improve

Qualifications

• Bachelor’s degree in a related field and 7+ years of relevant experience.
• Experience analyzing large data from various sources and platforms.
• Understanding of SQL programming and database fundamentals, including multidimensional and relational design.
• Ability to create and maintain applications using Microsoft .NET.
• Proficiency with Microsoft Office, including advanced Excel.
• Ability to learn and configure new applications.

Responsibilities

• Develop and document SQL databases, data models, data structures, code, queries, and dashboards for financial and operational needs.
• Design, deploy, and support database solutions and reporting platforms to improve efficiency and reliability.
• Monitor performance to ensure data availability and timely reporting.
• Maintain dashboards and data visualization tools translating outputs into actionable insights.
• Ensure data outputs align with business rules and reporting requirements.
• Build datasets, reports, and ad hoc analyses tailored to leadership priorities.
• Gather requirements and align data infrastructure with decision-making needs.
• Support timely processing and reporting of critical financial data.
• Coordinate with database admins, IT teams, vendors, and auditors to resolve needs.
• Evaluate new applications and visualization solutions for business value.

Skills

SQL programming

Microsoft .NET

Advanced Excel

Education

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

Tools

Power BI

Job description

Job Title: Lead Analyst – Database Support

Location: Rochester, NY (3 City Center). Elmira, NY; Ithaca, NY; Lancaster, NY; Binghamton, NY; Plattsburgh, NY; Oneonta, NY.

Work type: Office (on-site)

The salary range for this position is dependent upon experience, ranging from $106,000 to $132,500.

Job Summary

This role focuses on efficiently processing, analyzing, and visualizing financial and operational data for NYSEG and RG&E, developing and maintaining SQL databases, data‑processing applications, reporting tools, and dashboard solutions. It ensures data is accurate, reliable, accessible, and translated into clear reporting that supports timely business decisions. The position also works closely with business users, leaders, database administrators, IT teams, vendors, and other technical partners to align data systems and reporting with operational and financial needs.

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.

Required 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.

Preferred Qualifications

Experience with Power BI or similar data visualization and dashboarding tools.

Behavioral Competencies

Growth & Continuous Improvement Initiative & Change Focused on Results Customer Centric (internal and/or external) Communication Collaboration Leadership (people managers/leaders)

#LI-NB1 #LI-office

Company: NY STATE ELECTRIC & GAS CORP Mobility Information

Please note that any applicant who is not a citizen of the country of the vacancy will be subject to compliance with the applicable immigration requirements to legally work in that country.

At Avangrid we provide fair and equal employment and advancement opportunities for all employees and candidates regardless of race, color, religion, national origin, gender, sexual orientation, age, marital status, disability, protected veteran status or any other status protected by federal, state, or local law.

If you are an individual with a disability or a disabled veteran who is unable to use our online tool to search for or to apply for jobs, you may request a reasonable accommodation by contacting our People and Organization department at [e-mail].

Avangrid employees may be assigned a system emergency role and in the event of a system emergency, may be required to work outside of their regular schedule/job duties. This is applicable to employees that will work in Connecticut, Maine, Massachusetts, and New York within Avangrid Network and Corporate functions. This does not include those that will work for Avangrid Power.

Avangrid employees may also be assigned a NERC Reliability Standards compliance role supporting Critical Infrastructure Protection (CIP) and/or Operations and Planning (O&P) responsibilities. This is applicable to employees that will work in electric transmission, operations, and cyber security business areas in Connecticut, Maine, Massachusetts, and New York within Avangrid Network and Corporate business areas. NERC Reliability Standards compliance roles and responsibilities may include additional access protections, training, audit engagement, and required evidence retention, and will be communicated by the employee’s management.

Job Posting End Date: October-30-2026

We are one of the main energy companies in the world, a leader in renewables, which champions the energy transition towards a low-emissions economy. We supply energy to nearly 100 million people in dozens of countries and develops its renewable, network and commercial activities in Europe (Spain, the United Kingdom, Portugal, France, Germany, Italy and Greece), the United States, Brazil and Australia and maintains markets such as Japan and Poland, among others, as growth platforms.

Do you want to be part of the energy of the future? Do not hesitate, join us!