Senior Data Engineer - ETL, AWS & SQL (Ad Tech)

Publicis Groupe; New York (NY); Presencial; USD 73 000 - 113 000; Tempo integral

Resumo da oferta

PLUS+ by Publicis is PepsiCo's dedicated global marketing and media operating model, bringing together capabilities from Publicis Groupe into one integrated team to accelerate growth and transformation. This role is part of a team building from the ground up to shape the future of marketing for iconic brands.

You will write ETL packages, assemble large data sets on AWS/SQL, ensure data tier performance, and participate in on-call rotations as part of a data processing team.

Qualificações

• Bachelor's degree in information technology, computer science, or related field.
• Solid ETL experience using various tools: Alteryx, AWS Glue.
• Advanced SQL coding (3+ years) with tuning and query optimization in cloud data warehouses.
• At least one year of Python experience.
• Excellent communication and advanced English proficiency; ability to present work by phone or in small groups.
• Excellent customer service and stakeholder management; translate needs into data-driven solutions with urgency.
• Digital media experience in ad tech with a data-centric role or plus.

Responsabilidades

• Write ETL packages and database code based on business requirements or user stories, architectural requirements, and existing code.
• Assemble large, complex data sets 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.

Conhecimentos

ETL development

AWS data services

SQL proficiency

Python programming

English communication

Data analysis

Formação académica

Bachelor's degree in IT/CS

Ferramentas

Alteryx

AWS Glue

Descrição da oferta de emprego

PLUS+ by Publicis is PepsiCo's dedicated global marketing and media operating model, bringing together capabilities from Publicis Groupe into one integrated team to accelerate growth and transformation. This role is part of a team building from the ground up to shape the future of marketing for iconic brands.

You will write ETL packages, assemble large data sets on AWS/SQL, ensure data tier performance, and participate in on-call rotations as part of a data processing team.