Summary
BI Developer at PLUS+ by Publicis (Publicis Groupe's dedicated global marketing/media team for PepsiCo), working onsite at 375 Hudson. Day to day: writing ETL packages and database code, assembling large datasets with AWS and SQL, performance tuning, documentation, and participating in an on-call rotation.
Company description PLUS+ by Publicis is PepsiCo's dedicated global marketing and media operating model, bringing together the best talent, capabilities, technology, data, and expertise from across Publicis Groupe into one integrated team. Supporting iconic brands including Pepsi, Gatorade, Lay's, Doritos, Cheetos, Mountain Dew, and Quaker, PLUS+ is designed to accelerate growth, innovation, and transformation at scale. This is a unique opportunity to join a team being built from the ground up and help shape the future of marketing for one of the world's most recognized consumer brands. Team members work alongside industry-leading experts across strategy, media, commerce, analytics, data, technology, and operations while contributing to a first-of-its-kind global model launch. If you're energized by innovation, transformation, and the chance to make a visible impact on a global business, PLUS+ offers an opportunity unlike any other in the industry. Responsibilities Write ETL packages and database code based on business requirements or user stories, architectural requirements, and existing code. Assemble large, complex sets of data using AWS and SQL technologies. Responsible for system performance of the data tier and the reliability of data feeds across the entire solution. Work as part of the data processing team and on performance tuning and optimization and code optimization. Estimate and plan development work, track and report on task progress, and deliver work on schedule. Create rigorous and systemic documentation. Participate in on-call rotation. Qualifications Bachelor's degree in information technology, computer science, or related field. Solid ETL Experience using various tools: Altyrex, AWS Glue, etc. Advanced SQL coding (3+ years), tuning and query optimization, especially within cloud-based data warehouses. At least one year experience with Python. Excellent communication skills. Must have an advanced proficiency level in English. Ability and comfort with presenting work by phone or within small groups. Excellent customer service skills. Ability to service clients, partners and internal stakeholders by understand their needs, translating those needs into creative solutions, and delivering on those solutions with diligence and a sense of urgency. Self-motivated and a self-starter with strong ability to multitask projects/tasks effectively. Digital media experience, particularly experience working in ad tech industry with a data-centric role plus. 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. 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 USMTTACompliance@publicis.com. All your information will be kept confidential according to EEO guidelines. Veterans Encouraged to Apply. 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. 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 12/12/2026.