Staff Application Database Architect
at HeartFlow · 501-1000 employees
Convertible Note · $98M · Mar 2025
- Seniority
- Staff Principal
- Location
- San Francisco, California
- Posted
- 5d ago
pythondjangopostgresmysqlredisawssparkairflow
at HeartFlow · 501-1000 employees
HeartFlow provides noninvasive diagnostic software that converts CCTA scans into personalized 3D coronary models to simulate blood flow and generate FFRCT, RoadMap, and plaque analyses for clinician decision-making.
<div class="content-intro"><p>Heartflow is a medical technology company advancing the diagnosis and management of coronary artery disease, the #1 cause of death worldwide, using cutting-edge technology. The flagship product—an AI-driven, non-invasive cardiac test supported by the ACC/AHA Chest Pain Guidelines called the Heartflow FFR<sub>CT </sub>Analysis—provides a color-coded, 3D model of a patient’s coronary arteries indicating the impact blockages have on blood flow to the heart. Heartflow is the first AI-driven non-invasive integrated heart care solution across the CCTA pathway that helps clinicians identify stenoses in the coronary arteries (RoadMap™Analysis), assess coronary blood flow (FFR<sub>CT </sub>Analysis), and characterize and quantify coronary atherosclerosis (Plaque Analysis). Our pipeline of products is growing and so is our team; join us in helping to revolutionize precision heartcare.</p> <p>Heartflow is a publicly traded company (HTFL) that has received international recognition for exceptional strides in healthcare innovation, is supported by medical societies around the world, cleared for use in the US, UK, Europe, Japan and Canada, and has been used for more than 500,000 patients worldwide. </p></div><p>As a Staff Application Database Architect, you will be the backend database expert behind the production applications and web services that power Heartflow's clinical and operational platform. This is a hands-on role: the majority of your time will be spent designing OLTP schemas, writing and tuning high-performance queries, and working directly inside our Python/Django services to solve real data access problems — alongside setting the architectural direction for how clinical, imaging, and operational data is structured, accessed, and governed across our AWS-based platform. Exposure to Data Lake, analytics pipelines, or AI-enablement work is a plus.</p> <h3><strong>Job Responsibilities:</strong></h3> <ul> <li><strong>Design, Build & Own OLTP Database Systems: </strong>Take hands-on ownership of the transactional (OLTP) databases powering Heartflow's clinical and operational applications. Design schemas, write and optimize complex queries, and directly implement performance improvements — indexing, partitioning, connection pooling, caching — for high-throughput, low-latency web services.</li> <li><strong>Drive Application Data Access & ORM Strategy: </strong>Define and implement best practices for how our Python/Django services interact with the database via the Django ORM. Solve real-world problems like N+1 queries, lazy-loading pitfalls, transaction isolation, connection pool exhaustion, and read/write splitting; review and directly contribute to high-impact schema and query changes in application code.</li> <li><strong>Own Database Performance & DBA Excellence: </strong>Set direction for database operations — uptime, capacity, backups, recovery, schema evolution, and incident response. Establish SLOs, observability, and runbooks; partner with engineering and SRE teams to keep mission-critical clinical workloads fast, reliable, and secure.</li> <li><strong>Lead Transactional Data Modeling: </strong>Own conceptual, logical, and physical data models for our operational systems. Drive consistent representation of patients, studies, cases, results, and devices, and steward the master and reference data needed for high-integrity clinical applications.</li> <li><strong>Advance the Semantic Structure for AI Agent Context: </strong>Contribute to enriching Heartflow's transactional data model with semantics — metadata and controlled vocabularies — so AI agents and downstream consumers can reliably retrieve and reason over clinical and operational information.</li> <li><strong>Champion Compliance, Security & Privacy: </strong>Ensure data architectures, flows, and access controls strictly adhere to FDA, HIPAA, GDPR, and other applicable standards. Partner with Quality, Regulatory, InfoSec, and Privacy teams to embed compliance into the data lifecycle by design.</li> <li><strong>Support the Data Lake & Analytics Handoff (minor, bonus scope): </strong>For candidates with the background, partner with IT, Research, and Systems Engineering to ensure OLTP source systems produce clean, well-modeled data that feeds downstream Data Lake and analytics pipelines. This is a supporting responsibility for the right candidate, not a requirement of the role.</li> <li><strong>Advance the Semantic Structure for AI Agent Context (minor, bonus scope): </strong>For candidates with the background, contribute to enriching Heartflow's transactional data model with semantics — metadata and controlled vocabularies — so AI agents and downstream consumers can reliably retrieve and reason over clinical and operational information.</li> </ul> <h3><strong>Skills Needed:</strong></h3> <p><em>You have experience in the following:</em></p> <ul> <li><strong>OLTP Database Engineering (Primary): </strong>Deep, hands-on expertise in relational databases (PostgreSQL, MySQL, Aurora, or equivalent) supporting production web applications — schema design, query optimization, indexing, partitioning, replication, and HA/DR.</li> <li><strong>Application & Web Service Data Access: </strong>Strong experience building backend data layers for web applications and services in Python, with expert-level fluency in SQLAlchemy and/or the Django ORM. Deep understanding of connection pooling, caching (Redis/Memcached), transaction management, and common ORM pitfalls at scale.</li> <li><strong>Data Modeling: </strong>Expert-level conceptual, logical, and physical modeling for transactional/OLTP workloads (3NF or equivalent), including modeling for healthcare/clinical domains.</li> <li><strong>Database Engineering & DBA Leadership: </strong>Performance tuning, partitioning, indexing strategy, replication, HA/DR, and operational excellence for production relational databases.</li