knowmad mood is a leading Spanish technology consulting firm specializing in digital transformation, software development, and IT strategy. With a workforce of over 2,500 professionals, the company provides high-impact services across various sectors including banking, insurance, and retail, helping organizations navigate complex technological shifts through innovation and agile methodologies.

Headquartered in Madrid, the company maintains a significant presence across Spain with multiple regional hubs and a strong culture of remote work. For international professionals, knowmad mood is an attractive employer due to its involvement in large-scale international projects, frequent requirements for English-speaking talent, and a flexible "work from anywhere" policy for many of its technical roles.

Founded in 1994 as atSistemas, the company rebranded to knowmad mood in 2023 to reflect its international expansion and digital transformation focus. It is currently listed on the BME Growth market and continues to grow through both organic development and strategic acquisitions.

For international professionals

Offers a high volume of 100% remote roles, allowing employees to live anywhere in Spain.
Many positions specifically require high English proficiency (C1 level), making it accessible for international talent.
Publicly traded on the BME Growth market, indicating financial stability and corporate transparency.
Operates multiple physical offices in major Spanish cities including Madrid, Barcelona, and Palma de Mallorca for those preferring hybrid work.
Actively hires for modern tech stacks including AI, Cloud (AWS/Azure), and DevOps.

Senior Analytics Engineer (DBT & Snowflake)

knowmad mood

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

Job Description

We are knowmad mood!

We are a leading company in digital transformation, constantly evolving and at the forefront of technology. We were born to provoke real change through innovation and sustainable development, with the mission of adding value to clients and boosting our talent.

Made up of more than 3,000 creative, digital, and innovative people connected to a purpose and capable of generating connections with people all over the world. A responsible, flexible team with a high capacity to adapt to the needs of our clients and the market, while providing value, vision, creativity, expertise, professionalism, and passion for technology in every project.

The values that mark our course and guide us toward excellence are collaboration, innovation, commitment, fun, and trust.

What will your responsibilities be?

Design, document, and implement data models ready for analytics.
Build and maintain transformation layers using dbt (models, testing, macros, and documentation) and Snowflake.
Define how data is transformed into knowledge within an advanced data contextualization platform.
Ensure data consistency, quality, and performance, optimizing its use for analytics.
Implement tests, validation, and data lineage tracking mechanisms.
Facilitate the contextualization of time-series data and its analytical exploitation.
Collaborate with data scientists, analysts, and business stakeholders to generate actionable insights.

What are the requirements?

Solid experience in Analytics Engineering and data modeling.
Proficiency in dbt, SQL, and modeling patterns such as Star Schema or dimensional modeling.
Experience in performance optimization in Snowflake.
Knowledge of data governance, metadata, and lineage.
High level of English (C1).

And with us, you will enjoy:

✅Permanent Contract

✅ Remote

✅Internal training and access to certifications. Check our calendar here:

https://www.knowmadmood.com/es/talento/formacion

✅Flexible remuneration plan (health insurance, transport, nursery vouchers, restaurant vouchers)

✅Brand ambassador, through our referral plan

Recommend your friends and get an extra bonus!

✅Events, meetups, techdays, talks... and much more!

✅ 26 days of rest (22 vacation days, 2 flexible days, and December 24th and 31st as default holidays)

✅ Schedule: 8:30 AM to 6:00 PM (flexible) Mon-Thu and Fri 8:00 AM to 3:00 PM, and Summer Intensive in July and August from 8:00 AM to 3:00 PM

To stay up to date with our news, follow us here -> knowmad mood

At knowmad mood we are committed to equal opportunity and respect for diversity. We apply our Equality Plan and the principle of non-discrimination in all our selection processes.

View original advert (Spanish)

We are knowmad mood!

Somos una compañía líder en transformación digital, en constante evolución y a la vanguardia de la tecnología. Nacimos para provocar un cambio real a través de la innovación y el desarrollo sostenible, con la misión de aportar valor a los clientes e impulsar nuestro talento.

Formado por más de 3.000 personas creativas, digitales e innovadoras conectadas a un propósito y capaces de generar conexiones con personas de todo el mundo. Un equipo responsable, flexible y con alta capacidad de adaptación a las necesidades de nuestros clientes y del mercado, a la vez que proporciona valor, visión, creatividad, expertise, profesionalidad y pasión por la tecnología en cada proyecto.

Los valores que marcan nuestro rumbo y nos guían hacia la excelencia son la colaboración, la innovación, el compromiso, la diversión y la conﬁanza.

¿Cuáles serán tus funciones?

Diseñar, documentar e implementar modelos de datos preparados para analítica.
Construir y mantener capas de transformación utilizando dbt (modelos, testing, macros y documentación) y Snowflake.
Definir cómo los datos se transforman en conocimiento dentro de una plataforma avanzada de contextualización de datos.
Garantizar la consistencia, calidad y rendimiento de los datos, optimizando su uso para analítica.
Implementar pruebas, validación y mecanismos de seguimiento del linaje de datos.
Facilitar la contextualización de datos de series temporales y su explotación analítica.
Colaborar con científicos de datos, analistas y stakeholders de negocio para generar información accionable.

¿Cuáles son los requisitos?

Experiencia sólida en Analytics Engineering y modelado de datos.
Dominio de dbt, SQL y patrones de modelado como Star Schema o modelado dimensional.
Experiencia en optimización de rendimiento en Snowflake.
Conocimientos de gobierno del dato, metadatos y linaje.
Nivel alto de inglés (C1).

Y con nosotros podrás disfrutar de:

✅Contrato Indefinido

✅ Remoto

✅Formación interna y acceso a certificaciones. Consulta nuestro calendario aquí:

https://www.knowmadmood.com/es/talento/formacion

✅Plan de retribución flexible (seguro médico, transporte, tickets guardería, tickets restaurante)

✅Embajador de nuestra marca, a través de nuestro plan amigo

¡Recomienda a tus amigos y llévate un extra!

✅¡Eventos, meetups, techdays, charlas...y mucho más!

✅ 26 días de descanso (22 días vacaciones, 2 días de libre disposición y 24 y 31 diciembre festivos por defecto)

✅ Horario: 8.30 a 18h ( flexible) L-J y V 8 a 15h e Intensiva de Verano Julio y Agosto de 8 a 15h

Para estar al corriente de nuestras novedades síguenos aquí -> knowmad mood

En knowmad mood nos comprometemos con la igualdad de oportunidades y el respeto a la diversidad. Aplicamos nuestro Plan de Igualdad y el principio de no discriminación en todos nuestros procesos de selección.