SQL Analyst

Company: Avangrid
Location: Binghamton
Posted on: June 13, 2021

Job Description:

Responsibilities

Scope of Work - Describe main duties, settings, geography, reporting relationships, other relationships: The position ensures the timely processing, payment and reporting of critical financial data regarding both NYSEG and RGE's wholesale electric and natural gas activity during but not limited to the monthly closing process. The position focuses on providing Energy Supply and Transmission Services technical support and development of applications and databases.

With limited direction the incumbent performs database design, development and management, and the development and maintenance of Excel spreadsheets and applications. Develop and maintain daily downloads and validation of pricing and billing information from external sources. The incumbent recommends analytical methodologies, conducts analyses, verifies data and prepares reports of wholesale electric and natural gas NYSEG's and RGE's Energy Supply and Transmission Services data.

The incumbent will need proficiency in Microsoft Office with emphasis on Access and Excel. The incumbent will need to understand database design and development, processing internal and external data, and SAP, SmarTRAC, Metretek and Allegro. Knowledge of electric and natural gas markets, Allegro, accounting, finance or business administration would be desirable.

Scope of Work - Describe range of responsibilities (with % of time allocation approximately for each responsibility), customer interactions, management interactions, complexity of decision making, compliance standards etc, Risk taking extent and complexity:

MAJOR ROLES AND RESPONSIBILITIES: (% of Time)

1. With limited direction design, develop and maintain multiple SQL databases. (30%)

2. Integrate and develop validation checks on data from both internal and external sources. (20%)

3. With limited direction analyzes NYSEG & RGE wholesale data and provides analysis to Management for approval and review. (20%)

4. Prepares daily and monthly supply billing reports. (10%)

5. Provide technical support and training on applications and databases. (10%)

6. Perform verification of NYSEG & RGE's Billing & Risk Management invoices and journal entries. (10%)

Skills and Requirements

Skills/Abilities:

• Ability to design and develop databases.
• Ability to design and develop Excel spreadsheets and applications.
• Desire to perform detailed data verification efficiently and accurately.
• Proficiency in Microsoft Office, with emphasis on development in Access and Excel.
• Proficiency in SQL, Crystal Reports and Visual Basic.
• Knowledge of SAP.

#LI-ML1

#IND

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 AVANGRD Network and Corporate functions. This does not include those that will work for Avangrid Renewables

AVANGRID's employment practices and policies are geared to hiring a diverse workforce and sustaining an inclusive culture. 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. Learn more about equal employment by following this link

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 Human Resources department at 203-499-2777 or careers@avangrid.com

Keywords: Avangrid, Binghamton , SQL Analyst, Other , Binghamton, New York