HER/EPM Applications Specialist

HER/EPM Applications Specialist
Location: Tarrytown, NY
Compensation: $125-138KThis role 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.

Responsibilities:
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.

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.

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.

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.

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.

Qualifications:

• 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.).
• 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.