Systems Integrator and Applications Specialist - Tarrytown

Job Description

Job Description

ENT and Allergy Associates/Quality Medical Management Services, New York & New Jersey's premier ENT and Allergy medical practice, is seeking a self-motivated, people-friendly full time Systems Integrator and Applications Specialist for our Tarrytown Corporate office.

Summary

The Systems Integrator and Applications Specialist will require advanced technical skills spanning system architecture, application development, healthcare-specific integrations, and database management. This role is integral to project development and success, encompassing hands-on coding, interface configuration, performance tuning, and cross-functional collaboration. The ideal candidate will ensure seamless integration of EPM/EHR systems, maintain data flow and security, and support end-user workflows through custom tools and background processes.

Essential Responsibilities

1. System Integration & Architecture

• Design and Implementation: Architect and implement system solutions for healthcare EPM/EHR environments, ensuring components such as Mirth Connect, HL7 interfaces, Rosetta, and SolarWinds Database Performance Analyzer (DPA) are seamlessly integrated and adhere to data-exchange standards.
• Interoperability: Facilitate interoperability between disparate systems by enforcing HL7 compliance and industry best practices; manage data transformation and routing logic.
• Data Flow Management: Oversee end-to-end data exchange between applications, middleware, and databases. Implement efficient, secure transfer mechanisms-particularly leveraging Mirth for message integration-and troubleshoot data routing or latency issues.

1. Database Management

• Design & Optimization: Develop, maintain, and optimize database schemas to support performance and scalability. Utilize SolarWinds DPA to monitor query performance, identify bottlenecks, and implement indexing or architectural improvements.
• Data Security: Enforce robust security controls to protect patient PHI. Regularly review and update access permissions, encryption protocols, and audit logs.
• Backup & Recovery: Establish and maintain comprehensive backup/recovery procedures for production and non-production databases. Conduct periodic restore testing and document recovery processes.

1. Application Development & Support

• Healthcare System Expertise: Lead development, upgrades, conversions, and interface projects for NextGen (preferred), Epic, Centricity, Allscripts, or similar EHR/PM platforms. Manage background process scheduling, error monitoring, and testing to ensure minimal downtime.
• Coding & Reporting: Write T-SQL stored procedures, functions, and views for custom reporting. Leverage SQL Server Reporting Services (SSRS) to create operational reports and dashboards, as well as using SQL Server Integration Services (SSIS) for ETL operations for different scenarios.
• Interface Configuration: Configure and maintain Mirth Connect channels-build transformation mappings, troubleshoot routing errors, and optimize message throughput. Implement and validate HL7 interfaces for lab systems, billing, and clinical workflows. Configure Rosetta integration platform to facilitate data exchange with external vendors.

1. Monitoring, Maintenance & Troubleshooting

• Proactive Monitoring: Use SolarWinds DPA and application-level monitoring tools to identify trends or anomalies. Analyze performance metrics and collaborate with stakeholders to remediate identified issues.
• Planned & Unplanned Maintenance: Perform off-hours and weekend maintenance windows for system upgrades, patches, and unplanned triage. Maintain and update runbooks for standard operating procedures and incident response.
• Issue Resolution: Anticipate potential system conflicts and act proactively-debug application code, database queries, or interface logic. Apply root-cause analysis techniques to recurring errors and implement long-term fixes.

1. Collaboration & Documentation

• Cross-Functional Collaboration: Work closely with software developers, network/IT administrators, QA testers, and clinical stakeholders to gather requirements, validate solutions, and refine workflows.
• Documentation: Create and maintain comprehensive technical documentation including system configurations, integration mappings, database schemas, and user guides. Develop training materials and conduct knowledge-transfer sessions for IT staff and end users.
• Continuous Improvement: Stay current on emerging technologies, industry trends, and regulatory changes (e.g., HL7 standards, HIPAA security updates). Propose and implement enhancements to streamline processes, improve reliability, and reduce total cost of ownership.

Position Requirements -Technical Knowledge & Experience

