Data Engineer - I052

Work From Anywhere in LATAM and the Philippines Work Schedule: 9:00 AM – 6:00 PM PST (EasternTime) An AI-powered recruiting platform is building the database layer behind its operational systems, reporting, and AI features, and is looking for a Database Engineer to design clean schemas, write efficient SQL, and make Postgres do more with less. The company runs a production Postgres backend powering its applicant tracking system, fed by webhook-driven ingestion from external hiring tools via serverless workers and queues. As it scales, it is investing in the database foundation that will support reporting and AI consumers, and the role pairs closely with the Engineering team (which owns ingestion) and AI Engineering (which consumes datasets). Day-to-day, the Database Engineer extends and evolves the Postgres schema across recruiting, candidates, and business operations, builds SQL views and derived tables that serve as the standard interface for reporting and AI, and optimizes query performance through indexing, partitioning, and execution-plan analysis. Success in the first 3–6 months means a completed schema audit with top-priority fixes shipped, measurable p95 gains on key dashboard queries, and column-level PII classification aligned to retention policy. Requirements Must-Have 3+ years working with production PostgreSQL databases Advanced SQL: window functions, CTEs, JSONB, EXPLAIN analysis, and query rewriting for performance Relational data modeling for both OLTP and analytical use cases, including materialized views, indexing, and partitioning on OLTP Postgres Defining and enforcing PII, data-classification, and retention policies at the database level Git-based schema-migration workflows (Flyway, sqitch, or comparable) with PR review Basic Python or comparable scripting for one-off data operations and validation B2+ English (CEFR) for technical documentation read across teams Nice-to-Have Experience with Supabase (RLS, auth model, Realtime, Storage) Experience with dbt or SQLMesh for versioning SQL transformations Prior work exposing datasets to AI/ML consumers (feature datasets, embedding indexes, eval sets) About Pearl Talent Pearl works with the top 1% of candidates from around the world and connects them with the best startups in the US and EU. Our clients have raised over $5B in aggregate and are backed by companies like OpenAI, a16z, and Founders Fund. They're looking for the sharpest, hungriest candidates who they can consistently promote and work with over many years. Candidates we've hired have been flown out to the US and EU to work with their clients, and even promoted to roles that match folks onshore in the US. You’ll have the opportunity to step into leadership early and own decisions that shape how our company grows. Fully Remote. Forever. - We’ve built Pearl with a multicultural DNA and teammates across 23 countries. We trust that the best work isn’t done behind a cubicle Unlimited PTO - We trust that you’ll get your work done, and we want to create space for you to take time away with the people you care about. Global Retreats - We create space for our teammates to get to know each other as people, rather than just to-do lists. We’ve shared meals, laughs, and sunrises across the world in places like Cancun, El Nido, Boracay, and Siargao**.** Ambitious and Kind Team - We build with the most competent people we know, and we maintain a low-ego, no-assholes policy. We’re looking for people who are sharp, kind, and open to being vulnerable when it matters.