EY (Ernst & Young) is a global leader in assurance, tax, consulting, and strategy and transactions services. As one of the "Big Four" professional services firms, it operates a vast network of member firms across more than 150 countries, employing nearly 400,000 professionals worldwide to help clients navigate complex regulatory and business challenges.

In Spain, EY maintains a significant footprint with a major headquarters in Madrid and a strong presence in Barcelona and other regional hubs. The firm is a major recruiter of international talent, offering diverse opportunities in digital transformation, financial services, and sustainability, often within multicultural teams where English is a primary working language.

EY was formed in 1989 through the merger of Ernst & Whinney and Arthur Young & Co. Its roots date back to the 19th century with founders Arthur Young and Alwin C. Ernst, who established their respective firms in the US and UK.

For international professionals

EY Spain frequently hires international profiles for its Global Delivery Services and specialized consulting arms.
The company provides a structured career development framework and extensive internal training programs.
Many roles in technology and consulting hubs allow for hybrid work arrangements.
The firm has a dedicated International Mobility program to facilitate internal transfers and relocations.
Offices are located in major Spanish business hubs, offering flexibility in geographic placement.

Senior Data & Analytics Engineer - Microsoft Ecosystem (Fabric / Azure)

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

Job Description

At EY, we are ready to face the future with confidence, "shape the future with confidence"

Our goal is to support you in achieving success within a globally connected environment, collaborating with diverse teams to reach great goals.

Join us and build a unique experience and a better world for everyone.

The opportunity:

EY is positioned as a global leader in audit, consulting, transaction advisory and strategy, legal and tax services, with more than 400,000 professionals in over 150 countries. In Spain, we are a team of more than 6,000 professionals distributed across 15 offices.

Currently, we are looking to strengthen our team by incorporating a Senior Data & Analytics Engineer - Microsoft Ecosystem (Fabric / Azure) with at least 3 years of experience to integrate into national and international projects.

Responsibilities:

• Design data architectures based on the medallion pattern (bronze/silver/gold), conceptualizing the gold layer as a consumable data product, not as a technical data dump.

• Model using star schemas with criteria: facts, dimensions, granularity, SCDs.

• Build robust ETL/ELT pipelines in Microsoft Fabric (Pipelines, PySpark Notebooks, Lakehouse, Warehouse).

• Work with Git/GitHub and CI/CD: PRs, code review, controlled deployments.

• Collaborate on the analysis layer (Power BI), ensuring the data model enables it effectively.

• Integrate AI capabilities when they provide value (Azure OpenAI, Copilot in Fabric, RAG).

• Participate in architecture decisions and mentor junior/mid-level profiles.

Necessary Requirements

More than 3 years of experience in cloud data projects (Azure, Fabric, Synapse, Databricks or equivalent), not as a tool user, but as someone who has designed pipelines, debugged performance issues, and made architectural decisions.

• Experience designing and executing end-to-end projects, from ingestion to the analysis layer. You will be asked about specific cases.

• Medallion architecture and dimensional modeling (star) applied in real projects.

• Advanced SQL and solid Python/PySpark.

• Git/GitHub with professional workflow (PRs, code review, CI/CD).

• Upper-intermediate English.

What We Are Looking For:

To increase the value of our Microsoft team, thereby providing better service to our clients and aiding digital transformation in a changing and dynamic environment.

What do we offer you?

At EY, we will accompany you in developing future-oriented skills, while providing exceptional experiences to face new challenges with confidence. Our goal is to support you in achieving professional success within a globally connected environment, where we will provide tools and flexibility so you can reach your goals.

Furthermore, we value an inclusive culture and diversity, recognizing that every person is unique and has something valuable to contribute. We will give you a voice to share your ideas, because at EY we believe every idea is important. We will also provide the confidence and training necessary for you to grow and become a great leader.

Are you ready to shape your future with confidence? Join us

EY | Building a better working world

EY exists to build a better working world; we help our clients, people, and society create long-term value to generate market value.
Thanks to data and technology, we have teams in more than 150 countries generating trust and helping clients grow, transform, and operate.
Working in Assurance, Consulting, Tax & Legal, Strategy and Transactions, EY teams ask the best questions to find new answers to the complex problems facing our world today.

