Overview
Skills
Job Details
Database Engineer
Overview
We are seeking a skilled Database Engineer with strong Python capabilities to own and manage our data infrastructure. This role is heavily database-focused, with responsibilities across schema design, query optimization, data pipelines, permissions management, and integrations with our backend services. Candidates must be detail-oriented, meticulous, and capable of working independently without the need for hand-holding.
Key Responsibilities
- Manage, optimize, and maintain PostgreSQL/AlloyDB and Cloud SQL databases.
- Design, evolve, and document database schemas used across clinical, operational, and analytics workflows.
- Write complex SQL queries, views, and stored logic to support APIs and internal workflows.
- Refactor legacy database logic into secure and scalable implementations.
- Implement and maintain IAM-based database authentication and role-based access.
- Ensure proper permissions across tables, views, and sequences.
- Debug and resolve permission issues, failed queries, or missing relations.
- Work with IAP tunnels, bastion hosts, and secure connectivity patterns.
- Extract, normalize, and import data from PDF, CSV, and other structured/unstructured sources.
- Develop and maintain Python scripts/services (FastAPI/Flask style) as needed.
- Support backend data flows such as medical profiles, labs, foundations, and pillars endpoints.
- Ensure consistency and correctness of data across tables, views, and microservices.
- Troubleshoot Cloud Run + database connectivity issues.
- Build automated tools to validate schema consistency, test queries, and manage migrations.
Required Skills
- Strong experience with PostgreSQL (query writing, performance tuning, indexing, roles, grants).
- Experience with AlloyDB or Cloud SQL, including IAM authentication.
- Proficiency in Python (SQLAlchemy, psycopg2, REST API development).
- Experience working with secure database connectivity (IAP tunneling, bastion hosts).
- Familiarity with data extraction from PDFs, CSVs, spreadsheets, APIs, and other sources.
- Ability to design normalized schemas and understand complex healthcare/clinical data models.
- Ability to work independently and own tasks end-to-end with minimal supervision.
- Strong debugging skills for both backend code and SQL-level issues.
Preferred Experience
- Experience working in healthcare, clinical systems, or HIPAA-aware environments.
- Familiarity with Google Cloud (Cloud Run, Secret Manager, VPC Access, IAM).
- Experience writing secure and parameterized queries.
- Understanding of ORM patterns and tradeoffs.
- Prior experience refactoring legacy data pipelines.
Additional Expectations
The ideal candidate is detail-oriented, meticulous, capable of extracting data from PDF, CSV, and other formats, and able to work independently without hand-holding. They are responsible and take ownership of their deliverables.