Senior Data Integration Engineer – ETL & Cloud Pipelines

Applaudo; Colombia; Presencial; COP 120.000.000 - 160.000.000; Jornada completa

Descripción de la vacante

Applaudo is seeking an experienced Data Engineer to build reliable integrations and transform complex data into accurate, actionable information. You will own production ETL pipelines using TypeScript/Node.js and Python, integrating REST APIs, and leveraging cloud data platforms.

Join an established codebase, follow CI/CD patterns, monitor pipelines, and ensure reliability with async-first collaboration across an international team. Overlap with Pacific Time is required.

Formación

• 5+ years of professional experience in data engineering, integration development, or related roles.
• Production ETL/data-integration pipelines using TypeScript and Node.js.
• Strong Python experience focused on data-pipeline development.
• Hands-on experience with GCP services, including BigQuery, Cloud Storage, Dataflow, and Pub/Sub.
• Experience integrating REST APIs using OAuth 2.0, pagination, error handling, and retry mechanisms.
• Advanced SQL skills and experience working with complex data warehouse schemas.
• Experience developing data-transformation logic and data-quality validations.
• Understanding of pipeline monitoring, alerting, failure recovery, and operational support.
• Experience working within established architectures, coding conventions, and CI/CD workflows.
• Ability to onboard independently and become productive within an existing codebase.
• Strong written communication skills and an async-first collaboration style.
• Working English proficiency for daily collaboration with an international team.
• Availability to overlap with Pacific Time, primarily between 10:00 a.m. and 2:00 p.m. PT.

Responsabilidades

• Build and maintain ETL pipelines between Zuora REST APIs and a GCP data warehouse.
• Develop and maintain integration components using TypeScript/Node.js and Python.
• Manage transformation logic for billing events, subscription lifecycles, invoices, payments, and revenue data.
• Work within the existing architecture, development patterns, conventions, and CI/CD workflows.
• Develop data pipelines using GCP services such as BigQuery, Cloud Storage, Dataflow, and Pub/Sub.
• Implement pipeline monitoring, alerting, error handling, retry logic, and data-quality controls.
• Write complex SQL validation queries to verify data parity between source data and warehouse tables.
• Collaborate with the Business Architect to implement data-validation requirements.
• Investigate pipeline failures, data discrepancies, and integration issues.
• Support accurate and reliable data movement across source systems and warehouse environments.
• Provide clear written updates and collaborate effectively within a distributed, async-first team.
• Participate in the established Agile/Kanban workflow.

Conocimientos

Data engineering

ETL pipelines

Node.js TypeScript

Python

GCP BigQuery

OAuth 2.0

SQL

Data quality

Monitoring & alerts

CI/CD

Async collaboration

English communication

Pacific Time overlap

Herramientas

dbt

Zuora REST API

GitHub Actions

BigQuery data tooling

Descripción del empleo

Applaudo is seeking an experienced Data Engineer to build reliable integrations and transform complex data into accurate, actionable information. You will own production ETL pipelines using TypeScript/Node.js and Python, integrating REST APIs, and leveraging cloud data platforms.

Join an established codebase, follow CI/CD patterns, monitor pipelines, and ensure reliability with async-first collaboration across an international team. Overlap with Pacific Time is required.