Backend Assistant Jobs in Milan, IN (NOW HIRING)

Remote!
POSITION SUMMARY
INcompass Healthcare is seeking an experienced EHR Systems Engineer to support and optimize the organization's SmartCare Electronic Health Record (EHR) platform. This role is responsible for ensuring the performance, reliability, integrity, and ongoing enhancement of the EHR environment through database engineering, reporting development, quality assurance, and technical troubleshooting.
The EHR Systems Engineer partners closely with clinical, operational, financial, and executive
stakeholders to develop scalable technical solutions that improve reporting, system functionality, integrations, and overall application performance. This position also supports upgrades, testing, change management, and ongoing system optimization initiatives.
The ideal candidate possesses advanced SQL expertise, strong analytical and troubleshooting skills, experience with reporting and business intelligence tools, and the ability to manage complex technical environments. Experience working within behavioral health, mental health, or healthcare organizations is strongly preferred.
ESSENTIAL DUTIES AND RESPONSIBILITIES
Application& Database Engineering - the essential functions include, but are not limited to the following:

• Design, develop, enhance, and maintain database-driven application components and solutions.
• Write, optimize, troubleshoot, and maintain complex SQL queries, stored procedures, and database objects.
• Refactor and improve existing code for scalability, efficiency, and maintainability.
• Develop and maintain SSRS reports aligned with clinical, operational, and executive workflows.
• Support data integrations, ETL processes, and interoperability initiatives.
• Analyze business requirements and translate them into effective technical solutions.
• Assist with SmartCare upgrades, enhancements, testing, and production deployments.
• Reporting & Business Intelligence
• Maintain reporting standards, documentation, and data governance practices.
• Define and validate report logic, calculations, and reporting assumptions.
• Ensure consistency, integrity, and accuracy across operational and executive reporting outputs.
• Support dashboard development and analytics initiatives using Power BI or similar BI platforms.
• Perform backend data validation and data quality analysis.

Quality Assurance & Defect Management

• Develop and execute detailed test cases, including preconditions, validation steps, and expected outcomes.
• Validate system changes, enhancements, integrations, and defect resolutions prior to deployment.
• Conduct structured defect retesting and support issue resolution activities.
• Perform root cause analysis to identify systemic issues and recommend preventative improvements.
• Promote best practices related to testing, documentation, and change management processes

Cross-Functional Collaboration

• Conduct structured code reviews and design review discussions.
• Provide timely and actionable project updates to stakeholders and leadership.
• Support organizational decision-making through data-backed technical analysis.
• Partner with clinical, operational, financial, and executive teams to prioritize enhancements and reporting needs.

MINIMUM QUALIFICATIONS (KNOWLEDGE, SKILLS, AND ABILITIES)
General

• Bachelor's degree in Information Technology, Computer Science, Health Information Mgt,
• Healthcare Informatics.
• 3-5 years of EHR management, database and programming experience.

Technical Skills

• Advanced SQL Server expertise
• Understanding of relational database design and normalization
• Experience with SSIS (ETL processes)
• Experience building reports in SSRS
• Familiarity with Power BI or other business intelligence platforms preferred
• Experience validating backend data integrity
• Understanding of EHR systems and healthcare workflows
• Knowledge of HIPAA and healthcare data compliance standards

Professional Skills

• Strong analytical and troubleshooting skills
• Ability to conduct structured root cause analysis
• Excellent written and verbal communication
• Ability to manage multiple concurrent initiatives
• High attention to detail and documentation rigor
• Strong collaboration and stakeholder management skills
• Self-motivated with the ability to work independently and in team environments

Our Benefits

• Medical, Dental, and Vision Insurance
• Prescription Coverage
• Company Paid Life , AD&D and Disability Insurance
• Company match up to 4.5% for 401k.
• Generous PTO Plan, no wait period
• Tuition Reimbursement
• Unlimited employee referrals
• Paid holidays