Senior Analyst, Data Analytics & Intelligence

A division of Publicis Groupe Publicis Digital Experience is a network of top-tier agencies designed to develop capabilities and solutions to enable growth and provide scaled access to the digital capabilities of Publicis Groupe in service of our clients. Together the Publicis Digital Experience portfolio endeavors to create value at the intersection of technology and experiences to connect brands and people.

Our model to transform every brand experience will help clients navigate develop and activate commerce in a way that will provide them with a future-proof model for modern marketing. With our unique expertise in consumer engagement CRM and commerce Publicis Digital Experience powers brands and empowers people in a new era of creativity. An ever-changing landscape and the need for fluid thinking is just part of our problem-solving nature. Which means were untethered from any specific medium or methodwe go where ideas will work best.

We are an expanding network with more than 5000 employees with agency brands throughout our global offices. Publicis Digital Experience brands include Razorfish Digitas Arc Worldwide Saatchi Saatchi X Plowshare 3Share and the Publicis Commerce Exchange.

The Looker BI Developer is responsible for spearheading the migration of a large and complex portfolio of Tableau dashboards to Looker establishing a new Looker ecosystem and subsequently owning its product roadmap governance and continuous improvement. As the primary product owner you will bridge the gap between business needs and technical execution. A deep hands-on expertise in Looker and LookML will be critical in shaping our analytics future and empowering data-driven decisions for our clients.

Looker Platform Product Strategy & Vision

• Define and champion the vision strategy and roadmap for our Looker BI platform aligning with business objectives and stakeholder needs.
• Translate complex business requirements into clear actionable user stories epics and technical specifications for Looker development.
• Prioritize features and enhancements based on business impact technical feasibility and user feedback.
• Act as the primary subject matter expert for Looker advising stakeholders on best practices capabilities and limitations.

Large-Scale Tableau to Looker Migration Leadership

• Develop and execute a comprehensive strategy for migrating a large and diverse portfolio of existing Tableau dashboards and reports to Looker.
• Conduct thorough discovery and comparative analysis of Tableau reports ensuring accurate translation of business logic metrics and visualizations into Looker.
• Design and implement scalableLookML modelsthat effectively represent our underlying data warehouse structures.
• Ensure data consistency accuracy and validation throughout the migration process meticulously testing against source systems.
• Collaborate closely with Data Engineering to optimize underlying data structures and pipelines for Lookers performance and scalability.
• Manage the change management process including communication training and support for users transitioning from Tableau to Looker.

Advanced Looker Development & Governance

• Hands-on design development and optimization of sophisticated LookML models includingExplores Views Models Persistent Derived Tables (PDTs)data groupings andcaching strategies.
• Leverage advanced LookML techniques such asLiquid templating custom dimensions/measures and parameters to create flexible and powerful analytics experiences.
• Implement and enforce best practices forLookML style guides code reviews Git integration and version controlto maintain a clean performant and scalable Looker codebase.
• Proactively monitor Looker performance identify bottlenecks and implement solutions forperformance tuningon large datasets.
• Champion the adoption of new Looker featuresLooker Marketplaceblocks and industry best practices.

Continuous Improvement & Maintenance

• Manage the bug backlog incident resolution and ongoing maintenance of Looker content.
• Stay abreast of industry trends emerging BI technologies and the evolving data landscape to inform future platform enhancements.

• 3 years of experience in Product Management Business Intelligence or Analytics roles with a strong focus on data platforms.
• 3 years ofproven hands-on expertisewith Looker development including advanced LookML modeling Explores PDTs and performance optimization.
• 2 years of experience leading or significantly contributing to a large-scale BI platform migration.
• Strong background with Tableau development administration and features to effectively compare and translate reporting logic.

Technical Skills (must-have)

• Expert-level proficiency in Looker and LookML:Deep understanding ofLookML concepts Views Models Explores Refinements Liquid Templating Caching Policies Persistent Derived Tables (PDTs) Data Groups and performance tuning strategies within Looker.
• Proficient with Git for LookML version control and collaborative development workflows.
• Strong SQL skills with experience querying large complex datasets.
• Excellent communication skills including written presentation and story-telling
• Experience with modern cloud data warehousing platforms (e.g. Snowflake Google BigQuery AWS Redshift).
• Familiarity with data governance best practices and tools.
• Strong background with Tableau development administration and features to effectively compare and translate reporting logic

Product Management Skills

• Demonstrated ability to define product vision strategy and roadmaps.
• Experience with Agile development methodologies (Scrum Kanban).
• Exceptional stakeholder management communication and presentation skills (both technical and non-technical audiences).
• Strong analytical and problem-solving abilities with a keen eye for detail.
• Ability to balance business needs technical constraints and user experience.

Nice to Have

• Looker certifications (e.g. Looker Developer Looker Admin).
• dbt experience a big plus
• Experience in advertising marketing or media industries.
• Familiarity with Python or R for data analysis or scripting.
• Experience with data cataloging metadata management or data quality tools.
• Experience with other BI tools (e.g. Power BI Qlik Sense).

The Power of One starts with our people! To do powerful things we offer powerful resources. Our best-in-class wellness and benefits offerings include:

Paid Family Care for parents and caregivers for 12 weeks or more
Monetary assistance and support for Adoption Surrogacy and Fertility
Monetary assistance and support for pet adoption
Employee Assistance Programs and Health/Wellness/Comfort reimbursements to help you invest in your future and work/life balance
Tuition Assistance
Paid time off that includes Flexible Time off Vacation Annual Sick Days Volunteer Days Holiday and Identity days and more
Matching Gifts programs
Flexible working arrangements
Work Your World Program encouraging employees to work from anywhere Publicis Groupe has an office for up to 6 weeks a year (based upon eligibility)
Business Resource Groups that support multiple affinities and alliances

The benefits offerings listed are available to eligible U.S. Based employees are reviewed on an annual basis and are governed by the terms of the applicable plan documents.

We also offer medical and voluntary benefits to our freelancers and temporary employees. Voluntary benefit options include supplemental medical insurance transportation and parking benefits legal benefits pet insurance and auto and home must be actively employed for 90 consecutive calendar days in order to be eligible for Publicis medical and voluntary benefits.

Publicis Digital Experience is an Equal Opportunity Employer. Our employment decisions are made without regard to actual or perceived race color ethnicity religion creed sex sexual orientation gender gender identity gender expression pregnancy childbirth and related medical conditions national origin ancestry citizenship status age disability medical condition as defined by applicable state law genetic information marital status military service and veteran status or any other characteristic protected by applicable federal state or local laws and ordinances.

If you require accommodation or assistance with the application or onboarding process specifically please contact .

All your information will be kept confidential according to EEO guidelines.