Netsmart Reporting & Development

Job Description

Netsmart Custom Report Writer
Location: Remote\n
Employment Type: Full-Time and Part-Time Opportunities Available\n
Compensation: Commensurate with Experience\n
\n
Why Work for The EHR Edge?
At The EHR Edge , you'll have the opportunity to become part of a growing organization where your ideas, experience, and contributions can help shape our future. As part of the ITPI Group of Companies, we offer the entrepreneurial environment of a young organization backed by a team with more than 250 years of combined experience .\n
\n You'll work alongside experienced professionals and directly with Human Services organizations where your knowledge can make a measurable difference. Rather than being limited to one system, one department, or one type of project, you'll have opportunities to solve complex problems, improve reporting, strengthen data visibility, and help clients make better-informed decisions.\n
\n We believe successful EHR consulting isn't just about understanding the technology. It's about understanding the people who use it, the processes it supports, and the outcomes the organization needs to achieve.
For someone joining us as a Netsmart Custom Report Writer , that means going beyond simply producing reports. You'll help organizations turn their EHR data into meaningful information that gives executives, financial leaders, clinical teams, and operational leaders greater visibility into organizational performance.\n
\n If you enjoy solving complex data challenges and turning information into actionable insights, The EHR Edge offers an opportunity to help shape a growing organization while helping Human Services leaders get more value from their EHR data.
\n
Position Summary
The Netsmart Custom Report Writer serves as a reporting and analytics specialist responsible for designing, developing, optimizing, and maintaining custom reports, dashboards, scorecards, and Key Performance Indicators within Netsmart environments, with particular emphasis on myAvatar and/or myEvolv .\n
\n This role works directly with executive, financial, clinical, operational, compliance, and technical stakeholders to understand the questions they need answered and translate those requirements into meaningful reporting and analytics solutions.\n
\n The successful candidate will combine strong technical reporting and SQL expertise with an understanding of Human Services operations. The goal is not simply to produce more reports—it is to provide accurate, accessible, actionable information that leadership can trust and use to make better decisions.
\n
Key Responsibilities
Netsmart Reporting & Development \n

\n
• Develop, customize, optimize, and maintain reports within Netsmart environments, including myAvatar and myEvolv .
\n
• Develop complex SQL queries, stored procedures, datasets, and other reporting components.
\n
• Analyze existing reports and identify opportunities to improve performance, usability, accuracy, and efficiency.
\n
• Troubleshoot reporting issues and resolve data, logic, performance, or configuration problems.
\n
• Develop automated reporting processes and appropriate refresh schedules.
\n
• Maintain clear documentation of report logic, data sources, calculations, and dependencies.
\n

Dashboards, KPIs & Analytics \n

\n
• Design and develop dashboards for executive, clinical, financial, operational, compliance, and other organizational stakeholders.
\n
• Work with leadership to identify meaningful Key Performance Indicators and translate organizational goals into measurable metrics.
\n
• Develop scorecards and visualizations that clearly communicate organizational performance and trends.
\n
• Define and document KPI calculations, business rules, data sources, and reporting methodologies.
\n
• Help organizations move from static reporting toward more actionable performance analytics.
\n
• Identify trends, exceptions, risks, and opportunities within organizational data.
\n

Business Requirements & Consulting \n

\n
• Meet with client executives, managers, clinicians, financial teams, and operational stakeholders to understand their reporting and information needs.
\n
• Translate business questions and operational requirements into technical reporting solutions.
\n
• Help stakeholders determine not only what data is available, but what information is most meaningful to measure .
\n
• Recommend reporting strategies that improve organizational visibility and decision-making.
\n
• Communicate technical concepts and data findings in language appropriate for both technical and nontechnical audiences.
\n

Data Quality & Validation \n

\n
• Validate report accuracy and ensure consistency across reporting environments.
\n
• Identify discrepancies, incomplete data, inconsistent definitions, and other data-quality concerns.
\n
• Work with client teams to determine whether reporting issues originate from report logic, system configuration, workflow, documentation, or data-entry practices.
\n
• Establish appropriate validation processes before reports and dashboards are released to users.
\n
• Help clients develop greater confidence in the accuracy and reliability of their EHR data.
\n

Clinical, Financial & Operational Reporting \n

\n
• Support reporting initiatives related to clinical performance, operational efficiency, productivity, revenue cycle management, compliance, quality improvement, and executive decision-making.
\n
• Develop reports and dashboards that help leadership identify operational bottlenecks and performance trends.
\n
• Support revenue-cycle reporting and visibility into financial performance when appropriate.
\n
• Assist with compliance and regulatory reporting requirements.
\n
• Help organizations reduce dependence on manual spreadsheets and disconnected reporting processes where appropriate.
\n

Training & Knowledge Transfer \n

\n
• Provide training and support to users on reporting tools, dashboards, KPIs, and report interpretation.
\n
• Develop documentation and reference materials for reports and dashboards.
\n
• Transfer reporting knowledge to appropriate client personnel to support long-term sustainability.
\n
• Collaborate with client teams to encourage consistent definitions and use of organizational KPIs.
\n

Required Qualifications \n

\n
• 3+ years of experience developing reports within Netsmart environments.
\n
• Demonstrated hands-on experience with Netsmart myAvatar and/or myEvolv reporting.
\n
• Advanced SQL and relational database experience.
\n
• Strong SQL Server/T-SQL skills.
\n
• Experience developing custom reports, reporting datasets, and complex queries.
\n
• Demonstrated experience building KPIs, scorecards, and executive dashboards .
\n
• Experience with one or more reporting or Business Intelligence platforms such as:\n
  \n
  • Power BI
  \n
  • Tableau
  \n
  • SSRS
  \n
  • Crystal Reports
  \n
\n
• Understanding of EHR data and healthcare or Human Services operational workflows.
\n
• Strong analytical, troubleshooting, and problem-solving skills.
\n
• Ability to gather business requirements and translate them into technical solutions.
\n
• Strong written and verbal communication skills.
\n
• Ability to communicate effectively with both technical and nontechnical stakeholders.
\n

Preferred Qualifications \n

\n
• Bachelor's degree in Information Systems, Healthcare Informatics, Computer Science, Business Analytics, Data Analytics, or a related field, or equivalent professional experience.
\n
• Experience specifically within Human Services, behavioral health, intellectual and developmental disabilities, addiction treatment, or other community-based service organizations .
\n
• Experience developing executive-level reporting and dashboards.
\n
• Experience with healthcare financial, revenue cycle, clinical, compliance, and operational reporting.
\n
• Familiarity with ETL processes and data warehousing.
\n
• Experience integrating and reporting data from multiple systems or data sources.
\n
• Understanding of HIPAA and healthcare compliance reporting requirements.
\n
• Knowledge of HL7, interoperability concepts, or healthcare data standards.
\n
• Experience working in a healthcare IT or EHR consulting environment.
\n

Key Skills & Competencies \n

\n
• Netsmart myAvatar and/or myEvolv reporting
\n
• SQL Server / T-SQL
\n
• Custom report development
\n
• Report optimization
\n
• Executive dashboard development
\n
• KPI development and performance analytics
\n
• Business Intelligence and data visualization
\n
• Data extraction and transformation
\n
• Data validation and quality assurance
\n
• Healthcare and Human Services analytics
\n
• Clinical, financial, and operational reporting
\n
• Revenue-cycle reporting
\n
• Business requirements analysis
\n
• Data storytelling and visualization
\n
• Client consulting and communication
\n
• Training and knowledge transfer
\n
• Problem solving and critical thinking
\n