What are the responsibilities and job description for the Manager, Platform Management & Reporting (Power BI) position at Publicis Groupe Holdings B.V?
Present in over 100 countries and employing nearly 80,000 professionals, Publicis Groupe is the third largest communications group in the world. Publicis Groupe is listed on the Euronext Paris [FR0000130577] and is part of the CAC 40 index. Active across the entire value chain, Publicis Groupe offers its major clients a transversal, unified and fluid model allowing them access to all the Groupe’s tools and expertise around the world through the mantra "The Power of One."
Overview
The Business Intelligence and Reporting Manager position is responsible for supporting all USMS project management portfolio platform-related dashboards, primarily using Microsoft Power BI, with Publicis Groupe systems’ financial, project, and employee data.
As part of the US Operations HQ team, this role will support the VP of Platform Delivery and partner with the US rOar Project Management Portfolio leadership and Marketing Services BI team to understand and define Publicis Groupe business requirements, working towards building and managing appropriate and scalable dashboard solutions. This business intelligence and reporting role will collaborate with Publicis Groupe and Platform teams to act on those requirements and determine the proper solution(s) to provide robust, digestible, and consistent reporting outputs — including data, reports, dashboards, and supporting materials — for varying internal audiences.
The ideal candidate should have experience integrating multiple complex data systems into a unified set of reports and dashboards. The candidate will work with various stakeholders on the design, development, and maintenance of new and existing dashboards.
Responsibilities
Manage data from multiple sources to build robust data models, create and manage interactive dashboards primarily in Microsoft Power BI and Excel for analysis, ensuring the data is used accurately and reliably.
Design, develop, test, and deploy Power BI scripts, working with the US team to generate and maintain visually appealing and insightful reports.
Create custom visualizations and implement row-level security on data.
Build data models and develop dashboards using Power BI Desktop.
Develop tabular and multidimensional models that are compatible with warehouse standards.
Collaborate with application developers to design and develop Power BI data visualizations.
Use advanced-level calculations on datasets using DAX functions in Power BI.
Test formulas and visualizations to ensure their functionality.
Document the processes used and the methodologies implemented.
Participate in testing and validation of enhancements to platforms with implications for data on dashboards.
Contribute to communications and documentation, including status updates, project plans, ENHs, QA ticketing, and report development and change management.
Contribute to a culture of delivery efficiency and excellence within the team, ensuring strong data integrity.
Demonstrate a willingness to learn and creatively solve problems with a positive, professional demeanor.
Work with direct supervisors and extended teams to learn and support processes, workflows, best practices, and tools that support the delivery of reporting for Groupe Agencies.
Qualifications
Bachelor’s Degree required.
3-5 years of agency experience.
Proficient in MS Office Suite.
Deep knowledge of MSFT Power BI, Power Apps, Power Automate, and data visualization best practices.
Expertise in DAX, M, and SQL for data analysis and manipulation for data management.
Knowledge of key Publicis data via GDW and financial systems, including but not limited to an understanding of data for Altair and labor analysis, HFM, v1 Clarizen PPM, timesheets, Career Settings, and soon working with v2 Adobe Workfront (preferred but not required).
Strong attention to detail and critical thinking abilities.
High degree of technical and emotional intelligence.
Strong analytical thinking and problem-solving skills.
Strong communication skills across all levels of the organization, including for presenting complex information.
Exposure to agile and/or content management processes is a plus, though not required.
Additional information
Our Publicis Groupe motto "Viva La Différence" means we're better together, and we believe that our differences make us stronger. It means we honor and celebrate all identities, across all facets of intersectionality, and it underpins all that we do as an organization. We are focused on fostering belonging and creating equitable & inclusive experiences for all talent.
Compensation Range: $73,910 - $106,260 annually. This is the pay range the Company believes it will pay for this position at the time of this posting. Consistent with applicable law, compensation will be determined based on the skills, qualifications, and experience of the applicant along with the requirements of the position, and the Company reserves the right to modify this pay range at any time. Temporary roles may be eligible to participate in our freelancer/temporary employee medical plan through a third-party benefits administration system once certain criteria have been met. Temporary roles may also qualify for participation in our 401(k) plan after eligibility criteria have been met. For regular roles, the Company will offer medical coverage, dental, vision, disability, 401k, and paid time off. The Company anticipates the application deadline for this job posting will be 01/29/2025.
Publicis Groupe provides robust and inclusive benefit programs and policies to support the evolving and diverse needs of our talent and enable every person to grow and thrive. Our benefits package includes medical coverage, dental, vision, disability, 401K, as well as parental and family care leave, family forming assistance, tuition reimbursement, and flexible time off.
If you require accommodation or assistance with the application or onboarding process specifically, please contact hrcompliance_usms@publicis.com.
All your information will be kept confidential according to EEO guidelines.
Veterans Encouraged to Apply
Salary : $73,910 - $106,260