Software Engineer II

Overview

Develop, maintain, and optimize data warehouse, ETL processes, and SQL solutions.

Key Responsibilities

• sql queries
• etl development
• data warehouse
• database design
• data governance
• stakeholder collaboration

Tasks

-Analyze systems to effectively monitor and control data integrity and availability -Assist in the improvement and integration of automation and tools designed to support work and decision making -Work closely with Data Architect to support and maintain the Authority’s Data Warehouse -Write queries and SQL code to transform data -Create and optimize queries for front-end and back-end applications -Manage interns and contracted staff as needed -Foster and contribute to a culture of excellence grounded in listening, learning, problem solving, and teamwork -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 -Design and develop views and stored procedures in support of system and information requirements -Work with the Data Architect to create and execute DDL scripts -Assist Data Architect with automation of routine jobs and tasks -Effectively communicate, collaborate, and problem-solve with relevant stakeholders -Attract the private sector capital investment needed to expand New York’s clean energy economy. -Create templates and manuals in support of tools and systems deployed -Recommend solutions by defining database physical structure and functional capabilities -Apply data best practices to drive adoption and raise the level of data literacy throughout the organization -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 -Identify and recommend solutions for database performance issues and optimization -Enable New York’s communities and residents to benefit equitably in the clean energy transition. -Collaborate with customers, Tableau Developers, and Performance Management team to provide data structures to build visualizations and satisfy reporting needs -Overcome barriers to using clean energy at a large-scale in New York. -Design, develop, and implement ETL processes for loading an enterprise data warehouse and data marts -Contribute to the design of dimensional modeling schemas for a data warehouse -Assist Data Architect with maintenance and security of non-production database servers -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 a high level of service by establishing and enforcing organization standards and following established change management processes

Requirements

• python
• sql server
• ssis
• azure
• sas
• bachelors

What You Bring

-Experience with software development in Python -A strong customer orientation -Significant ETL experience with SQL Server Integration Services (SSIS) and/or Azure Data Factory (ADF) -Experience with data warehousing and star schema topologies -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. -A demonstrated record in managing multiple diverse and complex activities simultaneously, delivering on commitments, and operating with speed, accuracy, and strong judgment. -Experience with SAS -Awareness of the business intelligence landscape -An ability to quickly identify and drive to the best possible solution when presented with a series of opportunities and constraints. -A strong technical knowledge of Microsoft SQL Server (version 2019 or newer preferred) -An ability to drive big picture goals while maintaining a strong attention to detail. -A strong technical knowledge of a variety of common data sources including Microsoft Excel and SharePoint -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 -Familiarity with Cyber Security -Relevant certifications, such as technical certifications in Microsoft SQL Server or other DBMS system -Experience with New York State ITS policies and procedures -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. -Understand and adhere to NYSERDA’s policies and procedures. -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 Jira, Confluence or Tableau -Great resourcefulness and an instinct for surfacing value and pragmatic solutions

People Also Searched For

About Nyserda

-Advancing clean energy solutions across New York State since 1975. -Funding research, technology development, and energy efficiency programs. -Collaborating with local governments, businesses, and residents for sustainable solutions. -Driving innovations in energy production, distribution, and efficiency. -Launching groundbreaking projects like offshore wind farms and energy storage solutions. -Supporting initiatives from residential solar power to large-scale wind farms. -Working to reduce carbon emissions while improving economic growth and energy reliability.

Sector Specialisms