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 Job Description In the fast-paced world of data-powered experiences, our client, Xeus Solutions is pioneering how companies engage, analyze, and grow. As a strategic partner to immersive entertainment and ticketed attractions, Xeus is leading the charge with advanced analytics, real-time performance insights, and full-funnel marketing integration. Their platform empowers businesses to reach audiences more effectively and deliver unforgettable customer experiences. We're seeking a highly skilled Senior Data Engineer to help expand the infrastructure behind the experience. In this role, you'll be at the heart of the data engine and automating pipelines, shaping models, and integrating complex data from diverse sources. This is a hands‑on opportunity to influence architecture, drive meaningful decisions, and help scale an organization on the cutting edge of experiential intelligence. You’ll be an integral part of bringing Xeus Solutions’ vision to life and empowering the world’s most innovative entertainment and experience brands to use data more intelligently and reach broader audiences. Your work will help streamline operations, optimize performance, and ultimately make incredible, immersive experiences more accessible to people everywhere. If you are excited to solve complex technical challenges, passionate about the power of data, and eager to shape the future of customer engagement in the experience economy, we’d love to hear from you. Responsibilities Design, build, and maintain robust data pipelines using: AWS Redshift for data warehousing AWS Lambda for event-driven API ingestion Astronomer (Airflow) for orchestration and scheduling DLT (Data Load Tool)—the open-source Python library—to streamline and standardize data ingestion DBT for modeling and transforming data into tables and views Automate and monitor existing workflows to achieve self-healing, high-availability pipelines Ingest and integrate data from diverse customer sources, including: Paid media platforms (Google Ads, Meta/Facebook, Instagram, etc.) CRMs & Sales systems tied to ticketing and transaction data Implement observability best practices—data quality checks, alerting, and performance tuning—across all pipelines Collaborate closely with analytics, product, and marketing teams to ensure datasets are documented, accessible, and fit for purpose Contribute to the evolution of Xeus’ Lightning platform, empowering clients with real-time business insights Qualifications Excellent English proficiency, both verbal and written, with the ability to explain technical concepts to both technical and non-technical audiences. 4+ years of hands‑on data engineering experience , preferably building pipelines that integrate APIs and cloud services. 3+ years of hands‑on experience with Amazon Web Services (AWS) , especially Redshift, Lambda, S3, and CloudWatch. 3+ years of Python development experience , focused on scripting, orchestration, and API interactions. 2+ years of experience working with RESTful and third‑party APIs , including extracting, transforming, and loading data, as well as sending data to external systems for integration and reporting. Strong SQL skills , with the ability to perform data transformation, modeling, and performance optimization using relational or non-relational databases (e.g., Redshift, MySQL, PostgreSQL, DynamoDB). Proven experience building and maintaining REST API integrations for data ingestion for at least 2 years. Experience with Astronomer (Airflow) or an equivalent orchestration tool for at least 1 year. Familiarity with DLT, the open-source Python library for standardized load processes, is a plus. Familiarity with DBT for data modeling and creation of tables and views is a plus. Familiarity with version control systems (e.g., Git), CI/CD pipelines, and infrastructure-as-code tools is required. Experience working with marketing platforms, ticketing systems, CRM platforms, or sales performance tools is a plus, but not required. Strong collaboration skills and comfort working in distributed, cross-functional teams Our Tech Stack Languages & Scripting: Python (scripting, orchestration, API interactions), SQL Cloud & Infrastructure: AWS (Redshift, Lambda, S3, CloudWatch), Infrastructure-as-Code (CloudFormation) Data Pipelines & Orchestration: Astronomer (Airflow) or equivalent orchestration tools, API-based pipelines, DLT (Data Load Tool - optional), DBT (optional) Databases: Redshift, PostgreSQL, DynamoDB (optional), MySQL (optional) Version Control & CI/CD: Git, CI/CD pipelines Architecture: API-first pipelines, Cloud-native, Event-driven Nice to Have: Experience working with marketing platforms, CRM, ticketing systems, or sales performance data 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. Our client, Xeus Solutions, is redefining how immersive experiences use data to grow smarter and faster. Customers include some of the most innovative entertainment and ticketed experience brands in the U.S. Apply now to join this great team and see how your career continues to grow. #J-18808-Ljbffr