DUTIES:The Lead Programmer Analyst will define, develop, test, analyze and maintain new software applications in support of the achievement of business requirements. This includes writing, coding, testing and analyzing software programs and applications. The Lead Programmer Analyst will also research, design, document and modify software specifications throughout the production life cycle. Incumbent will assist other Programmer Analysts on large and complex projects.Duties:Estimate staff and time required to complete programming assignments. Review and evaluate daily/weekly/monthly job schedules and performance. Designing, developing and modifying of in-house developed application programs both interactive and batch. Debugging problems in application programs both on and off hours. Documenting all programming code and report production procedures. Assisting/advising individual users in identifying and solving technical problems.General system problem solving. Follow up with users following and during system implementation. Providing information to users and other members of IT staff as needed for projects. Learn new programming languages and techniques. Support vendor purchased applications and provide customization where needed. Support SQL Server databases, including creating databases with tables and views. Create and maintain Web Services to transmit and receive data from SUNYDMC. Support the Budget application, including upgrades and write reports using ERP system. Serve as point of contact for Budget application. Work with .net, VB and other competency tools to develop more reporting systems.(DUTIES AND RESPONSIBILITIES ARE NOT LIMITED TO THE ABOVE POSITION DESCRIPTION)QUALIFICATIONS:REQUIRED: Bachelor's degree in M.I.S or Computer Science. 4-6 years of programming and development experience. Expertise in SQL, TSQL and Oracle knowledge is essential. Expertise in Report design and data management using industry standard tools. PREFERRED: Programming proficiency in SQL Plus, Visual Basic, ASP .net. Knowledge of Access, Excel, Project Management software and Crystal Reports is a plus. Experience with SAP, Tableau, Lawson and Allscripts EMS is a plus. In depth understanding of data warehouse, building and supporting knowledge is desirable.Additional Info: * Represents Location Pay for full-time appointees. Hours of work: 9am - 5pm. Days of week: M - F. Hours per week: 37.5Closing Date: Open Until FilledSTATE UNIVERSITY OF NEW YORK IS AN EQUAL OPPORTUNITY / AFFIRMATIVE ACTION EMPLOYER
SUNY Downstate's College of Medicine, Health Related Professions, Nursing and its School of Graduate Studies offer students a broad professional education that will prepare them for practice or careers in any location and community. This education provides exceptional opportunities for those students with a commitment to promoting health in urban communities and addressing the complex challenges o...f investigating and preventing diseases that confront clinicians, educators, and researchers in such an environment. This special aspect of Downstate's unique mission is reflected in the students it attracts and selects, the vast majority of whom are drawn from the New York City Metropolitan area. Many of these students are members of minority and cultural groups underrepresented in the health professions, and/or come from families of first-generation immigrants or from economically disadvantaged backgrounds.