Business Intelligence Engineer, Transplant Logistics

Job Description: Transplant Logistics is a recently created organization responsible to lead all aspects of TransMedics’ transplant logistics, enabling the exponential growth of the National OCS Program (NOP). The team’s comprehensive scope includes data analytics, network and topology design, capacity planning, product and program management, and the daily execution of air and ground transplant logistics operations, managed by a world-class central command center operating 24/7. Reporting directly to the Director of Data Analytics, the Business Intelligence Engineer will be responsible for mining, manipulating, and analyzing data from multiple internal and external sources, using analytical and statistical rigor to solve complex problems and drive actionable business decisions. This individual will design, build, and maintain automated reporting, dashboards, and ongoing analysis to enable data-driven decisions across the Transplant Logistics organization and with partner teams. Working closely with the Product, Finance, Logistics, and Tech teams, this position provides the opportunity to influence one of the highest impact areas of TransMedics and organ Transplantation in the US and worldwide. The ideal candidate for this role is an innovative, highly motivated, and selfstarter BIE, comfortable with ambiguity, with strong attention to detail, and experience with logistics and network topology. ESSENTIAL TASK AND DUTIES INCLUDE: Mine, manipulate, and analyze data from multiple internal and external sources, reporting key actionable insights using statistical rigor to inform the larger organization of noteworthy trends that impact the business. Develop deep-dive tools, UIs, metrics, and QuickSight automated dashboards to give visibility into key measures of logistics performance. Partner with the Product, Finance, Logistics, Clinical, and Tech teams to gather requirements, create reporting, and drive analytic projects that help solving complex logistics challenges. Constantly investigate and support implementation of new big data technologies to provide automated solutions to address the evolving Transplant Logistics needs. Support the ongoing design of the NOP logistics network. Perform other TransMedics task and duties as required. BACKGROUND AND QUALIFICATIONS: 5+ years of professional experience. Advanced SQL skills and experience in scripting for automation (e.g., Python). Experience programming to extract, transform, and clean large (multi-TB) datasets. Experience building KPIs and developing automated dashboards and reporting solutions. Experience with data visualization using Tableau, Power BI, QuickSight, Smartsheet, and other similar tools. Expert level Excel skills, including knowledge of VBA, Macros, Pivot Charts, and Statistical Modeling. Knowledge of data modeling, machine learning, relational databases, Python, and Geospatial data processing. Experience working directly with business stakeholders, being able to seamlessly navigate between data and business needs. Self-starter, driver, and out-of-the-box thinker with a strong attention to detail and comfortable with ambiguity. "Can do" attitude, willingness to roll up sleeves up with a drive to win. Ability to work independently with minimal supervision and collaborate with team mates and cross-functional colleagues. Strong business ethics. EDUCATION: BS in computer science, engineering, economics, math, or related field. Master's degree in statistics, data science, or an equivalent quantitative field is a highly valued. Employee Benefit: Medical with Health Reimbursement Account through Blue Cross/Blue Shield of MA Dental Vision Healthcare Flexible Spending Account Dependent Care Flexible Spending Account Short Term Disability Long Term Disability 401K Plan Pet insurance Employee Stock Purchase Plan TransMedics is an equal opportunity employer and does not discriminate on the basis of race, color, religion, sex, national origin, marital status, age, disability or protected veteran status, or any other characteristic protected by law. We are committed to creating an inclusive environment for all employees. Welcome to TransMedics Careers! Our Vision is to help save more patients' lives by becoming the trusted partner to transplant stakeholders worldwide and delivering the highest quality technology, service and clinical care. TransMedics Group, Inc. (TMDX) is a commercial-stage medical technology company transforming organ transplant therapy for end-stage organ failure patients across multiple disease states. We developed the Organ Care System, or the OCS™, to replace a decades-old standard of care that we believe is significantly limiting access to life-saving transplant therapy for hundreds of thousands of patients worldwide. Our innovative OCS technology replicates many aspects of the organ’s natural living and functioning environment outside of the human body. As such, the OCS represents a paradigm shift that transforms organ preservation for transplantation from a static state to a dynamic environment that enables new capabilities, including organ optimization and assessment. In concert with our OCS technology platform and OCS Connect™ app, which enables TransMedics and transplant clinicians to efficiently track, coordinate & communicate resource logistics for donor organs procured and maintained on OCS™, TMDX launched its National OCS™ Program (NOP) in 2022: 16 regional hubs across the U.S. staffed by a dispersed workforce of experienced, on-staff OCS Perfusion Specialists & Cardiothoracic and Abdominal Donor Procurement Surgeons. These resources are mobilized on-demand via our own dedicated ground & aviation transportation logistics network, to retrieve and deliver allocated donor organs from anywhere in the U.S. – aiding U.S. Transplant Centers in bidding farewell to the time & distance limitations of cold storage & expand the pool of viable donor organs for their transplant recipients.