<p><strong><em></em></strong>We are looking for an Analytics Application Engineer to support and advance an internal reporting platform serving teams in River Edge, New Jersey. This position blends application engineering, data integration, and analytics development to deliver reliable dashboards and actionable operational insights. The ideal candidate will be comfortable working across the full stack, from syncing source-system data into a reporting database to shaping intuitive web-based reporting experiences for internal stakeholders.</p><p><br></p><p><strong>Responsibilities:</strong></p><p>• Develop, support, and improve a custom Next.js application that provides interactive dashboards, reusable reports, and performance metrics for internal teams.</p><p>• Oversee the TypeScript-based data ingestion process that brings Salesforce and Litify information into PostgreSQL, with a focus on accuracy, consistency, and timely updates.</p><p>• Structure and maintain the reporting database environment, including curated views, application-managed tables, historical metric records, and dashboard settings.</p><p>• Administer deployments and recurring platform operations through Firebase hosting and GitHub Actions, while monitoring job health and resolving processing issues.</p><p>• Configure and maintain authentication and authorization controls in Firebase to protect access to internal reporting tools.</p><p>• Partner with business stakeholders to convert reporting needs into efficient queries, scalable data models, and user-friendly dashboard designs.</p><p>• Investigate data or application issues across the reporting stack and implement fixes that improve reliability and performance.</p>
<p>The EHR Integration & Data Extraction Specialist serves as the primary technical expert responsible for designing, building, and maintaining data pipelines that connect legacy and modern electronic health record (EHR) platforms—specifically MEDITECH Magic, Client/Server (CS), and Expanse—to downstream analytics, reporting, and enterprise systems. This role requires deep knowledge of EHR native data structures, integration interfaces, and extraction methodologies to deliver accurate, timely, and compliant healthcare data in support of clinical, operational, and regulatory objectives.</p><p><br></p><p><em>Key Responsibilities:</em></p><p><br></p><p>EHR Platform Integration</p><ul><li>Design and implement end-to-end integration solutions for MEDITECH Magic, CS, and Expanse platforms.</li><li>Configure and manage HL7 v2.x interfaces (ADT, ORM, ORU, MDM, DFT) using native interface engines and third-party middleware (e.g., Mirth Connect, Rhapsody, or Microsoft BizTalk).</li><li>Extract data directly from database applications, outputting as SQL backups while ensuring real-time synchronization to capture CRUD operations.</li><li>Build integrations leveraging FHIR R4 APIs, REST web services, and modern integration platforms.</li><li>Troubleshoot and resolve interface failures, data mismatches, and connectivity issues across system environments.</li><li><em>Nice to have:</em> Develop and maintain MEDITECH Magic BAR (Billing/Accounts Receivable), NPR (Non-Patient Reporting), and MAGIC-specific data extraction routines.</li></ul><p><br></p><p>Data Extraction & Transformation</p><ul><li>Extract discrete data, reports, and documents from both proprietary file systems and relational database layers (MS SQL Server).</li><li>Develop SQL queries, stored procedures, and ETL pipelines to pull structured data from enterprise healthcare data warehouses, including Data Repository (DR) and Expanse Data Repository (EDR).</li><li>Transform raw data into MS SQL Server backups capable of handling continuous CRUD operations.</li><li>Build and maintain data validation scripts and design routines to ensure dataset accuracy, completeness, and referential integrity.</li><li>Map proprietary healthcare codes to standard terminologies (ICD-10, SNOMED CT, LOINC, CPT, RxNorm).</li><li>Develop custom reports and extracts using built-in reporting tools (NPR, BAR Report Writer).</li><li><em>Nice to have:</em> Transform raw EHR data into standardized formats (HL7 FHIR, CDA, CSV, JSON, XML) for downstream consumption.</li></ul><p><br></p>