NYSERDA aims to support New York’s energy transition by deploying innovative technologies and expanding the clean energy economy. The Software Engineer II position is focused on addressing the technical challenges of managing and optimizing data structures to support reporting, visualization, and decision-making needs across the organization.
Requirements
- 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-Sharp, 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
- 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
- Experience with a variety of common data sources including Microsoft Excel and SharePoint
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
Other
- 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
- 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
- Understand and adhere to NYSERDA’s policies and procedures
- Perform all job responsibilities with respect, fairness, consistency, and inclusion
