Application Solution Specialist (2 positions)

Position Title: Application Solution Specialist Location: Albany, NY Grade/Classification: 3(D1) - Para and Entry Level Professional II Salary Range: $59,343 - $76,217 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 to document business rules utilizing a structured programming development methodology. Demonstrated analytical, conceptual and problem-solving skills. Demonstrated ability to work independently and exercise sound judgment. Demonstrated organizational skills and ability to prioritize. Strong interpersonal skills. Excellent oral and written communications skills. Proficiency in PC applications such as Outlook, Excel, Access, Word, Visio, PowerPoint, and Project. Benefits information: DASNY provides financing and construction services to public and private universities, not-for-profit healthcare facilities, and other institutions which serve the public good. We offer a comprehensive benefits plan, which includes: Choice of several health insurance plans Dental & vision insurance Membership in the NYS Retirement System Deferred Compensation Investment Plan 13 vacation days per year 13 sick days per year 5 days of personal leave per year 12 paid holidays per year (plus one float day) Tuition reimbursement Training & development opportunities We offer additional benefits, which includes: Telecommuting Work Plan - Employees are required to apply and obtain approval through management to telecommute according to DASNY's Telecommuting Program Guidelines. The days designated as telecommute days must be consistent with operational needs as determined by DASNY division, department and/or unit management. Employees may only telecommute on up to four (4) workdays per pay period and shall be limited to no more than two (2) contiguous telecommute workdays. Eligibility applies after 3 months of employment. Limited Work from Home (LWFH) - additional telecommute days according to DASNY's Telecommuting Program Guidelines. Eligibility applies after 6 months of employment. DASNY is a government employer for purposes of the Public Services Loan Forgiveness Program (PSLF Program). The PSLF Program forgives the remaining balance of certain student loans after making 120 qualifying monthly payments. For more information regarding PSLF Program and whether you qualify please visit the Studentaid.gov website.