Business Intelligence Specialist

Publicis Groupe España; Madrid; Presencial; EUR 42.000 - 64.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Flexible Benefits

Growth Opportunities

Free Online Training

Descripción de la vacante

Publicis Groupe España is seeking a Business Intelligence Specialist to join and strengthen our BI team in Madrid. You will participate in national and international analytics, reporting, and data visualization projects for top-tier clients, transforming data into actionable insights.

You will design, develop, and maintain dashboards using Power BI and Salesforce Marketing Cloud Intelligence (Datorama), integrate data from multiple sources, and collaborate with cross-functional teams across

Formación

• Proven experience with Power BI.
• Strong knowledge of data modeling.
• Experience with Power Query.
• Advanced proficiency in DAX.
• Experience developing and maintaining complex dashboards.

Responsabilidades

• Design, develop, maintain, and improve reporting and analytics solutions from large data volumes.
• Involved in digital marketing, media, performance, branding, web analytics, and executive reporting projects.
• Collaborate with multidisciplinary teams to continuously improve BI processes.
• Produce operational and executive reporting.
• Collaborate on international BI projects.
• Define and maintain business rules, taxonomies, and analytical models.

Conocimientos

Power BI

Data modeling

Power Query

DAX

Dashboard development

Herramientas

Datorama

Salesforce Marketing Cloud Intelligence

GA4

DV360

BigQuery

Descripción del empleo

Company Description

Publicis Groupe, the world's second largest communications group, is a solutions platform that is present in more than 100 countries and has more than 98,000 employees. With a unique work philosophy, The Power of One puts clients at the center by promoting the growth of their business through creative agencies (Publicis, Leo Burnett, Publicis Health), media (Zenith, Starcom, Spark and Performics), and areas of transversal knowledge. Publicis Groupe links Creativity, Technology and Data offering a value proposition that effectively connects brand and consumer.

Overview

Publicis Groupe is looking for a Business Intelligence Specialist to join and strengthen its Business Intelligence team. The selected candidate will participate in national and international analytics, reporting, and data visualization projects for top-tier clients, working closely with business, marketing, media, and technology teams. We are seeking a professional with solid experience in Business Intelligence, data modeling, and dashboard development, capable of transforming complex data into actionable insights and working with multiple data sources in dynamic and collaborative environments.

Responsibilities

What Will Your Mission Be?

Design, develop, maintain, and continuously improve reporting and analytics solutions that transform large volumes of data into actionable information for clients and internal teams. You will be involved in projects related to digital marketing, media, performance, branding, web analytics, and executive reporting, collaborating with multidisciplinary teams and actively contributing to the continuous improvement of Business Intelligence processes.

Key Responsibilities

Business Intelligence & Reporting

• Develop and maintain dashboards in Power BI.
• Develop, maintain, and enhance dashboards and reports in Salesforce Marketing Cloud Intelligence (Datorama).
• Improve and optimize existing reporting solutions.
• Design business-oriented visualizations that support decision-making.
• Produce operational and executive reporting.

Data Modeling & Integration

• Design and maintain data models.
• Transform and prepare data using Power Query and other integration tools.
• Integrate data from multiple digital sources.
• Automate reporting processes and data refresh routines.
• Define and maintain business rules, taxonomies, and analytical models.

Data Quality & Governance

• Validate and reconcile data from different sources.
• Identify and resolve discrepancies and data quality issues.
• Ensure data traceability and consistency.
• Maintain functional and technical documentation.

Support & Collaboration

• Provide support to internal users and clients.
• Manage and track functional issues and incidents.
• Administer user access and permissions across reporting platforms.
• Collaborate with account management, planning, activation, analytics, and technology teams.
• Participate in international Business Intelligence projects.

Qualifications

Business Intelligence

• Proven experience with Power BI.
• Strong knowledge of data modeling.
• Experience with Power Query.
• Advanced proficiency in DAX.
• Experience developing and maintaining complex dashboards.

Data & Analytics

• Experience integrating and analyzing data from multiple sources.
• Ability to translate data into business insights.
• Experience in data validation and quality control.

Skills

• Strong analytical capabilities.
• High attention to detail.
• Problem-solving skills.
• Technical autonomy.
• Ability to interact effectively with business stakeholders.
• Professional level of English.

Nice to Have

• Experience in marketing analytics or media analytics.
• Experience working with data from advertising and digital marketing platforms.
• Knowledge of Google Analytics 4 (GA4).
• Experience with Google Ads, DV360, CM360, Meta Ads, TikTok Ads, LinkedIn Ads, Amazon Ads, or similar platforms.
• Experience using data integration tools such as Supermetrics.
• Knowledge and experience with Salesforce Marketing Cloud Intelligence (Datorama).
• SQL knowledge.
• Experience with BigQuery, Microsoft Fabric, or cloud-based data environments.
• Previous experience in media agencies, digital marketing agencies, or analytics consulting firms.

Additional Information

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!
• 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 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.