Senior Analyst, Data Engineering

About the role

PLUS+ by Publicis, PepsiCo's global marketing and media operating model, is building a new team from the ground up in New York. The Senior Analyst, Data Engineering position works alongside experts in strategy, media, commerce, analytics, data, technology and operations, helping shape the future of marketing for a major consumer brand.

Key responsibilities

• Write ETL packages and database code based on business requirements, user stories, architectural requirements and existing code.
• Assemble large, complex data sets using AWS and SQL.
• Ensure system performance of the data tier and reliability of data feeds across the solution.
• Work with the data processing team on performance tuning, optimization and code optimization.
• Estimate and plan development work, track progress and deliver on schedule.
• Create rigorous and systematic documentation.
• Take part in the on-call rotation.

Required profile

• Bachelor's degree in information technology, computer science or a related field.
• Solid ETL experience with tools such as Altyrex and AWS Glue.
• Advanced SQL coding (3+ years), tuning and query optimization, especially in cloud-based data warehouses.
• At least one year of Python experience.
• Digital media experience, particularly in ad tech with a data-centric role.
• Advanced English, with the ability to present work by phone or in small groups; excellent customer service and self-motivation.

What we offer

• Pay range of USD 73,150 to USD 112,554 per year, depending on skills and experience.
• Medical, dental, vision and disability coverage, 401K and paid time off.
• Parental and family care leave, tuition reimbursement and flexible time off.