Electronic Health Record; EHR) Data

GENERAL FUNCTION 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.

SPECIFIC RESPONSIBILITIESEHR Development and Programming Design, 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 Smart Care 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 Support Successfully complete Streamline Healthcare's Advanced Technical Training and maintain the required competencies to access and work within the Smart Care 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 Analytics Design, develop, and maintain a centralized reporting database/data warehouse that consolidates clinical, operational, financial, and quality data from the Smart Care 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 Management Document 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…