Electronic Health Record (EHR) Data

Allendale; Lake Villa (IL); On-site; USD 90,000 - 120,000; Full time

Job summary

Allendale is seeking an EHR Data & Applications Developer to lead programming, data integration, and DB development for SmartCare EHR systems. You will design, test, and maintain backend reports, interfaces, and DFA forms, and build centralized reporting data models and dashboards.

The role focuses on data integrity, security, and continuous improvement, partnering with IT, vendors, and end users to deliver enterprise BI solutions and compliant analytics.

Qualifications

• Bachelor's degree required in CS/IS/SE or related field.
• 3 years of software development, app programming, DB development, or EHR support.
• Advanced SQL development for views, procedures, functions, and performance.
• Experience building Power BI semantic models, dataflows, and enterprise reporting.

Responsibilities

• Lead EHR programming, data integration, and DB development.
• Design, develop, test, and maintain EHR apps, interfaces, and custom programs.
• Develop reports/dashboards using SSRS and other tools.
• Build centralized data warehouse and ETL processes for reporting needs.
• Create DFA forms, templates, and configurations for workflows.
• Collaborate with EHR Manager, IT, vendors, and end users for reliability, data integrity, and improvements.

Skills

SQL development

Power BI

ETL processes

Data modeling

C#/.NET

SSRS

Data warehouse design

Education

Bachelor's degree in Computer Science / Information Systems / Software Engineering

Tools

Git

SSRS

Job description

GENERAL FUNCTIONThe EHR Data & Applications Developer serves as the technical lead for EHR programming, data integration, and database development. The position is responsible for assisting with EHR testing, troubleshooting, creating data extraction pathways from the EHR, and developing custom reports, forms, and/or templates to support reporting needs. The position is responsible for designing and managing a centralized reporting database and data architecture, and building Power BI data models and reporting solutions that support clinical, operational, quality improvement, regulatory, and strategic initiatives. The role collaborates closely with the EHR Manager, Information Technology staff, vendors, and end users to ensure system reliability, data integrity, and continuous improvement.SPECIFIC RESPONSIBILITIESEHR Development and ProgrammingDesign, develop, test, and maintain EHR applications, interfaces, and custom programming solutions.Utilize SQL, HTML, CSS, JavaScript, C#, .NET, and related technologies to develop, customize, and maintain SmartCare backend reports, forms, configurations, workflows, and database objects.Design, develop, test, and deploy custom reports and dashboards using SQL Server Reporting Services (SSRS) and other reporting tools. Ensure reports are accurate, user-friendly, and accessible through the system's graphical user interface.Develop and maintain custom Data Form Architect (DFA) forms, templates, and configurations to support business and clinical workflows.EHR Administration and SupportSuccessfully complete Streamline Healthcare's Advanced Technical Training and maintain the required competencies to access and work within the SmartCare application backend, database structures, and user interface components.Troubleshoot and resolve application, reporting, and connectivity issues within the EHR environment. Coordinate with the vendor through the Streamline Zendesk support portal, track incidents through resolution, and document outcomes.Collaborate with the EHR Manager and stakeholders to test and validate customizations, service packs, software updates, patches, and system upgrades before production deployment.Data Management and AnalyticsDesign, develop, and maintain a centralized reporting database/data warehouse that consolidates clinical, operational, financial, and quality data from the SmartCare EHR and other organizational systems.Develop, maintain, and optimize automated data extraction, transformation, and loading (ETL) processes to move data from the EHR into a centralized reporting environment.Design, build, and maintain Power BI datasets, semantic models, reporting tables, measures, and dashboards that support operational management, quality improvement, regulatory reporting, and strategic decision-making.Ensure compliance with organizational policies and applicable regulations governing data security, privacy, confidentiality, and access management.Documentation and Change ManagementDocument all code, reports, configurations, and customizations according to established standards to support system maintenance, version control, and knowledge transfer.Maintain all programming code, reports, and related technical artifacts within a centralized source-control repository (e.g., Git).Develop and maintain User Requirements Documents (URDs), technical specifications, testing plans, and deployment documentation to support system modifications and enhancements.It is the responsibility of each employee to fully participate with and demonstrate competence in all required Agency training, supervision, and performance evaluation protocols appropriate to their position and professional standing; thorough understanding of and compliance with all employee policies and work rules is required.Safety and hazard surveillance is everyone's job at Allendale. Due to the nature of our clients and the accident potential of everyday clients, this is an ongoing task. Safety begins by taking a close look at the potential hazards in your work area and taking action to eliminate them as they occur.Additional compensation may be paid for the performance of additional duties outside of the assigned responsibilities for an employee’s position due to servicing additional clients, performing additional responsibilities due to vacancies in other positions, covering direct care shifts (by exempt classification staff) or other circumstances, as deemed appropriate.EDUCATION, TRAINING AND EXPERIENCEA. REQUIRED:Bachelor's degree in Computer Science, Information Systems, Software Engineering, or a related field.Three (3) years of experience in software development, application programming, database development, or EHR application support.Experience designing and maintaining relational databases, data warehouses, ETL processes, and business intelligence data models.Advanced SQL development skills including creation of views, stored procedures, functions, and performance optimization.Experience developing Power BI semantic models, dataflows, and enterprise reporting solutions.Ability to communicate technical concepts effectively to non-technical users and provide remote support as needed.Ability to successfully complete Streamline Healthcare's Advanced Technical Training upon hire.