Healthcare Applications:

• Demonstrated experience with NextGen EHR/PM (preferred); exposure to Epic, Centricity, or Allscripts is a plus.
• Hands-on knowledge of Mirth Connect configuration and HL7 message structures.

Database Expertise:

• Strong proficiency with Microsoft SQL Server (2012+), T-SQL, and database design best practices.
• Experience using SolarWinds Database Performance Analyzer (DPA) for monitoring and tuning.
• Familiarity with backup/recovery processes (e.g., log shipping, differential/full backups) and disaster-recovery testing.

Programming & Reporting:

• Proficiency in VB.Net, C#, and JavaScript for application development and interface scripting.
• Experience building SSRS reports, designing stored procedures, and optimizing SQL queries.

Integration Platforms:

• Configuration and troubleshooting of Rosetta integration platform.
• Understanding of data-exchange protocols (TCP/IP, XDR, FTP) and message routing.

Operating Systems & Tools:

• Solid working knowledge of Microsoft Windows Server (2012 R2, 2016, 2019) and desktop OS (Windows 10/11).
• Familiarity with system monitoring tools (e.g., SolarWinds Orion suite, Nagios) and version control (Git, TFS).
• Experience with scripting for automation (PowerShell, Batch).

Other Skills:

• Knowledge of HL7 standards (v2.x, v3) and FHIR concepts is highly desirable.
• Experience with background process management and scheduling (SQL Agent, Windows Task Scheduler).
• Understanding of basic networking concepts: IP routing, VLANs, firewall rules (SonicWall, Meraki, etc.).

Soft Skills & Interpersonal

• Exceptional troubleshooting and analytical problem-solving abilities; able to prioritize competing demands in a high-pressure environment.
• Outstanding written and verbal communication skills; capable of translating technical concepts into user-friendly language for stakeholders.
• Strong interpersonal skills with a focus on active listening, rapport-building, and collaborative teamwork.
• Detail-oriented mindset and commitment to documentation accuracy.
• Proven ability to work independently, take ownership of projects, and meet deadlines.
• Customer service orientation, with a commitment to supporting end users and driving continuous improvement.

Personal Attributes

• Self-Motivated & Adaptable: Quickly absorb new information, adapt to changing requirements, and maintain flexibility under tight deadlines.
• Proactive Mindset: Anticipate potential system issues or integration challenges and take initiative to address them before escalation.
• Analytical Thinker: Demonstrated ability to dissect complex problems, evaluate trade-offs, and implement sustainable solutions.
• Team Player: Willingness to collaborate, share knowledge, and mentor junior staff.
• Customer-Focused: Maintain a service-oriented attitude, ensuring stakeholders' needs are met and feedback is incorporated into system enhancements.

We offer a superior benefits package, including excellent medical and dental coverage.

Please Note: ENT and Allergy Associates is an E-Verify employer

Company Description:

ENT and Allergy Associates, LLP is the largest and most comprehensive ear, nose, throat, allergy and audiology practice in the nation with over 60 offices and over 300 Clinicians. Each ENT and Allergy Associates clinical location provides access to a full complement of services, including General Adult and Pediatric ENT, Voice and Swallowing, Facial Plastics and Reconstructive Surgery, Disorders of the Inner Ear and Dizziness, Asthma, Clinical Immunology, Diagnostic Audiology, Hearing Aid dispensing, Sleep and CT Services. ENTA has a clinical alliance with The Mount Sinai Hospital for the treatment of diseases of the head and neck and esophageal cancer and a partnership with the American Cancer Society to educate and treat patients with smoking disorders and cancer. The Practice has also expanded its clinical capabilities to include advanced Immunodeficiency trials.

To learn more about the benefits of ENT and Allergy Associates, or to conveniently find an ENT doctor or Allergy Doctor and then easily book an appointment at the nearest New York or New Jersey location, please visit: www.entandallergy.com or contact us at:

ENT and Allergy Associates, LLP
660 White Plains Road, 4th Floor
Tarrytown, NY 10591