Senior Data Engineer

Publicis Groupe, the world's second largest communications group, is a solutions platform that is present in more than 100 countries.

About Spark Foundry

Spark Foundry is a global media agency that exists to bring HEAT -- Higher Engagement, Affinity, and Transactions -- to brands. By combining flawless media fundamentals with aggressive innovation, Spark inspires consumers to pay more attention; to care more about our clients' brands; and to buy more products and services from them.

Balancing the nimble spirit of a startup with the powerhouse soul of Publicis Groupe, Spark Foundry delivers the best of both worlds to a client roster that spans some of the world's best and most beloved brands and companies. We combine boutique-caliber insights and service with the buying clout and first-look access of a global leader, bringing the heat to challenger brands that want to act like giants, and to giant brands that want to act like challengers.

With a Millennial-friendly, bottom-up culture that celebrates diversity and aims for all voices to be heard, Spark has become a magnet for the industry's best talent, with one of the best retention rates in the industry. And by applying a whole-person approach to professional and personal development, Spark develops a workforce that is well prepared for today's challenges, and also poised to create meaningful careers in the years to come.

Because we know that heat arises at the intersection of complementary forces, our professionals come from myriad disciplines and backgrounds: data, analytics, and insights; content and creative production; communications and strategy; finance and marketing; and sociology, psychology, and other liberal arts disciplines.

Overview

We are looking to hire a Senior Data Engineer for one of our most strategic and high-visibility projects: Santander's global dashboarding initiative. The selected candidate will join a cutting-edge multicloud environment, actively participating in the design, development, and optimization of data platforms focused on advanced analytics and Business Intelligence at a global scale.

The position offers a hybrid work model based in Madrid, with continuous collaboration alongside multidisciplinary teams (Data Engineering, BI, Analytics, Architecture, and Business) in a demanding, dynamic, and high-performance environment.

Responsibilities

• Design and maintain data models (logical, physical, and dimensional) aligned with business needs and corporate standards.
• Design, develop, and optimize data pipelines between Google BigQuery and the Azure platform.
• Define and evolve the Lakehouse architecture on ADLS Gen2, ensuring scalability, performance, and governance.
• Implement and manage security, access control, and identity management through Azure Active Directory and Key Vault.
• Optimize datasets for efficient consumption in Power BI and other advanced analytics environments.
• Design and develop visualizations and dashboards in Power BI, applying best practices in semantic modeling, DAX, and user-centered design.
• Collaborate in defining visualization, performance, and usability standards for global reporting.
• Work closely with BI and Analytics teams to ensure proper data utilization in global dashboards.
• Ensure adherence to best practices in data quality, performance, and maintainability.

Qualifications

• 3 years of professional experience in data engineering.
• Advanced expertise in Azure Data Platform (Databricks, ADLS Gen2, Azure Storage, Key Vault, AAD).
• Solid experience with Google BigQuery in production environments.
• Strong knowledge of data model design in Lakehouse architectures.
• Advanced proficiency in Spark, Python, and SQL.
• Proven experience with CI/CD and version control (Git, ALM, Nexus, or equivalent tools).
• B2 English level to be evaluated by Talent Acquisition Team.

Bonus Points

• Have experience optimizing data for Power BI consumption.
• Demonstrated experience developing semantic models, DAX measures, and advanced visualizations in Power BI.

Why Join Us?

Because we offer reasons such as:

• 🌟 Flexible Benefits (Coverflex): Enjoy more than just work with flexible compensation including meal vouchers, health insurance, transportation, and more.
• 🚀 Growth Opportunities: You can advance in your career not only through the experience of working with major clients but also by accessing local and global training programs specialized according to your role, covering both technical and soft skills.
• 📚 Free Online Training: You can access unlimited courses from LinkedIn Learning and Udemy Catalogs through our artificial intelligence platform "Marcel".
• 🥇 Partner Certifications: You'll have the opportunity to obtain certifications from industry giants such as Meta, Google, or Amazon.
• 🌍 Work from anywhere: Telecommute up to 6 weeks from over 100 countries with our #WorkYourWorld program.
• 🎉 Attractive holidays package including your birthday & Advertising Day off plus some additional days off. Rest is also important!
• ✨ Work-Life Balance: Enjoy a hybrid model with up to two days working from home and intensive summer hours. Full remote in Easter, Christmas & 3 weeks in Summer. Flexible work start schedule.
• 🧘🏻‍♂️ Well-being: We prioritize the well-being of our staff and organize various health initiatives such as daily meditation or yoga among others.

Employee benefits are an integral part of the company's annual compensation package. These benefits are subject to the company's current policies and guidelines and may be modified, updated, or adjusted at the company's discretion to reflect organizational needs, regulatory requirements, or business conditions.

We are certified as a Great Place to Work, your happiness and providing you with an outstanding experience means a lot to us, let's enjoy!

Here at Publicis Groupe, we are committed to building a culturally diverse workforce and therefore strongly encourage applications from underrepresented groups. We are committed to equality of opportunity and welcome applications from all individuals, regardless of their background: we do not discriminate on the basis of race, color, religion, gender identity or expression, sexual orientation, national origin, age, disability, marital status, or any individual´s status in any group or class protected by law.

If you have any reasonable adjustment needs arising from a disability or medical condition to fully participate in the recruitment process, please discuss this with the recruiter who contacts you.

All employees are committed to complying with obligations regarding Information Security and Technologies, obligations related to the use of Artificial Intelligence, obligations stemming from the Quality and Environmental Management System, as well as obligations derived from the Integrity Management System, Corruption Prevention, and the Anti-Bribery and Anti-Corruption Policy. Furthermore, all employees are required to complete mandatory training courses, declarations, and compliance commitments in these areas.