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 .

Requirements

Must-haves

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
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
Bachelor s degree or equivalent relevant work 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
At least 2 years Netsmart EHR solution work experience
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

Nice-to-haves

Expectations
Travel expected up to 20% of the time as needed
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 .

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sql

Platform: workday
Effort: long