Business Intelligence Engineer, Transplant Logistics

Job Description: ROLE BACKGROUND The transplant logistics team at TransMedics manages the air and ground transport network that powers the National OCS Program (NOP) to deliver donor organs safely and on time. 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. The Transplant Logistics Data Analytics team utilizes analytical, statistical, and programming skills to collect, analyze, and interpret large datasets, building complex transportation network models that enable the multi-year organ transplantation network growth in a scalable and cost-efficient manner. The team also leads the design and development of a unified enterprise Data Platform, consolidating Logistics, Operations, Sales, and Finance data for cross-functional use. Working closely with the senior members and executive leadership of 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 self-starter, comfortable with ambiguity, with strong attention to detail, and experience with logistics and network topology at functional level and strong programming skills at technical level. This role blends business intelligence with significant data engineering responsibilities. 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 automated dashboards in Power BI/Tableau 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 solve complex logistics challenges. Oversee the design and management of data pipelines (ETL) into Redshift and Snowflake, coordinating with external engineering partners. Investigate and support the implementation of new big-data and AI technologies to provide automated solutions to address the evolving Transplant Logistics needs. Support the ongoing design of the NOP logistics network. Perform other TransMedics tasks and duties as required. BACKGROUND AND QUALIFICATIONS: 5+ years of professional experience. Advanced SQL skills and experience in scripting for automation in Python. Experience building KPIs and developing automated dashboards and reporting solutions in Power BI and/or Tableau. Expert level Excel skills, including knowledge of VBA, Macros, Pivot Charts, and statistical modeling. Knowledge of data modeling, relational databases, and geospatial data processing. Hands-on experience with ETL pipeline design and cloud data platforms (Snowflake, Redshift), with the ability to define technical requirements, review data engineering deliverables, and ensure data quality at scale. Experience working directly with business stakeholders, being able to seamlessly navigate data and business needs. Self-starter, driver, and out-of-the-box thinker with strong attention to detail and comfortable with ambiguity. "Can do" attitude, willingness to roll up sleeves with a drive to win. Ability to work independently with minimal supervision and collaborate with teammates and cross-functional colleagues. Strong business ethics. BONUS SKILLS: Experience building or integrating AI-driven solutions, with working knowledge of LLMs, transformer architecture, RAG patterns, and agentic workflows. Experience with mathematical optimization techniques such as linear and mixed-integer programming (LP/MILP), using tools like Gurobi, CPLEX, Pyomo…

View the full posting and apply