New York State Electric & Gas

Lead Analyst - Database Support

LocationBinghamton, NY
Job Typefull_time

About This Job

Job Title: Lead Analyst - Database & Application Support In office Location: Kirkwood, NY Reports to:

Manager - Billing & Risk Management

The base salary range for this position is dependent upon experience and location, ranging from:

$103,939 - $129,924

Job Summary

The Lead Analyst - Database & Application will facilitate the efficient processing, payment and reporting of critical financial data related to NYSEG and RGE wholesale electric, natural gas, and interconnection services activities, during, but not limited to, the monthly closing process. These roles involve collaboration with various local and global departments, as directed by managers and members in the NY Energy Services and Transmission Services teams.

The position focuses on the development, maintenance, and documentation of SQL databases and Microsoft .NET applications, along with providing technical support to NY Energy Services and Transmission Services team members. It involves interaction with Avangrid IT, counterparty technical support, and software and hardware vendor support. The role includes collaborating with department employees to develop requirements documents, designing, building, and testing SQL databases or Microsoft .NET applications (or enhancements to existing ones) to meet these requirements, and then moving them into production and providing ongoing support.

Key Responsibilities

Develop and maintain department SQL databases and Microsoft .NET applications. Proactively monitor and ensure uninterrupted service for NY Energy Services and Transmission Services Departments.
Interface with Avangrid Database Administrators (DBAs) to resolve database issues related to Energy Services involving Avangrid-maintained databases.
Document and enhance new and existing code to improve efficiency and robustness.
Support the timely processing, payment and reporting of critical financial data by supporting market data availability and providing application support.
Support NY Energy Services and Transmission Services employees in resolving IT-related issues by collaborating with the employee, Avangrid IT and/or vendors.
Ensure daily market data is downloaded, validated, and integrated into appropriate database or applications.
Assist in the technical evaluation of new applications for the NY Energy Services and/or Transmission Services Departments. Understand the needs of department employees and provide database or application solutions.
Attend ISO working group meetings to understand changes to data dictionaries and file layouts. Design, test and document tasks to ensure functionality on a 24/7/365 basis.
Collaborate with internal and external auditors.


Required Qualifications

Education: Bachelor’s degree in computer science, engineering, mathematics, or a related field with a minimum of seven years of relevant experience.
Data Analysis: Proficiency in analyzing large volumes of data from various sources and platforms.
SQL and Database Fundamentals: Strong understanding of SQL programming and database fundamentals, including multidimensional and relational database design.
Application Development: The ability to create applications from scratch, maintain existing applications using Microsoft .NET.
Presentation Skills: Expertise in creating impactful presentations using Microsoft PowerPoint, with the ability to present analytics findings and recommendations to an executive-level in both oral and written form. Demonstrated creativity in designing visually appealing and compelling presentations.
Microsoft Office Experience: Proficiency with the Microsoft Office suite of applications, with advanced skills in Excel.
Adaptability: Ability to learn and configure new applications.


Preferred Qualifications

Wholesale Energy Markets: Knowledge of wholesale energy markets, experience managing large data sets, with proficiency in Excel and Microsoft VBA.
Project Management: Strong project management skills, including solid organization, flexibility, and attention to detail.
SQL Expertise: Extensive background in SQL database development and administration, including query optimization.
Data Visualization Tools: Familiarity with data visualization tools, especially Power BI.
Database Experience: Good understanding of database data retrieval, SQL, and basic database administration.
Scripting Languages: Basic proficiency and/or experience in scripting languages such as C# or Python.
SFTP Knowledge: Familiarity with Secure File Transfer Protocol (SFTP).


Skills/Abilities

Desire to Learn: Strong desire to develop technical and financial knowledge.
Attention to Detail: High attention to detail and accountability for results.
Problem-Solving: Effective problem-solving capabilities, including the ability to independently diagnose and solve issues, and knowing when to seek input and guidance.
Ad-Hoc Analytics: Ability to deliver ad-hoc analyses on short notice.
Collaboration: Ability to work on projects both collaboratively and independently.
Operational Insightfulness: Provide high-quality information to the NY Energy Services and Transmission Services teams about underlying performance drivers.
Adaptability: Demonstrated ability to work effectively in a fast-paced, dynamic environment, managing and interfacing with cross-functional internal groups of all levels and competencies.
Multi-tasking: Ability to efficiently manage multiple, concurrent, time-sensitive priorities when needed

Competencies (this is standard for all jobs)

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

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 careers@avangrid.com.

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.

Job Posting End Date

June-30-2025

Similar Jobs

company-logo

Lead Analyst - Database Support

New York State Electric & Gas
Job Typefull_time
 
Binghamton, NY
13 days ago
company-logo

Lead Data Analyst

GE Vernova
Job Typefull_time
 
Markham, ON
about 1 month ago
company-logo

Lead Analyst - SAP Support

Avangrid
Job Typefull_time
 
Portland, ME
14 days ago
company-logo

Lead Analytics Analyst

NextEra Energy
Job TypeFull-time
 
Juno Beach, FL
10 days ago
company-logo

Lead Change Management Data Analyst

CenterPoint Energy
Job TypeFull-time
 
