Senior Data Engineer (GCP & Data Integration)

About the role

Applaudo Studios is looking for a hands-on Senior Data Engineer to build and maintain reliable, scalable data pipelines and integrations across cloud environments. The role covers API integrations, transformation logic, cloud-based pipelines and warehouse validation, and suits someone who can join established environments and become productive with minimal guidance.

Key responsibilities

• Build, maintain and enhance production ETL pipelines connecting REST APIs with GCP-based data warehouse environments.
• Develop data integration components using TypeScript/Node.js and Python within an existing pipeline architecture.
• Use GCP services such as BigQuery, Cloud Storage, Dataflow and Pub/Sub to develop data pipelines.
• Implement transformation logic for billing events, subscription lifecycle data, revenue data and other data flowing into the warehouse.
• Maintain REST API integrations, including authentication, pagination, error handling and retries.
• Support pipeline monitoring and reliability through alerting, logging, error handling, retry mechanisms and data quality checks.
• Write complex SQL queries for source-to-warehouse validation, reconciliation and parity checks, and work with architecture stakeholders on warehouse-level validation requirements.
• Investigate and resolve data pipeline, integration, transformation and data quality issues.
• Follow coding standards, architecture patterns, CI/CD workflows and development practices, and collaborate with Data Engineering leadership.
• Provide clear written updates in an async-first, distributed team and contribute to Agile/Kanban workflows.

Required profile

• Bachelor's degree in Computer Science, Software Engineering, Data Engineering, Information Systems or a related field, or equivalent professional experience.
• 6+ years of experience in Data Engineering, ETL, Data Integration or a closely related field.
• Ability to understand and work within an existing architecture, coding patterns and CI/CD workflows.
• Strong written communication and working English for collaboration with US-based stakeholders.
• Nice to have: Zuora REST API experience, ZOQL or Zuora billing data model knowledge, dbt experience, and GCP Professional Data Engineer certification.

Required skills

• TypeScript/Node.js in production ETL or data integration environments.
• Python for production data pipelines with Dataflow, Airflow or Cloud Composer.
• GCP data services: BigQuery, Cloud Storage, Dataflow, Pub/Sub.
• REST API integrations including OAuth 2.0 authentication.
• Advanced SQL for complex queries across warehouse schemas.