Data Engineer

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

📋 Description

• Take ownership of data workflows from start to finish, encompassing ingestion, storage, orchestration, transformation, validation, and delivery.

• Create and sustain inbound and outbound data transfers utilizing cloud storage, secure file transfer protocols, and various integration techniques.

• Develop and uphold ETL and ELT pipelines through workflow orchestration and event-driven processing.

• Oversee data management across cloud storage, data warehouses, and analytical databases.

• Design and enhance data models, schemas, queries, and transformations.

• Manage custom datasets that support significant clients and partnerships, covering their sources, business definitions, lineage, and downstream dependencies.

• Collaborate with Customer Success, Operations, and Engineering to clarify requirements, investigate discrepancies, and communicate technical constraints and data behavior.

• Implement and uphold data quality checks, automated testing, monitoring, and alerts.

• Troubleshoot production issues across transfers, pipelines, and databases, identifying root causes and applying sustainable fixes.

• Maintain documentation that details data flows, dataset definitions, architectural decisions, and operational recovery procedures.

• Assess technical strategies through research and prototyping, clarifying trade-offs in reliability, performance, cost, and maintainability.

• Enforce access controls and secure data handling practices throughout the data lifecycle.

⛳️ Requirements

• Proficiency in English.

• Experience in constructing, maintaining, and troubleshooting production data pipelines.

• Strong Python capabilities for data processing, automation, and integrations.

• Strong SQL expertise, including complex transformations, query optimization, and diagnosing data inconsistencies.

• Practical knowledge of ETL and ELT patterns, workflow orchestration, and pipeline recovery.

• Experience with cloud object storage and file-based data transfers, including familiarity with SFTP.

• Experience in designing data models and working with relational databases, including schemas, indexes, and query performance.

• Ability to trace data from its source through transformations to downstream outputs, articulating technical behavior and business implications.

• Capacity to independently investigate issues, assess solutions, and substantiate technical recommendations with evidence.

• Clear communication skills with experience in collaborating with both technical and non-technical teams.

• Experience with AWS, particularly Amazon S3 and AWS Lambda (a plus).

• Familiarity with Apache Airflow or a similar orchestration platform (a plus).

• Experience with PostgreSQL, Amazon Redshift, or ClickHouse (a plus).

• Experience managing custom datasets or integrations that support enterprise clients or business partnerships (a plus).

• Familiarity with marketing analytics or first-party customer data (a plus).

🏝️ Benefits

• Remote work.

• Full-time contract via a payroll platform.