Acute Care Technology At ZOLL, we're passionate about improving patient outcomes and helping save lives. We provide innovative technologies that make a meaningful difference in people's lives. Our medical devices, software and related services are used worldwide to diagnose and treat patients suffering from serious cardiopulmonary and respiratory conditions. The Acute Care Technology division of ZOLL Medical Corporation develops and delivers innovative lifesaving products and software solutions to EMS, hospital, public safety, and military customers globally. Products include AEDs, trauma kits, ventilators, temperature management solutions, and more. Our dedicated employees take pride in their commitment to improving patient outcomes while delivering world-class customer service. Job Type Remote Job Summary The Data Reporting & ETL Lead supports reporting automation, data integrity, and custom analytics across the Golden Hour Portal and ZOLL Billing platforms. This role is critical in maintaining and enhancing our reporting infrastructure, ensuring accurate data delivery to internal and external stakeholders, and supporting evolving business needs through custom development. Essential Functions Golden Hour Portal: Automate End-of-Month (EOM) reporting workflows Maintain Excel templates and automate Pivot table generation Update and manage the various Birst reports to reflect mapping changes Support executable tools for generating and delivering EOM reports to customers Diagnose and resolve data discrepancies between Birst and RCM Portal Facilitate integration of new fields from Oracle into Golden Hour Birst models Support automated daily email delivery Configure Birst API queries Maintain C# encryption and email delivery application ZOLL Billing: Extend reporting capabilities for Golden Hour Develop custom ETL pipelines using SQL for claims and transaction data Script and model Birst data to mirror Golden Hour reporting standards Create templates and custom reports for newly onboarded clients Build and maintain additional ETL solutions to meet customer-specific reporting needs Integrate with Insights and zeds database Develop Birst scripts and models for enhanced field availability Incorporate emsCharts data via Oracle queries for reconciliation Design and deliver advanced Birst reports and dashboards Support RescueNet migration reporting Transfer reporting skills to clients Maintain and enhance SSRS reports and zeds stored procedures Contribute to standard reporting offerings and prototype ETL changes for Atlantis Implement SSIS packages, update tables/views, and model changes in Insights Investigate and resolve reporting issues in collaboration with internal stakeholders Fulfill custom report requests and perform database queries via a read replica of the production database Tune ETL performance based on diagnostics Required/Preferred Education and Experience Bachelor's Degree in related field. required 7-9 years of experience in Revenue Cycle Management. required Knowledge, Skills and Abilities Strong experience with SQL, ETL tools (SSIS), and Birst scripting/modeling Proficiency in Excel, Pivot tables, and SSRS Familiarity with C#, Oracle, and Birst API Ability to troubleshoot data integrity issues across multiple platforms Excellent communication and documentation skills Experience in healthcare or billing analytics is a plus Preferred Languages English - Expert Travel Requirements 5% Physical Demands The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Standing - Occasionally Walking - Occasionally Sitting - Constantly Talking - Occasionally Hearing - Occasionally Repetitive Motions - Frequently ZOLL is a fast-growing company that operates in more than 140 countries around the world. Our employees are inspired by a commitment to make a difference in patients' lives, and our culture values innovation, self-motivation and an entrepreneurial spirit. Join us in our efforts to improve outcomes for underserved patients suffering from critical cardiopulmonary conditions and help save more lives. ZOLL Medical Corporation, an Asahi Kasei Group Company, develops and markets medical devices and software solutions that help advance emergency care and save lives, while increasing clinical and operational efficiencies. With products for defibrillation and monitoring, circulation and CPR feedback, data management, therapeutic temperature management, and ventilation, ZOLL provides a comprehensive set of technologies that help clinicians, EMS and fire professionals, and lay rescuers treat victims needing resuscitation and acute critical care. For more information, visit www.zoll.com. The Asahi Kasei Group is a diversified group of companies led by holding company Asahi Kasei Corp., with operations in the material, homes, and health care business sectors. Its health care operations include devices and systems for acute critical care, dialysis, therapeutic apheresis, transfusion, and manufacture of biotherapeutics, as well as pharmaceuticals and diagnostic reagents. With more than 30,000 employees around the world, the Asahi Kasei Group serves customers in more than 100 countries. For more information, visit www.asahi-kasei.co.jp/asahi/en/.
