Jobs · Management · Illinois

Senior Analyst, Data Analytics & Intelligence

Publicis Digital Experience · Chicago, IL · 2 wk ago
HybridManagement$73k/yrFull-time

Publicis Digital Experience, a division of Publicis Groupe, is a network of top-tier agencies focused on developing capabilities and solutions to drive growth and provide scaled access to Publicis Groupe’s digital expertise. Together, the portfolio creates value at the intersection of technology and experiences, connecting brands and people. With expertise in consumer engagement, CRM, and commerce, Publicis Digital Experience powers brands in a new era of creativity, adapting to an ever-changing landscape with fluid thinking and problem-solving. The network includes over 5,000 employees across global offices and agency brands such as Razorfish, Digitas, Arc Worldwide, Saatchi Saatchi X, Plowshare, 3Share, and the Publicis Commerce Exchange.

About the role

The Looker BI Developer is responsible for leading the migration of a large and complex portfolio of Tableau dashboards to Looker, establishing a new Looker ecosystem, and owning its product roadmap, governance, and continuous improvement. As the primary product owner, you will bridge business needs and technical execution, shaping the analytics future and empowering data-driven decisions for clients.

Responsibilities

  • Looker Platform Product Strategy & Vision
    • Define and champion the vision, strategy, and roadmap for the 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 scalable LookML models that effectively represent 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 Looker's 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, including Explores, Views, Models, Persistent Derived Tables (PDTs), data groupings, and caching strategies.
    • Leverage advanced LookML techniques such as Liquid templating, custom dimensions/measures, and parameters to create flexible and powerful analytics experiences.
    • Implement and enforce best practices for LookML style guides, code reviews, Git integration, and version control to maintain a clean, performant, and scalable Looker codebase.
    • Proactively monitor Looker performance, identify bottlenecks, and implement solutions for performance tuning on large datasets.
    • Champion the adoption of new Looker features, Looker Marketplace blocks, 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.

Requirements

  • 3+ years of experience in Product Management, Business Intelligence, or Analytics roles, with a strong focus on data platforms.
  • 3+ years of proven hands-on expertise with 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.

Skills

  • Technical Skills (must-have)
    • Expert-level proficiency in Looker and LookML: Deep understanding of LookML 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.
    • Experience with modern cloud data warehousing platforms (e.g., Snowflake, Google BigQuery, AWS Redshift).
    • Familiarity with data governance best practices and tools.
    • Excellent communication skills, including written, presentation, and storytelling.
  • 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.
    • 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).

Benefits

  • 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.
  • Tuition Assistance.
  • Paid time off, including Flexible Time Off, Vacation, Annual Sick Days, Volunteer Days, Holiday and Identity days, and more.
  • Matching Gifts programs.
  • Flexible working arrangements and 'Work Your World' Program, allowing employees to work from anywhere Publicis Groupe has an office for up to 6 weeks a year (based on eligibility).
  • Business Resource Groups supporting multiple affinities and alliances.
  • Medical and voluntary benefits for eligible U.S.-based employees, including supplemental medical insurance, transportation and parking benefits, legal benefits, pet insurance, and auto and home insurance.

Eligibility for medical and voluntary benefits requires 90 consecutive calendar days of active employment. Publicis Digital Experience is an Equal Opportunity Employer.

Pay

Compensation Range: USD $73,150.00 - USD $112,554.00/Annually. Compensation will be determined based on skills, qualifications, and experience, consistent with applicable law.

Similar jobs