Software Engineer II

Job description

As a leader in advancing New York’s energy transition, the New York State Energy Research and Development Authority (NYSERDA) has remained a credible, objective and trusted partner in our State’s energy planning as well as deploying new and innovative technologies to expand New York’s economy.

NYSERDA has worked for the past 50 years to protect the environment and help New Yorkers increase energy efficiency, lower energy costs and reduce reliance on fossil fuels.

NYSERDA engages with stakeholders including residents, business owners, developers, community leaders, local government officials, universities, utilities, investors, entrepreneurs, and more, to develop, invest, and foster conditions that:

+ Attract the private sector capital investment needed to expand New York’s clean energy economy.



+ Overcome barriers to using clean energy at a large-scale in New York.



+ Enable New York’s communities and residents to benefit equitably in the clean energy transition.



Job Overview
NYSERDA’s IT Department seeks a qualified individual for the Software Engineer II position to join the highly nimble Data Solutions team.

This individual works with the Data Architect, Tableau Developers, Performance Management, and other teams across the Authority to support the Authority’s data and reporting needs.

The Software Engineer plays a critical role in providing data structures to build visualizations and satisfy reporting needs.

This position reports to the Manager of Data Solutions.



The ideal candidate needs to be comfortable working in a fast paced and constantly changing environment.

They will need to enjoy interacting with and seeking feedback from stakeholders, have a high attention to detail, and an internal drive to set and achieve personal and team goals.


Primary Responsibilities

+ Work closely with Data Architect to support and maintain the Authority’s Data Warehouse

+ Collaborate with customers, Tableau Developers, and Performance Management team to provide data structures to build visualizations and satisfy reporting needs

+ Write queries and SQL code to transform data

+ Design, develop, and implement ETL processes for loading an enterprise data warehouse and data marts

+ Create and optimize queries for front-end and back-end applications

+ Design and develop views and stored procedures in support of system and information requirements

+ Contribute to the design of dimensional modeling schemas for a data warehouse

+ Identify and recommend solutions for database performance issues and optimization

+ Work with the Data Architect to create and execute DDL scripts

+ Assist Data Architect with maintenance and security of non-production database servers

+ Assist Data Architect with automation of routine jobs and tasks

+ Recommend solutions by defining database physical structure and functional capabilities

+ Recommend and establish optimum data access techniques; support database functions by designing and coding utilities and scripts; contribute to the creation and maintenance of an enterprise data dictionary

+ Maintain a high level of service by establishing and enforcing organization standards and following established change management processes

+ Analyze systems to effectively monitor and control data integrity and availability

+ Apply data best practices to drive adoption and raise the level of data literacy throughout the organization

+ Support how data is consumed through the Authority and our stakeholders to ensure alignment with the needs of the business and compliance with regulatory, security, and data governance requirements

+ Maintain professional and technical knowledge by attending educational workshops; reviewing professional publications; establishing personal networks; benchmarking state-of-the-art practices; participating in professional societies

+ Create templates and manuals in support of tools and systems deployed

+ Demonstrate respect, equity and inclusive behavior and practices of a diverse workforce and community

+ Foster and contribute to a culture of excellence grounded in listening, learning, problem solving, and teamwork

+ Assist in the improvement and integration of automation and tools designed to support work and decision making

+ Effectively communicate, collaborate, and problem-solve with relevant stakeholders

+ Understand and adhere to NYSERDA’s policies and procedures.

+ Manage interns and contracted staff as needed

+ Perform all job responsibilities with respect, fairness, consistency, and inclusion.

+ Perform other responsibilities as assigned

Minimum Qualifications

+ A bachelor’s degree in computer science, mathematics, information science, cognitive science, data science, business analytics, policy, engineering, statistics, or other field with 5 years of relevant IT experience.



+ A strong technical knowledge of Microsoft SQL Server (version 2019 or newer preferred)

+ Significant ETL experience with SQL Server Integration Services (SSIS) and/or Azure Data Factory (ADF)

+ Strong scripting abilities utilizing various programming/scripting languages (T-SQL, Powershell, C#, etc.)

+ Strong ability to work in a team dedicated to creating systems that are user-friendly, enable easy self-service, and are scalable and flexible to support emerging strategic needs of NYSERDA

+ A strong customer orientation

+ Experience leveraging data to develop strategy for systems and platforms needed to meet current and future needs, including data and analytic needs, across multiple functions and lines of business within complex business or government operating environments.

+ A demonstrated record in managing multiple diverse and complex activities simultaneously, delivering on commitments, and operating with speed, accuracy, and strong judgment.



+ An ability to quickly identify and drive to the best possible solution when presented with a series of opportunities and constraints.



+ An ability to drive big picture goals while maintaining a strong attention to detail.



+ Consistently maintain composure and professionalism.



+ Great resourcefulness and an instinct for surfacing value and pragmatic solutions

+ A strong technical knowledge of a variety of common data sources including Microsoft Excel and SharePoint

Preferred Qualifications:

+ A bachelor’s degree in computer science, mathematics, information science, cognitive science, data science, business analytics, policy, engineering, statistics, or other field with 7 years of relevant IT experience.



+ Experience with SAS

+ Experience with software development in Python

+ Experience with New York State ITS policies and procedures

+ Experience with Jira, Confluence or Tableau

+ Familiarity with Cyber Security

+ Relevant certifications, such as technical certifications in Microsoft SQL Server or other DBMS system

+ Experience with data warehousing and star schema topologies

+ Awareness of the business intelligence landscape

Please submit two files, one for your cover letter and another for a resume.
Please note that during the application process, you may be prompted to opt-in to Artificial Intelligence (“AI”) scoring.

This is an automatic request in the ADP system but is not a feature that is used by NYSERDA in its recruiting and hiring process.

Your response will have no impact on your application to NYSERDA.

For further information on our hiring policies, employment opportunities for people with disabilities and EEO please click on this link and scroll down to the Policies (https://www.nyserda.ny.gov/About/Careers-at-NYSERDA/Jobs-at-NYSERDA-and-NY-Green-Bank) section.
[INDTECH]

Required Skill Profession

Other General