Job Summary: We are seeking Senior Backend Engineers with a focus on data engineering to transform Senior Data Engineer designs into production-ready ETLs using Airflow and Python, integrating multiple data sources. Key Highlights: 1. Develop reusable DAGs and operators 2. Create robust ETLs for all data sources 3. Optimize execution times and handle errors Senior Backend – Data Engineering (2 Openings) **Location:** Medellín, Antioquia **Required Experience:** 3 to 5 years **Contract Type:** Indefinite Term **Salary:** **$5.000.000 to 7.000.000 COP monthly** Job Description We are seeking **Senior Backend Engineers focused on data engineering** to convert designs defined by the Senior Data Engineer into **production-ready ETLs using Airflow and Python**, integrating multiple data sources such as Oracle, MSSQL, PostgreSQL, and structured files. Required Technical Skills * Advanced Python * Advanced Apache Airflow (Operators, Hooks, Sensors, XCom, Pools, SLA, backfill) * Advanced SQL (CTEs, window functions, MERGE, UPSERT) * Reading PL/SQL and T-SQL * Incremental extraction strategies (timestamps, rowversion, keys) * Connectors: OracleHook, MsSqlHook, PostgresHook * File ingestion (CSV, TXT, XLSX) * Data quality (DQ) validations * Version control with Git * Azure DevOps and Azure Pipelines * Power BI Responsibilities * Develop reusable DAGs and operators * Create robust ETLs for all data sources * Implement incremental extractors with pagination and load limits * Validate schemas and data quality * Develop transformations and loads into the Data Warehouse * Optimize execution times (chunking, controlled parallelism, pools) * Implement error handling and retry strategies while exposing metrics * Document interfaces and automate unit tests and integrations * Collaborate with DBAs to create materialized views or pre-aggregations for Power BI * Perform load testing Employment Type: Full-time, Indefinite Term Workplace: On-site