Evansville, IN
14 days ago
company-logo

Database Analyst

ACRT, Inc.
Job TypeFull-time
Salary
$56160 - $56160
Denver, CO
12 days ago
company-logo

Database Analyst

ACRT
Job Typefull_time
 
Denver, CO
12 days ago
company-logo

Lead Financial Analyst (hybrid)

NiSource
Job Typefull_time
Salary
$93800 - $140700
Columbus, OH
20 days ago
company-logo

Enterprise Technology Lead Analyst

Florida Power & Light
Job Typefull_time
 
Juno Beach, FL
10 days ago
company-logo

Lead Master Data Specialist

CenterPoint Energy
Job TypeFull-time
 
Houston, TX
13 days ago
company-logo

Lead Analyst - CCS Business Support

Avangrid
Salary
$85900 - $107375
Binghamton, NY
14 days ago
company-logo

Lead Analyst

National Grid
Job TypeFull-time
Salary
$126000 - $148000
Syracuse, NY
5 days ago
company-logo

Lead Data Scientist (Hybrid)

Eversource Energy
Job Typefull_time
Salary
$157040 - $174490
Westwood, MA
13 days ago
company-logo

Lead Analyst, Finance Services

National Grid
Job Typefull_time
Salary
$120000 - $141000
Hicksville, NY
18 days ago
company-logo

Process & Data Analyst Lead (Tech Business Analyst Staff - Lead)

American Electric Power
Job TypeFull-time
Salary
$112869 - $146730
Columbus, OH
10 days ago
company-logo

Business Intelligence and Analytics Lead - Operations

Charter Steel
Job Typefull_time
 
Saukville, WI
17 days ago
company-logo

Lead Data Analyst, Electric Engineering

CenterPoint Energy
Job TypeFull-time
 
Evansville, IN
26 days ago
company-logo

Lead Accounting Research Analyst

CenterPoint Energy
Job Typefull_time
 
Houston, TX
about 1 month ago
company-logo

Salesforce Platform Lead – Enterprise Data Systems

Mainspring Energy
Job Typefull_time
Salary
$145000 - $170000
Menlo Park, CA
about 1 month ago
company-logo

Lead Analyst, Product Systems

The AES Corporation
Job Typefull_time
 
Louisville, CO
10 days ago

Trending Jobs

company-logo

Electrical Engineer

Dudley Staffing
Job TypeFull-time
Salary
$55 - $75
Canonsburg, PA
5 months ago
company-logo

Division Order Analyst

Coronado Resources
Job TypeFull-time
 
Dallas, TX
about 2 months ago
company-logo

Professional Landman

Penterra Services, LLC
Job TypeContract
 
Lovington, NM
24 days ago
company-logo

Accounts Payable Clerk

LPR Energy
Job TypeFull-time
Salary
$65000 - $65000
Dallas, TX
2 months ago
company-logo

Division Order Landman

R. Lacy Services, Ltd.
Job TypeFull-time
 
Longview, TX
about 1 month ago
company-logo

contract landman

HPS Oil & Gas Properties
Job TypeFull-time
 
Lafayette, LA
4 months ago
company-logo

Oil and Gas Land and Title Analyst - SAM Associate II

Bank of America
Job TypeFull-time
 
Dallas, TX
3 months ago
company-logo

Attorney

Toeppich & Associates
Job TypeFull-time
 
Houston, TX
over 1 year ago
company-logo

Title Landman

Sustain Land Services
Job TypeFull-time
 
Norman, OK
3 months ago
company-logo

Senior Landman

Greenlake Energy
Job TypeFull-time
 
Austin, TX
3 months ago
company-logo

Electrical Designer

Dudley Staffing
Job TypeFull-time
Salary
$45 - $60
Canonsburg, PA
5 months ago
company-logo

Title Reviewer

Innovation Land Services
Job TypeFull-time
 
Pittsburgh, PA
5 months ago
company-logo

Oil and Gas Title Attorney

Oliva Gibbs PLLC
Job TypeFull-time
 
Houston, TX
2 months ago
company-logo

Civil/Structural Designer

Dudley Staffing
Job TypeFull-time
Salary
$30 - $60
Canonsburg, PA
5 months ago
company-logo

Landman

Stockyards Energy Land Services
Job TypeContract
 
Akiachak, TX
6 months ago
company-logo

contract Landman

HPS Oil & Gas Properties
Job TypeFull-time
 
Midland, TX
4 months ago
company-logo

contract Landman

HPS Oil & Gas Properties
Job TypeFull-time
 
Cheyenne, WY
4 months ago
company-logo

E & I - Office/Field Administration

Surepoint Group
Job Typefull_time
 
Grande Prairie, AB
27 days ago
company-logo

Senior Division Order Analyst

Formentera
Job TypeFull-time
Salary
$110000 - $130000
Austin, TX
about 1 year ago
company-logo

Mechanical/Piping Engineer

Dudley Staffing
Job TypeFull-time
Salary
$55 - $75
Canonsburg, PA
5 months ago

Notice: The inclusion of job postings or company information on our platform does not imply endorsement, partnership, or affiliation. Listings may include publicly available roles from various sources, and companies shown may not have a direct relationship with Energy Hire.