Senior Data Engineer (GCP & Data Integration)

Applaudo; Ciudad de México; Presencial; MXN 900.000 - 1.300.000; Jornada completa

Descripción de la vacante

Applaudo is seeking a hands-on Senior Data Engineer in Mexico City to design and operate reliable data pipelines across cloud environments. You will own ETL and data integration tasks, work with REST APIs, and implement complex SQL checks to ensure data quality in our GCP-based warehouse.

The role requires 6+ years in data engineering, strong TS/Node.js and Python proficiency, and experience with BigQuery, Dataflow, Pub/Sub, and robust CI/CD practices.

Formación

• 6+ years of Data Engineering, ETL, or Data Integration experience.
• Strong hands-on TypeScript/Node.js in production ETL environments.
• GCP data services experience including BigQuery, Cloud Storage, Dataflow, Pub/Sub.
• REST API integrations with OAuth 2.0, pagination, error handling, retries.
• Advanced SQL for data validation across warehouse schemas.

Responsabilidades

• Build, maintain, and enhance production ETL pipelines linking REST APIs with a GCP data warehouse.
• Develop data integration components using TypeScript/Node.js and Python.
• Create pipelines using BigQuery, Cloud Storage, Dataflow, and Pub/Sub.
• Implement transformation logic for billing events and subscription data.
• Maintain REST API integrations with robust auth, pagination, and retries.
• Monitor reliability with alerts, logging, and data quality checks.
• Write complex SQL for source-to-warehouse validation and reconciliation.
• Collaborate with architecture stakeholders on validation requirements and SQL checks.

Conocimientos

TypeScript/Node.js

Python

SQL

REST API

Data pipelines

Educación

Bachelor’s Degree in CS/SE/Data Eng

Herramientas

GCP (BigQuery, Cloud Storage, Dataflow, Pub/Sub)

CI/CD

dbt

Zuora REST API

Descripción del empleo

You are a hands-on Senior Data Engineer who enjoys building reliable, scalable data pipelines and integrations across cloud environments. You are comfortable working across different layers of the data ecosystem, from API integrations and transformation logic to cloud-based pipelines and warehouse validation, and you bring the technical depth needed to troubleshoot issues across the full data flow.

You are comfortable joining established environments, understanding existing architecture and coding patterns, and becoming productive without requiring extensive guidance. You take ownership of your work, communicate clearly in distributed teams, and bring a thoughtful, detail-oriented approach to data reliability, integration challenges, and production engineering.

You Bring to Applaudo the Following Competencies:

• Bachelor’s Degree in Computer Science, Software Engineering, Data Engineering, Information Systems, or a related field is desired, or equivalent professional experience.
• 6+ years of professional experience in Data Engineering, ETL, Data Integration, or a closely related field.
• Strong hands-on experience with TypeScript/Node.js in production ETL or data integration environments.
• Hands-on experience with GCP data services, including BigQuery, Cloud Storage, Dataflow, and Pub/Sub.
• Proven experience building and maintaining REST API integrations, including OAuth 2.0 authentication, pagination, error handling, and retry logic.
• Advanced SQL skills, including complex queries across warehouse schemas for data validation, reconciliation, and analysis.
• Experience working with data transformation logic and production data pipelines.
• Ability to understand and work within an existing architecture, following established coding patterns, conventions, and CI/CD workflows.
• Strong troubleshooting and problem-solving skills across data pipelines, integrations, and cloud environments.
• Strong written communication skills and the ability to provide clear updates in an async-first, distributed environment.
• Self-directed approach to onboarding, with the ability to become productive within an existing codebase with minimal guidance.
• Working English proficiency for collaboration with US-based stakeholders and distributed teams.

Nice to Have:

• Professional experience working with the Zuora REST API.
• Experience with ZOQL or Zuora’s billing data model, including subscriptions, invoices, and payments.
• Experience with dbt or similar data transformation frameworks.
• GCP Professional Data Engineer certification.

You Will Be Accountable for the Following Responsibilities:

• Build, maintain, and enhance production ETL pipelines connecting REST APIs with GCP-based data warehouse environments.
• Develop and maintain data integration components using TypeScript/Node.js and Python within an existing pipeline architecture.
• Develop data pipelines using GCP services such as BigQuery, Cloud Storage, Dataflow, and Pub/Sub.
• Implement transformation logic for billing events, subscription lifecycle data, revenue data, and other data flowing into the GCP data warehouse.
• Develop and maintain REST API integrations, including authentication, pagination, error handling, retries, and reliable data extraction.
• Support pipeline monitoring and reliability through alerting, logging, error handling, retry mechanisms, and data quality checks.
• Write complex SQL queries to support source-to-warehouse data validation, reconciliation, and parity checks.
• Collaborate with architecture stakeholders on warehouse-level validation requirements and translate them into SQL checks and reconciliation logic.
• Investigate and resolve data pipeline, integration, transformation, and data quality issues.
• Follow established coding standards, architecture patterns, CI/CD workflows, and development practices within the existing codebase.
• Collaborate with Data Engineering leadership for technical direction while maintaining ownership of assigned development work.
• Provide clear written status updates, surface blockers early, and communicate progress effectively within an async-first distributed team.
• Contribute to Agile/Kanban workflows while remaining focused on hands‑on engineering execution.

Qualifications

• 6+ years of Data Engineering, ETL, or Data Integration experience.
• Strong production experience with TypeScript/Node.js and Python.
• Hands‑on experience building data pipelines with GCP.
• REST API integration and advanced SQL experience.
• Experience working with production data pipelines and existing architectures.

Additional Information

About Us

We Are Engineered Different.

At Applaudo, talented people design, build, and scale meaningful, AI‑powered solutions that create real business impact. As an AI‑native organization, we collaborate across design, development, cloud, data, and artificial intelligence to turn ideas into scalable products that transform how companies operate, make decisions, and grow.

We are building a high-performance culture grounded in five values: Empowering Excellence, Collaborative Teamwork, Unsolicited Respect, Consistent Transparency, and Efficient Communication. These define how we work, how we support one another, and how we hold ourselves accountable.

Applaudo is a place for people who want to learn fast, take ownership, and work alongside strong

teams they are proud to belong to. Joining us means being part of an organization that is evolving intentionally, investing in modern ways of working, and leading AI‑native transformation at scale.