Analyst, Data Engineering at Publicis Groupe ANZ in New York, NY

Summary: Publicis Groupe ANZ is a full-service media agency that connects media, data, technology, and teams to drive business outcomes. The Analyst will be responsible for designing, developing, implementing, and supporting a data-driven software platform, with a focus on ETL processes and data management. 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 systematic documentation - Participate in on-call rotation Required Qualifications: - Solid ETL Experience using various tools: Altyrex, AWS Glue, etc - Advanced SQL coding (1+ 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 understanding 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 Preferred Qualifications: - Digital media experience, particularly experience working in ad tech industry with a data-centric role plus Required Skills: ETL, AWS, SQL, SQL Query Optimization, Python, Data Warehousing, Digital Media, Ad Tech, Customer Service, Multitasking Benefits: Medical coverage, Dental, Vision, Disability, 401K, Parental and family care leave, Family forming assistance, Tuition reimbursement, Flexible time off