Data Engineer
Role details
Job location
Tech stack
Job description
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.
Requirements
We thinkyou'reawesome if you:
- Have experience optimizing data for Power BI consumption.
- Demonstrated experience developing semantic models, DAX measures, and advanced visualizations in Power BI.
About the company
Publicis Groupe, the world's second largest communications group, is a solutions platform that is present in more than 100 countries. Do you want to know more about the agency/brand or area of expertise you will be applying for on this role? Keep reading
Spark Foundryis 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.
,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.