Senior Engineer – Data Engineering Lead
P
PressWAI Engineering
Remote, United StatesFull-TimeSenior
Salary not disclosed
Apply NowOpens the employer's application page
Job Details
- Experience
- 7+ years of data engineering experience
- Required Skills
- AWSPostgreSQLPythonSQL
Requirements
- 7+ years of data engineering experience. Strong Python and SQL.
- Deep PostgreSQL expertise beyond writing good queries. You have built and maintained views, materialized views, and complex schema migration strategies in production. Aurora PostgreSQL experience strongly preferred.
- Hands-on experience with a large migration or rebuild where two systems ran in parallel and data had to stay consistent across both.
- Experience designing schemas from degraded or legacy starting points, with an understanding of how to build translation layers that let new code work cleanly while the old schema remains untouched.
- Production AWS experience, particularly Aurora and related data services.
- Must have shipped meaningful work in the last 2 years.
- Healthcare data, HIPAA, PHI handling (Preferred).
- Experience with additive-only migration strategies (no destructive schema changes while legacy system is still active) (Preferred).
- Event-driven architectures and streaming (Kafka) (Preferred).
- SQLAlchemy and Alembic experience (Preferred).
- AI-assisted development workflows (Claude Code, agent frameworks, MCP) (Preferred).
Responsibilities
- Lead the database schema assessment early in the engagement. Map the full legacy data model, identify structural problems (circular references, denormalized tables, missing constraints), and classify tables by access patterns.
- Design the clean target schema in collaboration with the Backend Lead and Principal Engineer. Naming conventions, tenancy patterns, partitioning strategy.
- Build and own the translation layer between the legacy schema and the new backend: PostgreSQL views and materialized views for reads, write mapper modules for writes.
- Own the data contract between old and new systems. The Backend Lead builds against the interfaces you provide. You are responsible for ensuring data consistency while both systems are running.
- Plan and execute the per-tenant data cutover from legacy schema to the target schema, with verification gates at each stage and rollback safety throughout.
- Own database performance tuning during the migration: read replica strategy, capacity projections, and managing elevated load during the dual-system period.
- Instrument data quality, lineage, and audit capabilities sufficient for a healthcare context.
- Mentor engineers on the team on data fundamentals.
View Full Description & ApplyYou'll be redirected to the employer's site
