Senior Data Engineer

Company Description

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.

Job Description

Responsibilities

• Write application and database code based on business requirements or user stories, architectural requirements, and existing code.
• Performing code reviews and mentor other junior engineers.
• Ownership of the whole data life cycle.
• Design, development, and enhancement of data models.
• Responsible for system performance of the data tier and the reliabitlity of data feeds across the enterprise system.
• Modify and improve data engineering processes to handle ever larger, more complex, and more types of data sources and pipelines.
• Work as part of the data processing team and on performance tuning and optimization, query optimization, index tuning, caching, buffer tuning and data archiving strategies.
• Estimate and plan development work, track and report on task progress, and deliver work on schedule.
• Write ad-hoc queries based on schema knowledge for various application requirements
• Contribute to operational support documentation.

Qualifications

• Bachelor's degree in information technology, computer science, or related field.
• Solid ETL Experience using various tools: SSIS, Altyrex, AWS Glue, etc.
• Proven experience as a BI / Big Data Developer.
• Advanced SQL coding, tuning and query optimization, especially within cloud-based data warehouses MS Azure and Amazon Redshift.
• 1+ years of Python coding experience.
• Professional or academic experience working with large data sets for conducting quantitative analysis.
• Excellent communication skills. Ability to speak and write professionally. 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

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

Compensation Range: $52,500 - $99,000 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. For this role, the Company will offer medical coverage, dental, vision, disability, 401k, and paid time off.

#LI-Hybrid