Senior Techno-Functional Consultant - Netsmart myAvatar

Job Title: Senior Techno-Functional Consultant - Netsmart myAvatar

Experience Level: 10-12 years
Department: Healthcare Product Engineering / EHR Delivery

Job Summary

We are looking for a Senior Techno-Functional Consultant specializing in the Netsmart myAvatar EHR platform. You will serve as the technical and functional anchor for our behavioral health EHR ecosystem. In this role, you will design custom workflows, build system integrations and optimize backend databases. You will directly translate U.S. behavioral health clinical and financial needs into scalable technical solutions.

Core Responsibilities

• myAvatar Customisation: Configure and customize myAvatar using RADplus, Form Designer, and custom tables to meet complex clinical workflows.
• Business Logic & Automation: Develop and maintain complex business rules, validations, and data automation using ScriptLink (C#/.NET or JavaScript).
• Reporting & Analytics: Design, write, and optimize complex operational and financial reports using Crystal Reports and SQL Server Reporting Services (SSRS).
• Database & Performance: Write and tune advanced SQL Server stored procedures, views, and triggers to handle heavy EHR data loads safely.
• Interoperability: Build and manage data exchanges using HL7 interfaces and custom APIs to connect myAvatar with external labs, pharmacies, and state registries.
• Production Support: Provide Tier 3 technical support, debugging complex code drops, database lockouts, and interface failures.

Required Technical & Functional Skills

• Netsmart Focus: 5+ years of dedicated technical experience explicitly within the Netsmart myAvatar ecosystem.
• Core Tech Stack: Advanced proficiency in Microsoft SQL Server, T-SQL, and .NET Framework (C#).
• myAvatar Tools: Proven hands-on experience with ScriptLink, RADplus, and Crystal Reports.
• Healthcare Data: Strong understanding of HL7 formatting and U.S. behavioral health workflows (intake, assessments, treatment plans).
• RCM Awareness: Familiarity with myAvatar financial modules, including billing matrices, charge generation, and 837/835 electronic claims.