Lead Analyst - Database Support

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)

#LI-CP1

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