#LI-HYBRID

View original advert (Spanish)

En EY, estamos preparados para afrontar el futuro con confianza, "shape the future with confidence"

Nuestro objetivo es apoyarte para que alcances el éxito dentro de un entorno globalmente conectado, colaborando con equipos diversos para alcanzar grandes metas.

Únete a nosotros y construye una experiencia única y un mundo mejor para todos.

La oportunidad:

EY se posiciona como un líder global en servicios de auditoría, consultoría, asesoramiento en transacciones y estrategia, legal y fiscal, contando con más de 400.000 profesionales en más de 150 países. En España, somos un equipo de más de 6.000 profesionales distribuidos en 15 oficinas.

En la actualidad, estamos buscando reforzar nuestro equipo con la incorporación de un Senior Data & Analytics Engineer - Ecosistema Microsoft (Fabric / Azure) con, al menos, 3 años de experiencia para integrar en proyectos a nivel nacional e internacional.

Funciones:

• Diseñar arquitecturas de datos sobre medallion (bronze/silver/gold) pensando la capa gold como producto de datos consumible, no como volcado técnico de datos.

• Modelar en esquema en estrella con criterio: hechos, dimensiones, granularidad, SCDs.

• Construir pipelines ETL/ELT robustos en Microsoft Fabric (Pipelines, Notebooks PySpark, Lakehouse, Warehouse).

• Trabajar con Git/GitHub y CI/CD: PRs, code review, despliegues controlados.

• Colaborar en la capa de análisis (Power BI) garantizando que el modelo de datos la habilite bien.

• Integrar capacidades de IA cuando aporten valor (Azure OpenAI, Copilot in Fabric, RAG).

• Participar en decisiones de arquitectura y mentorizar a perfiles junior/mid.

Requisitos necesarios

Experiecnia más de 3 años en proyectos de datos en cloud (Azure, Fabric, Synapse, Databricks o equivalente), no como usuario de herramientas, sino como alguien que ha diseñado pipelines, depurado problemas de rendimiento y tomado decisiones de arquitectura.

• Haber diseñado y ejecutado proyectos end-to-end, desde ingesta hasta capa de análisis. Te preguntaremos por casos concretos.

• Arquitectura medallion y modelado dimensional (estrella) aplicados en proyectos reales.

• SQL avanzado y Python/PySpark sólido.

• Git/GitHub con flujo profesional (PRs, code review, CI/CD).

• Inglés intermedio-alto.

Qué Buscamos:

Aumentar el valor de nuestro equipo de Microsoft para, de esta manera dar un mejor servicio a nuestros clientes y ayudar a la transformación digital en un entorno cambiante y dinámico.

¿Qué te ofrecemos?

En EY, te acompañaremos en el desarrollo de habilidades orientadas al futuro, mientras te proporcionamos experiencias excepcionales para enfrentar nuevos retos con confianza. Nuestro objetivo es apoyarte para alcanzar el éxito profesional dentro de un entorno globalmente conectado, donde te facilitaremos herramientas y flexibilidad para que puedas alcanzar tus metas.

Además, valoramos una cultura inclusiva y la diversidad, reconociendo que cada persona es única y tiene algo valioso que aportar. Te daremos voz para que compartas tus ideas, porque en EY creemos que cada idea es importante. También te proporcionaremos la confianza y formación necesarias para que puedas crecer y convertirte en un gran líder.

¿Estás listo para dar forma a tu futuro con confianza? Únete a nosotros

EY | Building a better working world

EY existe para construir un mundo de trabajo mejor, ayudamos a nuestros clientes, personas y sociedad a crear un valor a largo plazo para generar valor en el mercado.
Gracias a los datos y la tecnología, tenemos equipos en más de 150 países generando confianza y ayudando a los clientes a crecer, transformarse y operar.
Trabajando en Assurance, Consulting, Tax&Legal, Strategy y Transactions, los equipos de EY se hacen las mejores preguntas para encontrar nuevas respuestas a complejos problemas en los que se encuentra nuestro mundo a día de hoy.

#LI-HYBRID