Data Integration Engineer — ETL & GCP Specialist

Applaudo; México; Presencial; MXN 900.000 - 1.300.000; Jornada completa

Descripción de la vacante

Applaudo is seeking an experienced Data Engineer who enjoys building reliable integrations and transforming complex data into accurate, accessible, and actionable information. You will design and maintain production ETL pipelines using TypeScript/Node.js and Python, integrating REST APIs and cloud data services.

You will join an established codebase, follow existing patterns, and contribute to monitoring, troubleshooting, and operational support while collaborating asynchronously with an

Formación

• 5+ years of professional experience in data engineering, integration development, or related roles.
• Production experience building ETL or 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

• Building and maintaining ETL pipelines between Zuora REST APIs and a GCP data warehouse.
• Developing and maintaining integration components using TypeScript/Node.js and Python.
• Managing transformation logic for billing events, subscription lifecycles, invoices, payments, and revenue data.
• Working within the existing architecture, development patterns, conventions, and CI/CD workflows.
• Developing data pipelines using GCP services such as BigQuery, Cloud Storage, Dataflow, and Pub/Sub.
• Implementing pipeline monitoring, alerting, error handling, retry logic, and data-quality controls.
• Writing complex SQL validation queries to verify data parity between source data and warehouse tables.
• Collaborating with the Business Architect to implement data-validation requirements.
• Investigating pipeline failures, data discrepancies, and integration issues.
• Supporting accurate and reliable data movement across source systems and warehouse environments.
• Providing clear written updates and collaborating effectively within a distributed, async-first team.
• Participating in the established Agile/Kanban workflow.

Conocimientos

TypeScript/Node.js

Python

GCP

REST APIs

OAuth 2.0

SQL

Data Warehouse

Data Transformation

CI/CD

Monitoring & Troubleshooting

Async Collaboration

English Communication

Zuora REST APIs

dbt

Data Quality Validation

Herramientas

dbt

Descripción del empleo

Applaudo is seeking an experienced Data Engineer who enjoys building reliable integrations and transforming complex data into accurate, accessible, and actionable information. You will design and maintain production ETL pipelines using TypeScript/Node.js and Python, integrating REST APIs and cloud data services.

You will join an established codebase, follow existing patterns, and contribute to monitoring, troubleshooting, and operational support while collaborating asynchronously with an