Data Engineer
About the role
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.
What you'll do
Requirements
- 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
About Pearl Talent
Pearl Talent is a talent placement company that recruits remote workers, trains them to work effectively with AI tools, and places them as managed contractors with client companies — across roles ranging from client-facing positions to software engineers and executive assistants. The company is roughly 50 people managing a few hundred placed contractors, growing into new verticals, with clients spanning venture-backed tech and healthcare sectors. They emphasize community-building (events, culture) alongside the placement business itself.
AI Alerts shares third-party job opportunities for informational purposes only. We are not the employer and are not involved in the hiring process. Always verify the company and role through official channels before applying, and never pay to apply, train, onboard, process documents, or secure a job offer. Legitimate employers do not ask applicants for money. Read our Terms to learn more.