PL/SQL jobs

The New York Independent System Operator (NYISO) manages the efficient flow of electricity on more than 11,000 circuit-miles of high-voltage transmission lines, dispatching power from hundreds of generating units across the state.

The New York Independent System Operator (NYISO) applies cutting-edge technology to operating a reliable electricity system, managing competitive markets for wholesale electricity, and planning for the Empire State's energy future.  The NYISO’s Information Technology department invites applications for a full-time Senior Software Engineer.

This position will support the development and maintenance of NYISO’s enterprise analytics platform, with an emphasis on both Python and Java development. The engineer will contribute to new and enhanced reporting features, support existing Java-based automation frameworks, and lead efforts to embed quality practices throughout the development lifecycle. This includes designing automated test strategies, integrating with CI/CD pipelines, and improving the reliability, performance, and security of analytics systems.

The engineer will collaborate closely with developers, QA analysts, and business stakeholders to ensure thorough testing and validation of application changes. The role also supports long-term analytics modernization, including planning for Python-based workflows and future integration with the SAS Viya platform. This position participates in all phases of the software development lifecycle and supports a 24x7x365 on-call rotation for reporting and analytics applications.

Please note: The position will be filled at the level (i.e. Software Engineer or Senior Software Engineer) appropriate with experience and qualifications.

 

ESSENTIAL DUTIES and RESPONSIBILITIES

• Apply technical knowledge and experience in order to solve architecture and design problems.
• Drive discussion with Business Analysts and Business Partners to interpret high-level business requirements into detailed application requirements.
• Create software design specifications for functionality as defined in approved requirement specifications. Ensure that designs are consistent with applicable NYISO software development standards, product’s architectural blueprints and industry guidelines.
• Evaluate new technology and tools. Incorporate approved technology and tools to enhance the product development process.
• Present technology design and related issues to technical and non-technical audiences.
• Document product architecture plans.
• Design and develop technical testing methods to meet target scalability and performance objectives. Perform any needed tuning of applications that do not meet those requirements.
• Lead projects with assistance from Manager and have high visibility with other staff.
• Mentor and coach Associate Engineers and Engineers.
• Serve as subject matter expert across the organization for the application(s) supported.
• Provide software subject matter expertise and support for all phases of the NYISO software development lifecycle; including requirements, design, development, testing, deployment and post-production support.
• Interact with Project Managers in all phases of project lifecycle. Provide task estimates and work breakdown structures. Provide advice on feasibility and project status
• Manage resource allocations for Software Engineers on the project team and track their progress
• Perform software development activities in support of the NYISO mission and business objectives. Create and/or refactor software programs as defined in approved specifications and designs.
• Create automated unit and functional tests to ensure software changes are reasonably free from defects.
• Perform manual data and/or test scenario setup and testing as required to ensure complete test coverage.
• Provide post-production application support as required. Support responsibilities may include consultation, problem identification, data analysis and/or emergency repairs.  Resolve customer inquiries and respond to suggestions for improvement and enhancements.
• Requirements for support of mission-critical systems entails 24x7x365 coverage.
• Develop user interfaces for web-based applications, incorporating best practices and NYISO standards for usability and design. Create and review mockups with Business Partners as necessary. 
• Incorporate industry and NYISO best practices for web application security into all software design and development work. Review and address web application security issues identified by secure SDLC tooling.
• Participate in penetration-testing of NYISO-developed applications. Review results with Managers and create mitigation plans for supported applications.
• Collaborate with third-party vendors to support and troubleshoot issues identified in their applications. Update internal documentation as necessary based on product changes.  Review impacts to NYISO processes with Supervisor and Business Partners and support deployment of updated applications.
• Responsible to ensure that project team follows guidelines for source code management, collaborate with Release and Control team during code deployments.
• Take ownership of application code, lead code reviews and suggest changes that will increase performance, security, maintainability or standards compliance.
• Design, create and/or update database tables needed by applications.
• Design, create and/or update SQL and/or PL/SQL statements used by applications.
• Instrument and tune of existing database tables and queries.
• Collaborate with other Software Engineering and IT teams as needed and Project Managers to manage changes to supported applications. Partner with other IT teams to resolve configuration, deployment, or environmental issues.
• Perform data profiling to ensure that application performance targets and database capacity needs will be able to be met in the future.
• Partner with Manager in strategic planning for supported applications. Create and update roadmap documentation including plans for technology upgrades and usability enhancements.
• Participate in continuous learning to improve technical skills as required.

 

 

