Senior Data Engineer

This is a fully remote position, open to applicants in Latin America.

📋 Description

• Create and execute contemporary semantic models, encompassing facts, dimensions, and metric stores utilizing tools like dbt.

• Simplify complex operational databases to facilitate AI querying and analytical use.

• Develop curated, high-performance analytical views and establish production ELT/ETL pipelines.

• Optimize data retrieval processes, enhance data freshness, and reduce redundancy across various environments.

• Refine intricate database queries, indexing, and schema definitions through systematic query log analysis.

• Enforce detailed data governance, including RBAC, RLS, dynamic data masking, and anonymization to protect PII.

• Work collaboratively with cross-functional AI engineering teams on RAG and Agentic AI workflows.

• Specify pipeline monitoring, continuous data quality assessments, and automated alert systems.

• Ensure reliability across all analytical layers.

⛳️ Requirements

• Over 4 years of dedicated experience in data engineering.

• Proficient in SQL at a production level, including Azure SQL, PostgreSQL, or modern Cloud Data Warehouses.

• Strong knowledge of Kimball dimensional modeling.

• Experience in constructing resilient ELT/ETL pipelines.

• Familiarity with structuring semantic/metrics layers using dbt.

• Documented experience in implementing rigorous database security policies, fine-grained RBAC/RLS, and dynamic data masking for PII compliance.

• Hands-on experience in optimizing queries for low-latency workloads.

• Background in supporting data foundations for RAG applications and Agentic AI frameworks.

• Demonstrated technical independence and a proactive problem-solving approach.

• A collaborative mindset to drive execution within nearshore agile teams.

• Required: Advanced/Fluent proficiency in English, both written and spoken.

• Preferred: Experience with Airflow, Prefect, Dagster, pgvector, Pinecone, Qdrant, Kafka, Kinesis, and Terraform.

🏝️ Benefits

• 100% Remote position as a USA Contractor.

• Competitive salary (USD).

• Paid Holidays and Paid Time Off.

• Health insurance assistance program.

• Chance to collaborate with high-growth U.S.-based companies and innovative tech stacks.

• Access to Agentic AI tools and training.

• Coursera Enterprise access.

• Practical studio practice labs.

• Comprehensive onboarding experience.

• Open communication from leadership.

• Recognition within the community.

• Emphasis on psychological safety.

• Continuous multi-project pipeline.

• Direct involvement with U.S. client teams and their roadmaps.