Data Integration Engineer

Posted 3hrs ago

Employment Information

Education
Salary
Experience
Job Type

Report this job

Job expired or something wrong with this job?

Job Description

Data Integration Engineer building reliable Zuora-to-GCP ETL pipelines with TypeScript, Python, and advanced SQL. Supporting accurate billing-data transformations, validation, monitoring, and recovery for Applaudo’s AI-native solutions.

Responsibilities:

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

Requirements:

  • 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 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 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
  • Experience with Zuora REST APIs and ZOQL is a plus
  • Knowledge of the Zuora billing object model, including subscriptions, invoices, and payments, is a plus
  • Experience using dbt or similar data-transformation frameworks is a plus
  • GCP Professional Data Engineer certification is a plus

Benefits:

  • Remote work option
  • Distributed, async-first collaboration environment
  • Opportunity to work with modern AI-native technologies and scalable products
  • Learning and growth opportunities
  • Agile/Kanban workflow