Lead Engineer

Zenith is The ROI Agency, we succeed when our clients succeed. We have a simple strategy: motivate our people, deliver great work, and delight our clients. Clients want to work with happy and motivated people.  We have a superb Talent team, helping the agency recruit, develop and retain the industry's best talent. We're constantly striving to create a winning culture and we're delighted that 91% of our people would recommend us as a great place to work.  We are single mindedly focused on delivering great work. We have a consistent track record of making our clients' communications more effective. Our goal is to achieve commercial marketing success. We don't set out to win awards but see them as a function of great work.  Our greatest credential is our client list. Every day we work on challenging business and communication issues, in partnership with great client marketing teams. We are proud to have worked with many of our clients for 10 years or more and are equally proud of our new relationships.  To learn more, visitwww.zenithmedia.com

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.
• 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 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.
• Ensure all deliverables are high quality by setting development standards, adhering to the standards and participating in code reviews.
• Mentor, support and manage junior team members.
• Keep up to speed on new and emerging technologies and products that will be of interest to our clients

• Bachelor's degree in information technology, computer science, or related field.
• Advanced SQL coding 5+ years, tuning and query optimization, especially within cloud-based data warehouses like Amazon Redshift.
• At least two years of experience with Python.
• Solid various data processing tools like Databricks, Altyrex, AWS Glue, etc
• 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 those solutions with diligence and a sense of urgency.
• Self-motivated and a self-starter with a strong ability to multitask projects/tasks effectively.
• Digital media experience, particularly experience working in ad tech industry with a data-centric role plus.

This is a hybrid position working 3 days per week in our temporary Birmingham, MI location. This position will move to our permanent location in downtown Detroit when the office opens, with the same 3 days per week hybrid schedule.

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