Programmer Analyst

Softworld - Rochester, NY

Full-time - Mid Level

Rochester, NY

Administrative and Support Services

About the position

The Programmer Analyst will serve as an embedded IT resource within the Process Development Engineering team, utilizing IT skills to support new product development and manufacturing processes. This role involves application support, data management, and collaboration with engineering teams to enhance product deployment and integration.

Responsibilities

• Provide application and configuration support, as well as develop and implement new components and functionalities.
• Liaise with the user community and other business functions to deliver efficient support services.
• Work with the Data Warehouse to enhance analytics by performing ETL from Oracle databases to SQL Server.
• Manage multiple tasks with changing priorities and propose solutions to challenges faced by the DPE staff.
• Write user requirements, functional specifications, and design specifications; develop, test, deploy, and support applications and processes.
• Collaborate with engineering and operations teams to define integration, standardization, scaling, and enhancement plans for products and services.
• Author reports based on departmental needs, including requirements capture, development, testing, and deployment.
• Assist in the ongoing deployment of the MES application in Contact Lens R&D as a technical MES lead.
• Troubleshoot PC software, OS, or hardware issues as needed.
• Support Software Quality Assurance representatives during MES validation of the change control process.

Requirements

• Degree in Computer Science, Computer Engineering, or Information Technology, or 4 years of hands-on experience with MES application development, testing, and support.
• 7+ years of experience in database development, including Oracle packages, and MES development (VB.NET or C#).
• 5+ years of experience in authoring reports (ad hoc, ASP.NET, Crystal, or SSRS).
• 5+ years of experience supporting Windows systems at the hardware and OS level.
• Proficient in SQL or Oracle database querying, table building, object creation, and stored procedures.

Nice-to-haves

• Familiarity with CFR Part 11 requirements.
• Experience with change control requirements and software development lifecycle.
• Experience with KepServerEX or any transactional management systems.
• Previous experience working with controls engineers.