Sr. Data Engineer
About the Role
Locations: Colombia
Come join us at Odisea and work with some of the most exciting start-ups in the US!
The Mission
We are seeking a high-level technical lead to take full ownership of a sophisticated, cloud-native data ecosystem. This isn't a "follow the ticket" role. You will operate as an independent entity within our organization, tasked with managing, refining, and future-proofing a complex data engine that serves high-stakes, real-time consumer markets.
If you thrive in environments with zero hand-holding and possess the rare ability to translate "vague stakeholder vision" into "precise technical execution," this is your domain.
The Role: Total Autonomy & Proactive Communication
In this position, you are the pilot, the navigator, and the mechanic. You will work with almost 100% autonomy, managing a distributed architecture without a traditional on-site lead. You are expected to:
- Self-Direct: Define your own roadmap and execute against it without daily oversight.
- Proactive Synthesis: "Read between the lines" of stakeholder requests — anticipating data bottlenecks and infrastructure needs before the business even realizes they exist.
- Bridge the Gap: Manage expectations with stakeholders who have unconventional communication styles. You must be a communication architect, providing clarity and structure even when the information feels fragmented.
- Stakeholder Ownership: You are expected to own the communication loop entirely—proactively providing updates, flagging risks, and managing stakeholder expectations before you are asked. If there is silence, there is a need to fill it with progress.
Core Responsibilities
- End-to-End Orchestration: Architect and sustain self-healing pipelines using Astronomer/Airflow to ensure 24/7 data availability.
- Serverless Ingestion: Design and optimize event-driven API ingestion frameworks leveraging AWS Lambda and DLT (Data Load Tool).
- Warehouse Excellence: Manage high-performance modeling within AWS Redshift, utilizing DBT to transform raw transactional data into high-fidelity business intelligence.
- Observability & Intuition: Implement advanced monitoring and alerting (CloudWatch) that doesn't just report failures, but predicts them.
- Integration Mastery: Lead the ingestion of complex, third-party data streams (Ad-tech, CRM, and high-volume Sales systems) into a unified, scalable source of truth.
Technical Seniority & Qualifications
- Communication: Exceptional English proficiency. You must be able to lead meetings, drive your own updates, and translate technical debt into business risk for non-technical partners.
- Experience: 6+ years of total Data Engineering experience (with at least 4 years focused on building pipelines that integrate APIs and cloud services).
- AWS Mastery: 3+ years of hands-on experience with AWS (Redshift, Lambda, S3, and CloudWatch).
- Python Specialist: 3+ years of Python development focused on scripting, orchestration, and API interactions.
- API Integration: 2+ years of proven experience building/maintaining REST API integrations for data ingestion, including ETL processes with third-party systems.
- Orchestration: 1+ years of experience with Astronomer (Airflow) or an equivalent tool.
- Data Modeling: Strong SQL skills for performance optimization and modeling (PostgreSQL, MySQL, or DynamoDB).
- Tools & Ops: Required familiarity with version control (Git), CI/CD pipelines, and Infrastructure-as-Code (CloudFormation).
Our Technical Stack
- Languages & Scripting: Python (scripting, orchestration), SQL
- Cloud & Infrastructure: AWS (Redshift, Lambda, S3, CloudWatch), CloudFormation (IaC)
- Data Pipelines & Orchestration: Astronomer (Airflow), API-based pipelines, DLT (Data Load Tool), DBT
- Databases: Redshift, PostgreSQL, DynamoDB, MySQL
- Architecture: API-first, Cloud-native, Event-driven
- DevOps: Git, CI/CD, CloudFormation (IaC)
Nice to Have
- Specific experience with high-volume transactional data (Marketing platforms, CRM, Ticketing, or Sales performance tools).
- Previous experience in "Stealth" or fully autonomous roles where you served as the primary technical point of contact.
About the Company
Odisea fue fundada bajo la creencia de que las empresas increíbles solo pueden ser construidas sobre la base de una cultura intencional cultivada por personas excelentes. En Odisea, estamos abordando una necesidad específica al redefinir el "nearshoring" para ayudar a cerrar la brecha de oportunidades entre Colombia y los Estados Unidos, y estamos construyendo un equipo apasionado de profesionales comprometidos con este propósito.
Apply now to join this great team and see how your career continues to grow.