> Markdown version of [/jobs/ext/2555795-allscripts-sunrise-data-extraction-engineer](https://www.wearedevelopers.com/jobs/ext/2555795-allscripts-sunrise-data-extraction-engineer). 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). --- # Allscripts Sunrise Data Extraction Engineer - **Company:** E4, LLC - **Location:** United States (Remote available) - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Application Programming Interfaces (APIs), Application Integration Architecture, Databases, Data Validation, Data Conversion, Extract Transform Load (ETL), Data Mapping, Data Transformation, Data Migration, Data Mining, Data Profiling, Data Retrieval, Data Structures, Data Stores, Database Queries, Interoperability, JSON, Python (Programming Language), Windows PowerShell, SQL Databases, Strategies of Testing, Extensible Markup Language (XML), Data Processing, Scripting, Fast Healthcare Interoperability Resources, Health Level Seven International, Cerner EMPI, Allscripts - **Published:** August 24, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=3c77a74e11c29c66 ## About the Role * 5+ years of experience in healthcare data extraction, ETL, data conversion, or healthcare application integration. * Hands-on experience working with Allscripts Sunrise data. * Demonstrated experience extracting data from Allscripts Sunrise databases or associated data repositories. * Strong SQL skills, including the ability to develop complex queries against healthcare databases. * Experience with healthcare data transformation and source-to-target mapping. * Experience supporting EHR data migration or conversion projects. * Understanding of patient identity, MPI/eMPI, registration, and demographic data. * Experience preparing data for loading into an EHR, preferably Epic. * Strong understanding of healthcare data structures and relationships. * Experience with data profiling, cleansing, validation, reconciliation, and quality assurance. * Strong analytical and troubleshooting skills. Preferred Qualifications * Experience with Python, PowerShell, or other scripting languages. * Experience with HL7, FHIR, XML, JSON, APIs, or other healthcare interoperability standards. * Experience with patient matching, duplicate remediation, and enterprise MPI initiatives. * Experience working with Allscripts Sunrise Clinical Manager and/or associated Sunrise applications. ## Description The Extraction Engineer will be responsible for understanding the Allscripts Sunrise source environment, developing and executing data extraction processes, transforming source data into Epic-compatible structures and formats, and supporting data validation and reconciliation. The ideal candidate will have hands-on experience with Allscripts Sunrise data structures, healthcare data extraction, SQL, ETL, data transformation, and Epic data migration., * Extract MPI and PAMI data from Allscripts Sunrise and associated databases, repositories, and source systems. * Analyze Allscripts Sunrise data structures, tables, fields, relationships, and data dependencies to determine appropriate extraction methodologies. * Develop and execute SQL queries, scripts, and extraction routines to retrieve required patient and administrative data. * Extract patient demographic, identity, encounter, provider, facility, registration, insurance, and other required PAMI data elements. * Transform Allscripts Sunrise source data into Epic-compatible formats and structures based on defined migration specifications. * Develop and maintain source-to-target mappings between Allscripts Sunrise and Epic. * Apply transformation, cleansing, normalization, and standardization logic to prepare data for Epic loading. * Support MPI/eMPI data conversion, including patient identifiers, demographic attributes, aliases, addresses, contact information, and other patient identity elements. * Identify and resolve data quality issues that could impact Epic loading or patient matching. * Support extraction and transformation of historical PAMI data required for Epic implementation or migration. * Work closely with Epic conversion analysts to ensure extracted data meets Epic loading requirements and specifications. * Partner with data migration, integration, MPI, clinical, and technical teams to resolve mapping and conversion issues. * Perform data profiling, validation, reconciliation, and record-count comparisons between Allscripts Sunrise and converted datasets. * Develop processes to identify missing, invalid, duplicate, or inconsistent source data. * Support mock conversions, testing cycles, data validation, dress rehearsals, and production migration activities. * Previous experience supporting an Allscripts Sunrise-to-Epic migration. * Experience with Epic data conversion and Epic load processes. * Experience with Epic MPI/Identity and PAMI conversion activities. * Familiarity with Epic conversion tools, templates, or loading methodologies. * Experience with large-scale hospital or health system EHR migrations. * Experience with ETL tools and data transformation frameworks. * Troubleshoot extraction and transformation issues and modify processes as requirements evolve. * Maintain detailed technical documentation for extraction routines, data mappings, transformation rules, and conversion processes. * Ensure all data handling and migration activities comply with HIPAA, security, privacy, and organizational requirements. ## Related Videos - [Tips and Tricks for Working with JSON](https://www.wearedevelopers.com/videos/1229-tips-and-tricks-for-working-with-json) - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [JavaScript? No. Java Scripts! - Scripting with Java](https://www.wearedevelopers.com/videos/2094-javascript-no-java-scripts-scripting-with-java) - [Why make use of an integration platform in today's software developments and infrastructure?](https://www.wearedevelopers.com/videos/758-why-make-use-of-an-integration-platform-in-today-s-software-developments-and-infrastructure) - [Introducing JSON Structure](https://www.wearedevelopers.com/videos/100219-introducing-json-structure) - [Replacing Excel with SAP APIs & Python validation](https://www.wearedevelopers.com/videos/1944-replacing-excel-with-sap-apis-python-validation) ## Related Articles - [Why Upskilling And Reskilling is Important For Developers](https://www.wearedevelopers.com/magazine/428-why-upskilling-and-reskilling-is-important-for-developers) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Is Software Engineering Over-Saturated?](https://www.wearedevelopers.com/magazine/418-is-software-engineering-over-saturated) - [Fully Remote Software Engineer Jobs](https://www.wearedevelopers.com/magazine/447-fully-remote-software-engineer-jobs) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)