SQL / ETL Developer - Albany Office (#455)

The New York State Energy Research and Development Authority [NYSERDA] seeks a qualified and highly motivated SQL / ETL Developer to join its Information Technology team. The SQL / ETL Developer will be part of a highly nimble team of professionals dedicated to deliver high quality project deliverables through thorough and thoughtful planning as well as consultation with a wide variety of users. The successful candidate will blend a strong technical acumen with exceptional communication and negotiation skill and will be an instrumental team member in ensuring intelligent and efficient usage of the database platforms.  Occasional travel within NYS may be required.

Primary Responsibilities

  • 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 Database Administrator to create and execute DDL scripts
  • Recommend solutions by defining database physical structure and functional capabilities, database security, data back-up, and recovery specifications
  • 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
  • Work with key stakeholders on a disaster recovery plan
  • Maintain a high level of service by establishing and enforcing organization standards and following established change management processes
  • Continue to improve professional and technical knowledge by attending educational workshops; reviewing professional publications; establishing personal networks; benchmarking state-of-the-art practices; participating in professional societies
  • 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
  • Perform other responsibilities as assigned

Minimum Qualifications

  • Four years of relevant experience as described above
  • A strong technical knowledge of Microsoft SQL Server (version 2012 or newer preferred)
  • Significant experience with SQL Server Integration Services
  • Strong scripting abilities utilizing various programming/scripting languages (T-SQL, VB Script, Powershell, Bat files, C#, etc.)
  • Experience developing ETL in a data warehouse environment
  • Experience with Tableau (preferred)
  • An understanding of Microsoft Windows Server 2008+, Active Directory, Windows networking (DHCP, DNS)
  • 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
  • Demonstrated commitment to ongoing learning / ability to share and facilitate knowledge within a highly dynamic team.
  • Demonstrated problem-solving ability; an entrepreneurial edge, resourcefulness, adaptability, and an instinct for surfacing value and pragmatic solutions
  • Bachelor degree in information systems or related field and 4 years relevant work experience as a SQL Server Developer; or an unrelated degree and 6 years relevant work experience as a SQL Server Developer; certificates from recognized programs that indicate mastery of tools and techniques relevant to the assignment may substitute for up to six months of experience

Salary

Candidates will be considered based on qualifications and experience. An excellent benefits package is also offered.

To Apply

Please submit a cover letter and resume to recruiter@nyserda.ny.gov. When applying, please include SQL Server Developer and Job Code 455 in the subject line.

Pursuant to Executive Order 161, no State entity, as defined by the Executive Order, is permitted to ask, or mandate, in any form, that an applicant for employment provide his or her current compensation, or any prior compensation history, until such time as the applicant is extended a conditional offer of employment with compensation. If such information has been requested from you before such time, please contact the Governor’s Office of Employee Relations at (518) 474-6988 or via email at info@goer.ny.gov.