Technical Solution Architect Consulting- myAvatar

Netsmart; Overland Park (KS); On-site; USD 120,000 - 150,000; Full time

Job summary

Netsmart is seeking a Technical Solution Architect to design workflows, develop enterprise reports with ActiveReports, and translate complex business needs into scalable healthcare IT solutions. You will work with clients, analysts, and stakeholders to optimize systems, upgrades, and maintenance while driving adoption and value realization.

You will leverage SQL and data analysis to deliver accurate insights within the Netsmart myAvatar NX platform, ensuring reporting supports informed decisions

Qualifications

• Bachelor's degree or equivalent relevant work experience.
• 4+ years in health care IT implementation or consulting.
• 3+ years developing enterprise reports with ActiveReports/ActiveReports.NET.
• 3+ years writing SQL queries with joins, subqueries and data validation.
• 1+ year of project management experience.

Responsibilities

• Design, develop, modify, and maintain reports using ActiveReports/ActiveReports.NET.
• Implement grouping, sorting, filtering, parameters, and charts in reports.
• Provide workflow and solution design guidance during client engagements.
• Guide clients through upgrades, changes and ongoing maintenance.
• Lead troubleshooting and knowledge transfer for client solutions.
• Foster client relationships and manage issue escalation.
• Oversee project delivery to meet engagement goals.
• Mentor solution teams on best practice methodologies.

Skills

Solution design

SQL queries

Stakeholder communication

Data analysis

Healthcare IT domain knowledge

Education

Bachelor's degree or equivalent

Tools

ActiveReports

ActiveReports.NET

Job description

Apply solution knowledge within a single domain while incorporating end-user needs, regulatory context, and industry insight to design workflows and support solution adoption and client outcomes The Techncial Solution Architect serves as a trusted advisor to clients, providing workflow consultation, solution design, system optimization, and reporting expertise to support clinical, operational, financial, and regulatory business objectives. This role partners with clients, application analysts, database teams, and business stakeholders to translate complex business requirements into scalable solutions while guiding organizations through system enhancements, upgrades, troubleshooting, and ongoing maintenance. In addition to solution consulting responsibilities, the Solution Architect designs, develops, and maintains enterprise reports using ActiveReports and ActiveReports.NET, leveraging advanced SQL and data analysis skills to deliver accurate, actionable insights within the Netsmart myAvatar NX platform. The role is responsible for report development, testing, validation, performance optimization, documentation, and client knowledge transfer, ensuring reporting solutions support informed decision-making and maximize the value of the client's technology investment.

Responsibilities

• Design, develop, modify, and maintain reports utilizing ActiveReports and ActiveReports.NET based on documented business requirements.
• Develop report functionality such as grouping, sorting, filtering, parameters, calculated fields, conditional formatting, charts, subreports, and export capabilities.
• Provide expertise during client engagement to deliver workflow and solution design to achieve defined benefits.
• Responsible for guiding clients through current workflows, upgrades, system changes, enhancements, and ongoing system maintenance.
• Act as a primary consultant for the client’s solution troubleshooting, consultation, and knowledge transfer
• Cultivate and sustain relationships with clients to provide appropriate escalation of issues, solution knowledge, and engagement support.
• Seek to resolve escalated problems and issues using solution knowledge and expertise during installation, operation, maintenance or testing.
• Manage client expectations and ensure project delivery meets goals of engagement.
• Coach, mentor and guide solution teams on recommended methodology practices.

Qualifications Required

• Bachelor's degree or equivalent relevant work experience
• At least 4 years of health care information technology implementation or consulting working experience
• At least 3 years of experience developing enterprise reports utilizing ActiveReports and/or ActiveReports.NET
• At least 3 years of experience writing Structured Query Language (SQL) queries including joins, subqueries, aggregate functions, and data validation techniques.
• At least 1 year of project management experience
• Ability to communicate effectively with technical, clinical and operational teams
• Ability to document and present architecture concepts, often narrowing complex ideas to a single overview
• Ability to build strong client relationships and delivering client-centric solutions
• Ability to make sense of complex, high quantity and sometimes contradictory information to effectively solve problems

Preferred

• At least 2 years Netsmart EHR solution work experience

Expectations

Travel expected up to 20% of the time as needed Position may at times require extended or irregular hours outside of traditional office hours to support clients and projects across multiple time zones and any required travel

Netsmart is proud to be an equal opportunity workplace and is an affirmative action employer, providing equal employment and advancement opportunities to all individuals. We celebrate diversity and are committed to creating an inclusive environment for all associates. All employment decisions at Netsmart, including but not limited to recruiting, hiring, promotion and transfer, are based on performance, qualifications, abilities, education and experience. Netsmart does not discriminate in employment opportunities or practices based on race, color, religion, sex (including pregnancy), sexual orientation, gender identity or expression, national origin, age, physical or mental disability, past or present military service, or any other status protected by the laws or regulations in the locations where we operate.

Netsmart desires to provide a healthy and safe workplace and, as a government contractor, Netsmart is committed to maintaining a drug-free workplace in accordance with applicable federal law.

Pursuant to Netsmart policy, all post-offer candidates are required to successfully complete a pre-employment background check, including a drug screen, which is provided at Netsmart’s sole expense. In the event a candidate tests positive for a controlled substance, Netsmart will rescind the offer of employment unless the individual can provide proof of valid prescription to Netsmart’s third party screening provider.

If you are located in a state which grants you the right to receive information on salary range, pay scale, description of benefits or other compensation for this position, please use this form to request details which you may be legally entitled.

All applicants for employment must be legally authorized to work in the United States. Netsmart does not provide work visa sponsorship for this position. Netsmart's Job Applicant Privacy Notice may be found here.

Have you ever been to a doctor’s office and submitted your information electronically? Had a telehealth video visit with a therapist? Or scheduled a follow-up visit with your provider through a mobile app? These are just a few examples of how you may have used healthcare technology software in your life as a consumer. Many people view the operating system of healthcare as the electronic health record, but at Netsmart we have a comprehensive platform of solutions and services we offer for our clients.

At Netsmart, we provide our post-acute and human services clients with advanced technology to better serve the individuals and patients in their care. Our Netsmart team is vision driven, cause connected and passionate about opportunity. A combination of inspiration through our client work paired with the ability to innovate and explore fuels the success of our associates and company as a whole. Netsmart is focused on providing a candidate experience that mirrors our associate experience.

The CandE Winners - Talent Board We are proud to be named one of Ingram’s Best Companies to Work For.

If you require accessibility assistance or accommodation for a disability when navigating our website or completing the application process, please contact 1-800-842-1973, option 4 or [e-mail] for assistance.

US Applicants: Learn more about your EEO rights under the law (en Español). Netsmart’s affirmative action plan is available for review by contacting [e-mail].

Netsmart participates in E-Verify and adheres to the Fair Labor Standard Act.