Manager, Data Engineering

Kansas City, MO, Denver, CO;
Chicago, IL;
New York, NY;
Remote

Mission One Media is a brand within BarkleyOKRP that combines full-funnel media planning and buying services, CRM, data, analytics, retail media, SEO, and digital experiences. We're an independent media partner offering transparency, integration, and a relentless focus on business impact. As the Data Engineer, you will maintain, clean, and manipulate data in our operational and analytics databases. You will work with our data scientists, data analytics teams, reporting teams, and IT to understand and aid in the implementation of database requirements, analyze performance, and troubleshoot any existing issues.

Key Responsibilities:

• Design, develop, and maintain Google Big Query data warehouse solutions.
• Implement data pipelines and ETL processes to support data integration and analytics.
• Work with Data Suppliers (technical) for receiving data feeds.
• Validate data delivery from Data Suppliers to ensure data is aligned to expectations, resolving technical and data issues as they arise.
• Collaborate with cross-functional teams to gather requirements and deliver data solutions.
• Maintain operational documents to ensure they are current.
• Create optimal data pipeline architecture, troubleshoot and resolve issues related to data integration and job scheduling.
• Stay current with trends and best practices in Snowflake and AWS technologies.
• Provide support and training to team members on Snowflake best practices.
• Identify, design, and implement internal process improvements; automate manual processes; improve data delivery; and redesign infrastructure for greater scalability.

Qualifications:

• Bachelor's degree (or equivalent/above) in Computer Science or Information Technology.
• Very strong in SQL. Must have 3-4+ years of experience working with SQL on large-scale datasets.
• Must have experience in Cloud-based Data Engineering with design, implementation, and operationalization of large-scale data and analytics solutions, ideally Snowflake.
• Experience with the Python programming language.
• Must have experience with the ETL development life cycle, best practices for ETL pipelines, and thorough work experience with data warehouses using a combination of Python, Big Query, and GCP Services.
• Experience with marketing/advertising is a huge plus.
• Excellent problem-solving skills and attention to detail.
• Strong communication and collaboration skills.
• Must be able to work under pressure.

The annual gross base salary range is $70,000- $125,000 USD. This range represents the anticipated target salary range for this position. Actual salaries will vary and are based on factors such as a candidate’s qualifications, skills, and geographic location. Salary is one component of BarkleyOKRP's total compensation package, which includes multiple health insurance options, flexible PTO, life insurance, and 401K.

Voluntary Self-Identification

For government reporting purposes, we ask candidates to respond to the below self-identification survey.

Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiring process or thereafter. Any information that you do provide will be recorded and maintained in aconfidential file.

As set forth in Mission One Media’s Equal Employment Opportunity policy,we do not discriminate on the basis of any protected group status under any applicable law.

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection.

As a government contractor subject to the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measure the effectiveness of the outreach and positive recruitment efforts we undertake…