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.
Competencies
Subscribe to job alerts and upload your resume!
*By registering with our site, you agree to our
Terms and Privacy Policy.