> Markdown version of [/jobs/ext/3337312-electronic-health-record-ehr-data-applications-developer](https://www.wearedevelopers.com/jobs/ext/3337312-electronic-health-record-ehr-data-applications-developer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Electronic Health Record (EHR) Data & Applications Developer - **Company:** Allendale Association - **Location:** Lake Villa, IL, United States - **Experience:** Experienced - **Salary:** $93,600.0 - **Contract:** Permanent contract - **Skills:** HTML, Java (Programming Language), JavaScript (Programming Language), .NET Framework, C Sharp (Programming Language), Cascading Style Sheets (CSS), Information Systems, Computer Programming, Databases, Data Architecture, Data Integration, Data Integrity, Extract Transform Load (ETL), Data Mining, Data Security, Data Warehousing, Relational Databases, Database Development, Database Storage Structures, Graphical User Interface, Human-Computer Interaction, Identity and Access Management, Performance Tuning, Power BI, Service Pack, Software Deployment, Software Engineering, SQL Stored Procedures, SQL Databases, SQL Server Reporting Services, Reliability of Systems, Electronic Medical Records, Backend, Git, Information Technology, Data Management, Tools for Reporting, Zendesk, Software Version Control, Custom Reports - **Published:** September 14, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=e2f81c18f3ce4081 ## About the Role 1. Bachelor's degree in Computer Science, Information Systems, Software Engineering, or a related field. 2. Three (3) years of experience in software development, application programming, database development, or EHR application support. 3. Experience designing and maintaining relational databases, data warehouses, ETL processes, and business intelligence data models. 4. Advanced SQL development skills including creation of views, stored procedures, functions, and performance optimization. 5. Experience developing Power BI semantic models, dataflows, and enterprise reporting solutions. 6. Ability to communicate technical concepts effectively to non-technical users and provide remote support as needed. 7. Ability to successfully complete Streamline Healthcare's Advanced Technical Training upon hire. ## Description The 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. EHR Development and Programming 1. Design, develop, test, and maintain EHR applications, interfaces, and custom programming solutions. 2. Utilize SQL, HTML, CSS, JavaScript, C#, .NET, and related technologies to develop, customize, and maintain SmartCare backend reports, forms, configurations, workflows, and database objects. 3. 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. 4. Develop and maintain custom Data Form Architect (DFA) forms, templates, and configurations to support business and clinical workflows. EHR Administration and Support 1. Successfully 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. 2. 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. 3. 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 Analytics 1. Design, 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. 2. Develop, maintain, and optimize automated data extraction, transformation, and loading (ETL) processes to move data from the EHR into a centralized reporting environment. 3. 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. 4. Ensure compliance with organizational policies and applicable regulations governing data security, privacy, confidentiality, and access management. Documentation and Change Management 1. Document all code, reports, configurations, and customizations according to established standards to support system maintenance, version control, and knowledge transfer. 2. Maintain all programming code, reports, and related technical artifacts within a centralized source-control repository (e.g., Git). 3. Develop and maintain User Requirements Documents (URDs), technical specifications, testing plans, and deployment documentation to support system modifications and enhancements. ## Related Videos - [The AI Agent Path to Prod: Building for Reliability](https://www.wearedevelopers.com/videos/1523-the-ai-agent-path-to-prod-building-for-reliability) - [The Resilience of the World Wide Web](https://www.wearedevelopers.com/videos/1281-the-resilience-of-the-world-wide-web) - [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [NoLoJS - Avoiding JavaScript Cruft with HTML and CSS - Aaron T. Grogg](https://www.wearedevelopers.com/videos/1806-nolojs-avoiding-javascript-cruft-with-html-and-css-aaron-t-grogg) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) ## Related Articles - [What’s the Difference between a Junior, Mid, and Senior Developer?](https://www.wearedevelopers.com/magazine/238-what-s-the-difference-between-a-junior-mid-and-senior-developer) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries) - [Software Developer Salary in Germany [2023]](https://www.wearedevelopers.com/magazine/194-software-developer-salary-in-germany-2023) - [7 Important Tips That Every Software Developer Should Know](https://www.wearedevelopers.com/magazine/101-7-important-tips-that-every-software-developer-should-know) - [Frontend Developer Salary in Germany [2023]](https://www.wearedevelopers.com/magazine/195-frontend-developer-salary-in-germany-2023)