Data Integration Engineer
Posted 3hrs ago
Employment Information
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















