Business Intelligence Engineer, Transplant Logistics

TransMedics; Andover (MA); On-site; USD 110,000 - 150,000; Full time

Benefits offered by this job

Medical with Health Reimbursement

Dental

Vision

Healthcare FSA

Dependent Care FSA

Short Term Disability

Long Term Disability

401K Plan

Pet insurance

Employee Stock Purchase Plan

Job summary

TransMedics is seeking a skilled Business Intelligence Engineer to mine, analyze, and organize data from multiple sources. You will design automated reporting, dashboards, and ongoing analyses to support decision-making across Transplant Logistics, collaborating with Product, Finance, Logistics, Clinical, and Tech teams.

You will build KPI-focused dashboards using Tableau, Power BI, and QuickSight, leveraging advanced SQL and Python to address complex logistics challenges.

Qualifications

• 5+ years of professional experience.
• Advanced SQL skills and Python scripting.
• Experience with large multi-TB datasets.
• Experience building KPIs and automated dashboards.
• Experience with data visualization tools (Tableau, Power BI, QuickSight).
• Expert Excel skills including VBA/macros and pivot charts.
• Knowledge of data modeling, ML, relational DBs, Python, and geospatial data.
• Experience collaborating with business stakeholders.

Responsibilities

• Mine, manipulate, and analyze data from multiple sources to reveal actionable insights with statistical rigor.
• Develop dashboards and metrics, including QuickSight dashboards for visibility into logistics performance.
• Collaborate with Product, Finance, Logistics, Clinical, and Tech to gather requirements and drive analytics projects.
• Investigate and implement new big data technologies to automate Transplant Logistics needs.
• Support the design of the NOP logistics network.
• Perform other tasks as required.

Skills

Advanced SQL

Python scripting

Data analysis

KPI development

Dashboards

Tableau

Power BI

QuickSight

Smartsheet

Excel VBA

Pivot charts

Statistical modeling

Geospatial data

Machine learning

Stakeholder management

Self-starter

Education

BS in computer science, engineering, economics, math, or related field

Master's degree in statistics, data science, or quantitative field

Tools

Tableau

Power BI

QuickSight

Smartsheet

Excel

VBA

Macros

Pivot charts

Job description

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 employ