Data Integration Engineer

About the role

Applaudo Studios, an AI-native company building AI-powered solutions, is hiring a Data Integration Engineer in Lima. The engineer builds and maintains ETL pipelines that move data from Zuora REST APIs to a GCP data warehouse, works in a distributed, async-first team and overlaps with Pacific Time mainly between 10:00 a.m. and 2:00 p.m. PT.

Key responsibilities

• Build and maintain ETL pipelines between Zuora REST APIs and a GCP data warehouse.
• Develop and maintain integration components in 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 pipelines using GCP services such as BigQuery, Cloud Storage, Dataflow and Pub/Sub.
• Implement monitoring, alerting, error handling, retry logic and data-quality controls.
• Write complex SQL validation queries to check data parity between sources and warehouse tables.
• Collaborate with the Business Architect on data-validation requirements and investigate pipeline failures and data discrepancies.
• Provide clear written updates and follow the established Agile/Kanban workflow.

Required profile

• 5+ years of professional experience in data engineering, integration development or related roles.
• Ability to join an established codebase, follow existing patterns and CI/CD workflows, and become productive with minimal guidance.
• Strong written communication and an async-first collaboration style; working English for an international team.
• Availability to overlap with Pacific Time, mainly 10:00 a.m. to 2:00 p.m. PT.

Required skills

• Production ETL pipelines with TypeScript/Node.js and strong Python for data pipelines.
• GCP services: BigQuery, Cloud Storage, Dataflow and Pub/Sub.
• REST API integration with OAuth 2.0, pagination, error handling and retries.
• Advanced SQL and data-quality validations.
• Plus: Zuora REST APIs and ZOQL, dbt or similar frameworks, GCP Professional Data Engineer certification.