Application Solution Specialist

Position Title:                         Application Solution Specialist (Front End Development)

Location:                                 Albany, NY

Grade/Classification:           3(D1) – Para and Entry Level Professional II    

Salary Range:                         $61,123 - $78,503

Bargaining Unit:                   CSEA 

FLSA Status:                           Non-Exempt

Last Revised: February 7, 2023

Primary Purpose

Under general supervision, the Application Solution Specialist is responsible for analyzing business requirements, building software applications, and business/systems analysis and design.

Essential Functions

• Build applications, reports, and scripts, ensuring that solutions comply with cyber security, scalability, and other applicable technical requirements.
• Adhere to established guidelines for software design and development.
• Develop test scenarios to test functionality and performance of applications, reports and scripts and test to ensure all requirements are met.
• Research, evaluate and recommend software solutions for DASNY’s business requirements.
• Participate in project planning, execution, and implementation.
• Provide operational support in production environment. Troubleshoot and fix application, report, or script defects.
• Contribute to the team as a subject-matter-expert and collaborate with co-workers to troubleshoot issues.
• Work directly with external technology vendors to troubleshoot defects and develop new applications, reports, and scripts.
• Implement, configure, and support off-the-shelf vendor solutions hosted onsite and in the cloud.
• Participate in disaster recovery execution.

 Other Duties and Responsibilities

• Perform security administration functions regarding user accounts and passwords and the associated procedures for reviewing, logging, and implementing access rights for files, databases and physical devices relating to web and database applications.
• May work with PowerShell, SQL Server Reporting Services and Power BI.
• Ensure compliance with DASNY and NYS policies.
• May train and evaluate employees.
• Assist with the documentation and implementation of procedures.
• Assist with internal controls implementation, review, and testing.
• May build Power Automate flows to automate data transfer from various Microsoft Office 365 products, including but not limited to, Microsoft Forms, SharePoint and PowerApps.
• Undertake special assignments as directed.
• Must maintain regular attendance in accordance with DASNY attendance and leave policies.
• Must adhere to the NYS Information Security Policy Standards established and issued by the Office of Cyber Security and Critical Infrastructure Coordination. (Standards can be found on the Intranet).

 Supervision

Supervision of employees may be required.

 

Physical/Mental/Visual Demands

 Occasional travel is required using public transportation, DASNY vehicle, rental vehicle, or personal vehicle.  This travel may include overnight stays at public accommodations and related establishments.  Requires complex and time-pressured decision-making.  Overtime or extended work hours may be required.

Work Environment

Standard office environment, including the use of one or more of the following:  PC, telephone, fax machine, printer, copier, scanner, electronic stapler/hole punch/date stamp, shredder.

Minimum Qualifications

 Bachelor’s degree plus one-year relevant experience; or

Associate degree plus three years relevant experience; or

High school diploma plus five years relevant experience.

Other combinations of education and experience may be considered.

 Preferred Qualifications

• Hands-on experience and/or education with application design/development/testing, PowerShell, Server Reporting Services, Power Platform, ASP.Net, VB.Net or C#, JavaScript, HTML/CSS and database development including stored procedures, functions, views and SSIS packages; and
• Bachelor’s degree in Computer Science or related field plus two or more years software development experience; or
• Associate’s degree in Computer Science or related field plus four or more years software development experience.

 Essential Skills

• Ability to thrive in a team environment.
• Demonstrated ability