Programmer/Analyst

State University Construction Fund • Albany, NY

4d

About The Position

The State University Construction Fund is seeking a Programmer/Analyst to join its Information Technology team in Albany, New York. The position is part of a dynamic, agile team responsible for designing, developing, and implementing applications that support the Fund’s functions.

The role participates in the full software development lifecycle, from gathering and defining requirements through design, development, implementation, testing, and documentation. It also involves developing complex SQL queries, contributing to functional and integration test planning, troubleshooting assigned applications and projects, and collaborating with the team to deliver coordinated business functions.

Requirements

• A bachelor's degree, preferably in information technology or business, and two years of application development experience. An associate's degree in a related field and four additional years of related experience may substitute for the bachelor's degree requirement.
• Two years of experience using Adobe ColdFusion or an equivalent object-oriented programming language to build back-end web applications.
• Experience using Microsoft SQL Server or another relational database to create and interact with data models.
• Experience using HTML, CSS, and JavaScript to build accessible, responsive web front ends.
• Experience with a CSS framework such as Foundation or Bootstrap.
• Experience using a version control system such as SVN or Git to manage code.
• Development experience using an MVC framework, preferably ColdBox.
• Experience working with an ORM tool, such as ColdFusion ORM or Hibernate, to interact with data models.
• ETL/data integration platform experience.
• Experience developing, testing, implementing, or supporting interfaces with the New York Statewide Financial System (SFS), including agency bulk-load transactions, inbound/outbound interface files, file validation, Agency Interface Profiles, reconciliation, exception handling, and end-to-end interface testing.

Responsibilities

• Participate in the full software development lifecycle, including requirements gathering and definition, design, development, implementation, unit testing, and documentation.
• Develop complex SQL queries to support assigned projects.
• Participate in functional and integration test planning for assigned projects.
• Participate in problem solving for assigned applications or projects.
• Work within a team to deliver quality and coordinated business functions.
• Perform other duties as directed.

Benefits

• Immediate participation in the NYS and Local Retirement System (NYSLRS), with vesting after five years of service.
• Health insurance, including prescription, dental, and vision coverage.
• Vacation, sick, and personal time.
• 13 paid federal holidays.
• Paid parental leave.
• Eligibility to request telecommuting a limited number of days per month after completing six months of service, subject to approval and program guidelines.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level