NRG Careers

SQL Analyst

Date Posted: Sep 7, 2019

Location: Huntersville, NC, US

Company: NRG

Job Description

NRG is the leading integrated power company in the U.S., built on the strength of our diverse competitive electric generation portfolio and leading retail electricity platform. A Fortune 500 company, NRG creates value through best-in-class operations, reliable and efficient electric generation, and a retail platform serving residential and commercial businesses. Working with electricity customers large and small, we implement sustainable solutions for producing and managing energy, developing smarter energy choices and delivering exceptional service as our retail electricity providers serve almost three million residential and commercial customers throughout the country.

More information is available at www.nrg.com. Connect with NRG Energy on Facebook and follow us on Twitter @nrgenergy.

 

Summary:

 

The Production Support Analyst is responsible for designing, developing, maintaining, enhancing and supporting application programs and processes.  This position interfaces with clients to determine requirements, resolve issues, and determine cost estimates.  The position will provide subject matter expertise to the business client in order to assist with problem solving and will serve as a resource for training and development.

 

Essential Duties & Responsibilities:

 

  • Design, develop, maintain, enhance and support application programs working within a team-oriented environment using various development toolsets.
  • Provide production support and monitoring of systems supporting business clients, occasionally after normal work hours.
  • Support SOX controls, testing and audits.
  • Facilitate requirements gathering efforts and clearly document system requirements.
  • Develop prototypes/proofs of concept to validate key project assumptions prior to making significant investments.
  • Document design specifications.
  • Develop new and enhanced system functionality including custom code and packaged application configuration.
  • Ensure the successful transition from development to operations including operations procedures and tools such as process control points, reports, and automated monitoring.
  • Regularly report status and raise issues/risks as appropriate. Anticipate and adjust for problems and roadblocks while eliminating roadblocks within control.
  • Collaborate with team members and operational groups to identify and prioritize/reprioritize work when necessary.
  • Develop strong working relationships with individuals at all levels of company, operations, and IT applications and infrastructure teams.
  • Willingness to work hours as necessary, especially during critical issue resolution and milestone time periods.
  • Interact with external entities: vendors, service providers and product vendors.
  • Interface with IT application owners and the IT organization in order to provide technical solutions to meet user needs. Escalates or resolves conflicts, as needed.
  • Help identify and recommend options, risks and alternatives to deliver a robust and stable infrastructure.
  • Devise or modify procedures to solve problems considering computer equipment capacity and limitations, operating time, form of desired results, and integration of components.
  • Assist in researching, evaluating, specifying and coding the configuration of hardware and/or software for application’s environment.
  • Requires skill and proficiency in many technical functions and ability to integrate across disciplines.
  • Remain abreast of current technologies and best practices that may be applicable to the company.

 

Minimum Requirements:

 

  • Bachelor’s degree in computer science, software engineering or relevant business discipline from an accredited four-year college or university or equivalent work experience.
  • 2+ years of experience with one or more of the following:
    • SQL / PLSQL
    • SSIS/SSRS
    • Java, XML, XSL, HTML
    • Control-M
    • Transmission Protocols (FTP, SSH, SFTP, FTPS)
    • Proven understanding of Windows operating systems   

 

Preferred Requirements:

  • 2+ years of experience designing, developing, testing, and implementing ETL solutions using enterprise ETL tools.
  • 2+ years of experience developing and implementing data integration solutions in a SQL Server database environment.  
  • Experience with SSIS.
  • Experience with Netezza, DB2, and an Oracle 11g/12g.
  • One year of experience working with high volume data exchange and transaction processing systems, preferably in a custom software development environment.  
  • Experience writing C# and VB.net code is a plus.
  • Experience with energy business and systems that support retail energy.


Additional Knowledge, Skills, and Abilities:

  • Demonstrated proficiency of SQL development skills.  
  • Proficiency estimating work assignments and delivering to these estimates.  
  • Previous hands-on experience with design and development best practices.
  • Understanding of SDLC and Agile Methodologies.
  • Understanding of ETL best practices.
  • Ability to perform application configuration and testing.
  • Knowledge of working with dashboards and reports in SSRS.
  • Ability to create and maintain technical documentation.
  • Experience working with end users, taking their business problems and translating them into system requirements.
  • Configuration, testing, maintenance, enhancements and or support activities.
  • Ability to perform ad hoc analysis, insight generation, and data migrations.
  • Capable of evaluating user change requests and obtaining approval to make modifications.
  • Participation in project planning sessions with team members to analyze business and technical requirements.
  • Ability to conduct unit testing to ensure application meets specifications.
  • Willingness to work extended hours as necessary, especially during critical issue resolution and to achieve project milestones.
  • Knowledge of Software Configuration Management discipline and systems change management processes.
  • Excellent verbal and written communication skills to provide appropriate cross functional support and interaction.
  • Excellent troubleshooting and problem resolution skills.
  • Ability to work well under pressure, remaining focused and calm in the face of distractions, changing priorities in a fast-paced environment.
  • Ability to productively use XOOM’s toolset – MS Office Applications, MS Outlook, MS Project, Visio, Internet Explorer.
  • Understanding of Relational Database concepts is a must.
  • Flexibility, dedication, and team-spirit is a must.
  • Strong organizational skills.
  • Strong analytical and problem-solving skills.

 

Physical Requirements:

  • Must be willing to travel when needed.

Working Conditions:

  • On-call rotation and 24-hour on-call support will require some nights and weekends.
  • Professional office environment. 

 

 

 

#SF-IND

#LI-KW


NRG Energy is committed to a drug and alcohol free workplace.  To the extent permitted by law and any applicable collective bargaining agreement, employees are subject to periodic random drug testing, and post-accident and reasonable suspicion drug and alcohol testing. EOE AA M/F/Protected Veteran Status/Disability
EEO is the Law Poster (The poster can be found at http://www.eeoc.gov/employers/upload/poster_screen_reader_optimized.pdf)

Level, Title and/or Salary may be adjusted based on the applicant's experience or skills.

Official description on file with Human Resources


Nearest Major Market: Charlotte
Nearest Secondary Market: Concord