EDUCATION

Bachelor’s degree in Computer Science, Information Systems, or a related field is preferred. Equivalent professional experience will be considered in lieu of a degree.

Experience (Required):

• 3+ years of Python development experience (scripting, automation, or data transformation)
• 5+ years of Java development experience (including Spring or Spring Boot)
• 3–5 years building and maintaining automated test frameworks (unit, integration, regression)
• 3+ years of experience with CI/CD tools such as Jenkins, Maven, or Gradle
• 3+ years of experience with Git for source control
• 3+ years of experience with SQL and relational databases (Oracle, PostgreSQL)
• 2+ years working in Agile or iterative SDLC environments
• Strong troubleshooting, debugging, and code review skills
• Willingness to participate in a 24x7x365 on-call support rotation

Experience (Preferred):

• Familiarity with SAS, SAS Viya, or SWAT (Python API for SAS)
• Experience with Docker and Docker Compose for test environments or deployment
• 1–3 years of experience with React or front-end testing (e.g., Cypress, Jest)
• Experience with dimensional data models and analytics/reporting validation
• Familiarity with Flyway, Testcontainers, or Nx for modern DevOps practices
• Experience with Argo or Kubernetes-native CI/CD workflows
• Exposure to Control-M or other job schedulers
• Experience in the energy/utilities sector or regulated industry environments

 

CERTIFICATES, LICENSES, REGISTRATIONS

• Python certification (e.g., PCAP – Certified Associate in Python Programming) desired
• SANS Security Awareness training or equivalent desired
• GIAC Secure Software Programmer – Java certification desired

 

ADDITIONAL REQUIREMENTS

• Ability to read, analyze and interpret common scientific and technical journals, financial reports and legal documents.  Ability to respond to common inquiries or complaints from market participants, regulatory agencies or members of the business community.  Ability to write clear technical documentation that conforms to prescribed style and format.  Ability to effectively present information to top management, public groups and/or boards of directors.
• Ability to comprehend and apply principles of advanced calculus, modern algebra and advanced statistical theory.  Ability to work with concepts such as limits, rings, quadratic and differential equations and proofs of theorems.
• Ability to apply principles of logical or scientific thinking to a wide range of intellectual and practical problems.  Ability to deal with nonverbal symbolism (formulas, scientific equations, graphs, etc.) in its most difficult phases.  Ability to deal with a variety of abstract and concrete variables.
• Intermediate competency in Windows operating environment using MS Office applications, e-mail and Internet programs. 

 

PHYSICAL DEMANDS

While performing the duties of this job, the employee is regularly required to talk or hear.  The employee frequently is required to stand, walk, sit and use hands to perform routine office tasks.  The employee is occasionally required to reach with hands and arms.  The employee must occasionally lift and/or move up to 15 pounds. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

 

WORK ENVIRONMENT

The noise level in the work environment is usually moderate.  Contact with staff and public will occur.  Travel may be required to attend and/or conduct meetings, conferences and training.­­­­­­­­­­­­ This position may require work on nights, weekends or holidays. 

 

At the NYISO, we realize the importance of balancing the availability of remote work with the inherent value of bringing people together to attain success in the areas of maximum collaboration, relationship building and growth, teamwork, innovation and problem solving, as well as professional development and mentoring. In this role, you will be required to work onsite from our Rensselaer, NY location several days per workweek, with the option to work remotely on the remaining days. You will also be expected to respond to all business needs that may require any increase to the regular onsite requirements.

The NYISO takes pride in recruiting, developing and retaining highly talented individuals. In addition to competitive salaries, we offer a comprehensive benefits package and innovative reward programs.

All offers of employment will be made contingent upon the successful completion of a drug screening and background check.

 The NYISO is an Equal Opportunity Employer and as such, does not discriminate in its hiring or employment practices.

#LI-Hybrid

Salary Range

$102,600 - $171,200 USD