Netsmart Custom Report Writer

We are seeking an experienced Netsmart Custom Report Writer with strong KPI and dashboard development skills to support reporting, analytics, and operational performance initiatives. This role is responsible for designing and maintaining custom reports, developing executive dashboards, and creating meaningful KPIs within Netsmart systems to support clinical, financial, and operational decision-making.

The ideal candidate combines healthcare reporting expertise with strong SQL, analytics, and business intelligence capabilities and can work collaboratively with leadership and end users to deliver actionable insights.

Key Responsibilities

• Develop, customize, and maintain reports within Netsmart platforms including myAvatar and myEvolv
• Design and build KPI dashboards for executive, clinical, financial, and operational teams.
• Create complex SQL queries, stored procedures, and reporting datasets.
• Gather and analyze business requirements from stakeholders and translate them into reporting solutions.
• Develop automated reports and dashboard refresh schedules.
• Monitor and validate data integrity, accuracy, and consistency across reporting environments.
• Create data visualizations and scorecards to track organizational performance metrics.
• Support compliance, quality improvement, productivity, and revenue cycle reporting initiatives.
• Troubleshoot report issues and optimize report performance.
• Document report logic, KPI definitions, and dashboard specifications.
• Provide user support and training related to reporting tools and dashboard functionality.

Required Qualifications

• Bachelor's degree in Information Systems, Healthcare Informatics, Computer Science, Business Analytics, or related field, or equivalent work experience.
• 3+ years of experience developing reports within Netsmart environments.
• Advanced SQL and relational database experience.
• Experience building KPIs, scorecards, and executive dashboards.
• Hands-on experience with BI and visualization tools such as:
  • Power BI
  • Tableau
  • SSRS
  • Crystal Reports
• Knowledge of healthcare operations, behavioral health workflows, or EHR systems.
• Strong analytical and problem-solving skills.

Preferred Qualifications

• Experience in behavioral health or community healthcare organizations.
• Knowledge of healthcare data standards such as HL7 or interoperability concepts.
• Familiarity with ETL processes and data warehousing.
• Understanding of HIPAA and healthcare compliance reporting requirements.
• Experience integrating data from multiple healthcare systems.

Technical Skills

• SQL Server / T-SQL
• Report writing and optimization
• Dashboard development and visualization
• KPI creation and performance analytics
• Data extraction and transformation
• Healthcare analytics and operational reporting