Data Bi Engineer Jobs in Batavia, IL (NOW HIRING)

Company Description

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 we're untethered from any specific medium or method-we go where ideas will work best.

We are an expanding network with more than 5,000 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.

Job Description

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.

Responsibilities

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 scalable LookML models that 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 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.

Qualifications

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

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

Additional Information

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 moreMonetary assistance and support for Adoption, Surrogacy and FertilityMonetary assistance and support for pet adoptionEmployee Assistance Programs and Health/Wellness/Comfort reimbursements to help you invest in your future and work/life balanceTuition AssistancePaid time off that includes Flexible Time off Vacation, Annual Sick Days, Volunteer Days, Holiday and Identity days, and moreMatching Gifts programsFlexible 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 insurance. You 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 usmttacompliance@publicis.com.

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

 Compensation Range: USD $73,150.00 - USD $112,554.00/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 8/1/2026.Employment Type: FULL_TIME