Data Engineer

Job not on LinkedIn

🔥 12 hours 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

Catena

WebsiteLinkedInAll Job Openings

1 - 10 employees

👥 HR Tech

🏢 Enterprise

🎯 Recruiter

HR Tech • Enterprise • Recruitment

Catena, now known as Pearl Talent, is a company that specializes in helping organizations hire top remote talent from overseas, primarily focusing on candidates from the Philippines and Latin America. They offer a rigorous vetting process to ensure they provide highly capable candidates equipped with modern software skills and fluent English proficiency. Pearl Talent provides two main hiring services: Managed Services, which handles compliance, payroll, and training, and Direct Placement for companies that manage hires internally. They focus on long-term retention and quality in their hiring processes, aiming to build high-performing remote teams for a range of industries including healthcare, real estate, and finance.

📋 Description

• Work From Anywhere in LATAM and the Philippines • Design clean schemas, write efficient SQL, and optimize Postgres performance • Extend and evolve the Postgres schema across recruiting, candidates, and business operations • Build SQL views and derived tables for reporting and AI • Optimize query performance through indexing, partitioning, and execution-plan analysis • Complete schema audit with top-priority fixes shipped and measurable performance gains within the first 3-6 months

🎯 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

🏖️ Benefits

• Competitive Salary: Based on experience and skills • Remote Work: Fully remote—work from anywhere • Generous PTO: In accordance with company policy • Health Coverage for PH-based talents: HMO coverage after 3 months for full-time employees • Direct Mentorship: Guidance from international industry experts • Learning & Development: Ongoing access to resources for professional growth • Global Networking: Connect with professionals worldwide