Pearl Talent - Data Engineer (Ciudad de México)

Pearl Talent - Data Engineer (Ciudad de México)

14 ago
|
Pearl
|
Ciudad de México

14 ago

Pearl

Ciudad de México

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.
Hear why we exist, what we believe in, and who we're building for:
Watch here: https://www.loom.com/share/863b8e426e6d48309aa8f4ea4c1c94cd
Benefits
Build and Grow Quickly - We’re scaling fast, and we trust that you’ll know best on the ground what needs to be done. 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.
Integral 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.

📌 Pearl Talent - Data Engineer (Ciudad de México)
🏢 Pearl
📍 Ciudad de México

Postulate a este anuncio

Muestra tus habilidades a la empresa, rellenar el formulario y deja un toque personal en la carta, ayudará el reclutador en la elección del candidato.

Suscribete a esta alerta:

Recibe por email las nuevas ofertas de trabajo para: pearl talent - data engineer (ciudad de méxico) / ciudad de méxico

Suscribete a esta alerta:

Recibe por email las nuevas ofertas de trabajo para: pearl talent - data engineer (ciudad de méxico) / ciudad de méxico