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 logisticsoperations, 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 withpartner 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 logisticsand 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 MADentalVision Healthcare Flexible Spending AccountDependent Care Flexible Spending AccountShort Term DisabilityLong Term Disability401K PlanPet insurance Employee Stock Purchase PlanTransMedics 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.SummaryLocation: Andover, MAType: Full time