data engineer e-commerce and marketplace platforms

The client is a global e-commerce and marketplace platform operating across North America and multiple international regions. It manages merchant transactions, payments, promotions, and financial operations, supporting millions of customers and partners worldwide.

• Develop and maintain data pipelines using SQL-based ELT patterns across Bronze, Silver, and Gold layers;
• Implement data ingestion from multiple sources into BigQuery;
• Build and optimize transformation logic for the curated Mart Silver layer;
• Ensure reprocessing and idempotency so pipelines can be reliably rerun from Bronze;
• Support Airflow DAG development for orchestration and monitoring;
• Optimize BigQuery performance and cost;
• Contribute to metadata, lineage, and documentation in the data catalog;
• Support testing, reconciliation, and parallel run validation during migration from legacy systems;
• Troubleshoot pipeline failures and support monitoring and alerting processes.

• Experience designing and building data pipelines using SQL-based ELT patterns;
• Experience ingesting data from SFTP, APIs, and databases into BigQuery;
• Experience with dimensional modeling, including fact and dimension tables, SCD handling, and surrogate key logic;
• Experience integrating data quality checks into pipeline execution, including row counts, reconciliation, and validations;
• Experience developing Apache Airflow DAGs for orchestration, scheduling, and monitoring;
• Experience optimizing BigQuery performance and cost through partitioning, clustering, and query tuning;
• Experience with CI/CD using Git, Flyway, and Jenkins;
• Experience with schema evolution and deployment practices;
• Experience integrating data with downstream systems such as ERP and reporting tools.

• Candidate location: EU, Georgia, Uzbekistan;
• Start: ASAP.