Senior Data Engineer — ETL Pipelines & GCP Expert

Applaudo; United States; Remote; USD 120,000 - 180,000; Full time

Job summary

Applaudo is seeking an experienced Data Engineer to design and maintain production ETL pipelines connecting Zuora REST APIs to a GCP data warehouse. You will implement data transformation logic, ensure data quality, and support reliable data movement across source systems.

You will work within existing architectures and CI/CD practices while collaborating asynchronously with an international team. The role emphasizes hands-on development in TypeScript/Node.js and Python, with strong SQL skills

Qualifications

• 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.

Responsibilities

• 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.

Skills

ETL pipelines

TypeScript/Node.js

Python

GCP BigQuery

GCP Dataflow

Pub/Sub

REST APIs

OAuth 2.0

SQL

Data quality validation

CI/CD

Async-first collaboration

English communication

Tools

dbt

Zuora REST APIs

ZOQL

Git & CI/CD tooling

Job description

Applaudo is seeking an experienced Data Engineer to design and maintain production ETL pipelines connecting Zuora REST APIs to a GCP data warehouse. You will implement data transformation logic, ensure data quality, and support reliable data movement across source systems.

You will work within existing architectures and CI/CD practices while collaborating asynchronously with an international team. The role emphasizes hands-on development in TypeScript/Node.js and Python, with strong SQL skills