Lead Analyst - Database Support
Lead Analyst - Database Support
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
$ 103939 - 129924
1 Vacancy
Job Description
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: $103939 - $129924
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: Bachelors 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 CORPMobility 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 .
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:
JuneRequired Experience:
IC
Employment Type
Full-Time
