Zenith is the ROI Agency. Our more than 6,000 specialists across 95 markets offer unparalleled capabilities in Media, Data, Technology, Commerce and Content. We put effectiveness at the heart of our work to solve complex challenges, drive successful business outcomes, and grow our clients’ businesses. Zenith is part of Publicis Media, the media arm of Publicis Groupe.

• Write stored procedures, ETL packages, and database code based on business requirements, user stories, architectural requirements, and existing code. 
• Modify and improve data engineering processes to handle ever larger, more complex, and more types of data sources and pipelines. 
• Responsible for system performance of the data tier and the reliability of data feeds across the entire solution. 
• Work with external and internal engineering business intelligence and product management teams to tune code, add data sources, clarify requirements and implement solutions in the client's environment.  
• Work as part of the data processing team and on performance tuning and optimization and query optimization strategies. 
• Estimate and plan development work, track and report on task progress, and deliver work on schedule. 
• Participate in weekly on-call rotation. 

• Bachelor's degree in information technology, computer science, or related field. 
• Solid ETL Experience using various tools: Altyrex, AWS Glue, etc. 
• Advanced SQL coding (2+ years), tuning, and query optimization, especially within cloud-based data warehouses MS Azure and Amazon Redshift. 
• Work with BI Engineers to create datasets for PowerBI and Qucksight dashboards and reports.  
• 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 them into creative solutions, and delivering on them with diligence and a sense of urgency. 
• Self-motivated and a self-starter with a solid ability to multitask projects/tasks effectively. 
• Digital media experience, particularly experience working in the ad tech industry with a data-centric role plus. 

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