Data Engineer
New
P
Pearl TalentData Engineering
Central Luzon, Philippines. Eastern Visayas, Philippines. Mimaropa, Philippines. Mexico City, Mexico City, Mexico. Bogotá, Bogota, Colombia. São Paulo, State of São Paulo, Brazil, 9:00 AM – 6:00 PM PST (EasternTime)Full-TimeMiddle
Salary not disclosed
Apply NowOpens the employer's application page
Job Details
- Languages
- B2+ English (CEFR)
- Experience
- 3+ years
- Required Skills
- PostgreSQLPythonSQLGitData engineering
Requirements
- 3+ years working with production PostgreSQL databases.
- Advanced SQL skills: window functions, CTEs, JSONB, EXPLAIN analysis, and query rewriting.
- Relational data modeling for OLTP and analytical use cases, including materialized views, indexing, and partitioning.
- Experience defining and enforcing PII, data-classification, and retention policies at the database level.
- Proficiency with Git-based schema-migration workflows (e.g., Flyway, sqitch).
- Basic Python or comparable scripting for data operations and validation.
- B2+ English (CEFR) proficiency for technical documentation.
- Nice-to-have: Experience with Supabase, dbt or SQLMesh, and exposing datasets to AI/ML consumers.
Responsibilities
- Extend and evolve the Postgres schema across recruiting, candidates, and business operations.
- Build SQL views and derived tables to serve as interfaces for reporting and AI.
- Optimize query performance using indexing, partitioning, and execution-plan analysis.
- Define and enforce PII, data-classification, and retention policies at the database level.
- Collaborate with Engineering and AI Engineering teams to support data ingestion and consumption.
View Full Description & ApplyYou'll be redirected to the employer's site
