Orquest is a leading AI-driven workforce management and scheduling software provider specifically designed for the retail industry. Founded in Madrid, the company leverages advanced algorithms and data science to help retailers optimize their staff planning, improve operational efficiency, and enhance the customer experience. With a growing global footprint, Orquest serves major international brands across various sectors, positioning itself as a key player in the retail technology space.

Headquartered in Madrid, Orquest offers a dynamic and innovative environment for international professionals, particularly those in data engineering, customer success, and sales. The company's focus on global expansion, including significant operations in Latin America and Europe, makes it an attractive destination for talent looking to work at the intersection of AI and retail. Their culture emphasizes technical excellence and a collaborative approach to solving complex logistical challenges.

Founded in 2016 in Madrid, Orquest originated as a specialized solution for workforce optimization within the retail sector. It has since evolved into a standalone SaaS platform used by major global retailers to automate complex scheduling tasks.

For international professionals

Headquartered in Madrid, offering a central hub for tech talent in Spain.
Specializes in AI and machine learning for retail, providing opportunities for high-tech specialization.
Operates internationally with a strong presence in LATAM and Europe, often requiring multilingual capabilities.
As a Spanish-founded scale-up, it provides a fast-paced environment with significant growth potential.

Data Engineer

Orquest - Retail Smart Planning

This job was originally posted in Spanish and automatically translated to English. You'll most likely need Spanish to apply.

Job Description

Orquest was born from a conviction: in the retail sector, every interaction counts. A fundamental part of the in-store experience are the people—both customers and employees—and our software is created precisely to synchronize both. We put AI and machine learning at the service of stores so they always have the right employee, in the right place, at the right time.

Our data team is growing! Following the successful launch of our Data Warehouse as a standalone product, we are looking for a Data Engineer with the vision of a data analyst to keep our infrastructure clean, organized, and perfectly scalable. If you are passionate about optimizing complex data models and want to see the direct impact of your pipelines on the business, this is the place for you!

✨ How you will make a difference

Master the data "backstage": You will maintain, optimize, and scale our data infrastructure to ensure a single and reliable source of truth for the entire company.

Accelerate our Data Warehouse: You will take charge of loading analytical data and actively participate in the integration of Artificial Intelligence solutions into the warehouse ecosystem.
Transform transactional into analytical: You will optimize heavy queries and turn complex queries into clean and efficient ones.
Support for the business front line: You will handle specific queries and provide support to our Customer Success and Adoption teams, ensuring that strategic clients receive flawless analytical reports.
Navigate growth with critical thinking: You will bring order to the construction phases, adapting quickly to changes in criteria and proactively raising your hand to propose infrastructure improvements.

Requirements

🧩 What we are looking for

Mid-to-Senior Experience: Around 4 or 5 years of professional experience in data roles. It is highly desirable that you started your career as a Data Analyst before transitioning to Data Engineer, ensuring that you understand the business impact behind the data you extract.
Expert SQL Mastery: An expert level of SQL is absolutely key. You must possess a robust logical structure for data modeling and maintenance.
Pipeline Architecture: Deep understanding and design of ETL processes and optimization of massive databases.
Obsession with detail: A join error in a report sent to an end customer can be critical for the company. We value rigorous, methodical, and neat execution in everything you deliver.
Tech Stack and AI: Good logical judgment for programming in Python. Familiarity with the AWS Cloud environment (specifically Glue and S3) is recommended, although equivalent experience in Azure or GCP is welcome if you have a high learning speed. We expect you to feel comfortable relying on AI assistants (such as Claude) to optimize your daily efficiency.
Proactivity and Communication: You will join a flat and highly collaborative team of 4 people. We are not looking for isolated profiles; we seek someone with a natural disposition to coordinate solutions with other areas and communicate their blockers with total transparency.
Languages: Native or fluent Spanish is mandatory. A professional level of English is not an exclusive requirement, but great if you have it.

Benefits

🌱 What we offer

✨ A key role in a fast-growing international SaaS company.
🏠 Remote work model from Spain.
🌍 A flat team with a cross-support dynamic and no rigid hierarchies.
💡 Real ownership and autonomy to generate impact.
💎 Beyond the salary:

Comprehensive health insurance.
OpenUp platform for your mental well-being.
Cobee for flexible compensation (meals, transport, etc.).
Language classes.

View original advert (Spanish)

Orquest nació de una convicción: en el sector retail, cada interacción cuenta. Una parte fundamental de la experiencia en tienda son las personas -tanto los clientes como los empleados- y nuestro software está creado precisamente para sincronizar a ambos. Ponemos la IA y el machine learning al servicio de las tiendas para que siempre tengan al empleado adecuado, en el lugar adecuado y en el momento adecuado.

¡Nuestro equipo de datos está creciendo! Tras el exitoso lanzamiento de nuestro Data Warehouse como un producto independiente, buscamos un/a Data Engineer con la visión de un analista de datos para mantener nuestra infraestructura limpia, organizada y perfectamente escalable. Si te apasiona optimizar modelos de datos complejos y quieres ver el impacto directo de tus pipelines en el negocio, ¡este es tu lugar!

✨ Cómo marcarás la diferencia

Domina el "backstage" de los datos: Mantendrás, optimizarás y escalarás nuestra infraestructura de datos para garantizar una fuente única y fidedigna de la verdad para toda la compañía.

Acelera nuestro Data Warehouse: Te harás cargo de cargar los datos analíticos y participarás activamente en la integración de soluciones de Inteligencia Artificial en el ecosistema del warehouse.
Transforma lo transaccional en analítico: Optimizarás consultas pesadas y complejas consultas limpias y eficientes.
Soporte a la primera línea de negocio: atenderás consultas puntuales y darás soporte a nuestros equipos de Customer Success y Adopción, asegurando que los clientes estratégicos reciban informes analíticos impecables.
Navega el crecimiento con pensamiento crítico: Aportarás orden en las fases de construcción, adaptándote rápidamente a los cambios de criterio y levantando la mano proactivamente para proponer mejoras en la infraestructura.

Requirements

🧩 Qué estamos buscando

Experiencia Mid-to-Senior: Alrededor de 4 o 5 años de experiencia laboral en roles de datos. Es muy deseable que hayas iniciado tu carrera como Data Analyst antes de dar el salto a Data Engineer, asegurando así que comprendas el impacto de negocio que hay detrás de los datos que extraes.
Dominio experto de SQL: Un nivel experto en SQL es absolutamente clave. Debes poseer una estructura lógica robusta para el modelado y mantenimiento de datos.
Arquitectura de Pipelines: Comprensión profunda y diseño de procesos ETL y optimización de bases de datos masivas.
Obsesión por el detalle: Un error de cruce en un informe enviado a un cliente final puede ser crítico para la compañía. Valoramos la ejecución rigurosa, metódica y pulcra en todo lo que entregas.
Stack Tecnológico e IA: Buen criterio lógico para programar en Python. Recomendable tener familiaridad con el entorno Cloud de AWS (específicamente Glue y S3) , aunque la experiencia equivalente en Azure o GCP es bienvenida si tienes una alta velocidad de aprendizaje. Esperamos que te sientas cómodo/a apoyándote en asistentes de IA (como Claude) para optimizar tu eficiencia diaria.
Proactividad y Comunicación: Te unirás a un equipo plano y altamente colaborativo de 4 personas. No queremos perfiles aislados; buscamos a alguien con disposición natural para coordinar soluciones con otras áreas y comunicar sus bloqueos con total transparencia.
Idiomas: El español nativo o fluido es obligatorio. Un nivel profesional de inglés no es un requisito excluyente, pero genial si lo tienes.