Programmer Analyst - Epic

Rochester General Hospital (RGH), a 528-bed tertiary-care facility and the flagship of Rochester General Health System, is served by more than 1,500 medical and dental staff members and more than 7,000 employees. Strong referral relationships with several regional hospitals, as well as relationships and affiliations with nationally renowned institutions including Cleveland Clinic and Roswell Park Cancer Institute, amplify the ability of RGH to provide superior clinical care to the men and women.

Design, test, and deploy reports from various systems using SQL Server Reporting Services (SSRS). Responsible for database administration, data analysis, and reporting from Microsoft, Oracle, or other proprietary databases. Provides support to customers by determining report requirements, efficiently collecting data, and analyzing results. Collaborates with various teams such as IT, clinical, financial, and management to build and validate report data. Experience with SQL Server, Oracle, Database Design, SSRS, SSIS, and SQL Best Practices preferred. Develop, test, and implement HL7 and other interfaces between clinical systems using an interface engine and/or SSIS. Provides support to customers by determining interface requirements, workflow and trigger analysis, and ongoing support. Collaborates with various teams such as IT, clinical, financial, and management to build and validate interface data and functionality. Experience with HL7, VB, C#, TCP/IP, Web Services, and Interface Engines preferred.

Document processes and activities appropriately to maintain highly reliable IT systems. Provide required elements to Call Tracking, Project Management, Change Management, and Disaster Recovery Services Guides to achieve this goal. Provide support to the organization, division, and peers as a critical function of all IT professionals. Support includes day-to-day peer level support, emergent after hours support, and any support required to maintain highly reliable IT systems. Analyzes, reviews, monitors, or modifies computer systems to maintain the system functionality, increase operating efficiency, or adapt to new requirements to ensure system availability. Assesses the needs and requirements of the end-users to maximize applications functionality that complements or improves enduser workflows. Coordinates and communicates with end-users, vendors, and other staff on application design, coding, testing, implementation, and documentation to ensure proper system configuration and defined business needs. Maintains awareness of security policies and procedures to ensure appropriate physical access, system access, and data integrity. Manages and coordinates activities associated with the development and implementation of computer/information systems, including new implementations and system updates. Provides end-user support by responding to software application problems in a timely manner, reviews and works to resolve issues within target dates. Develops and/or performs unit, system, and integrated testing tasks.

- Intermediate to advanced experience with AT LEAST 2 years of experience in writing SQL queries and procedures. - Knowledge of Database Administration and Security policies. - Bachelors degree or equivalent experience required.