Senior Engineer – Data Engineering Lead

Job not on LinkedIn

🔥 9 minutes ago

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

PressW

WebsiteLinkedInAll Job Openings

11 - 50 employees

Founded 2023

🤖 Artificial Intelligence

☁️ SaaS

💼 Consulting

Artificial Intelligence • SaaS • Consulting

PressW is an applied AI firm that provides end-to-end AI transformation services: strategy, engineering, and managed AI. They are an Official Anthropic Partner specializing in deploying, managing, and optimizing Claude (Anthropic's model) across enterprises, offering Claude deployment, license management, usage analytics, cost optimization, custom Claude agent development, security/compliance/governance, and ongoing support. PressW serves verticals including Capital (private equity, venture capital, financial services), Technology, Services, and Industrial (regulated environments). They embed with clients to assess AI readiness, develop roadmaps, build production-grade AI systems (applications, pipelines, integrations, embedded pod teams), and provide ongoing managed services and optimization. The company emphasizes rapid time-to-production (90 average days), significant project experience (70+ projects, 30+ companies), and focuses on delivering ROI from AI initiatives.

📋 Description

• 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. This assessment shapes every phase that follows. • Design the clean target schema in collaboration with the Backend Lead and Principal Engineer. Naming conventions, tenancy patterns, partitioning strategy. This is the schema the client lives on after the engagement. • 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. The new code works with clean data models while the old schema remains untouched underneath. You design this layer, build it, benchmark it against production-scale data, and keep it performant throughout the migration. • 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.

🎯 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.

🏖️ Benefits

• PressW is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.