Manager, Data Engineering

MissionOne Media; Kansas City, Denver, Chicago, New York (MO, CO, IL, NY); Hybrid; USD 70,000 - 125,000; Full time

Benefits offered by this job

Health insurance

Flexible PTO

Life insurance

401K

Job summary

MissionOne Media, a BarkleyOKRP brand, is seeking a Data Engineer to design and maintain data systems, collaborate with data scientists, analytics, and IT, and support data-driven decision making.

You will build BigQuery data warehouses, ETL pipelines, and ensure data quality across feeds from data suppliers, while embracing Snowflake and AWS best practices and driving scalable data solutions.

Qualifications

• Bachelor's degree (or equivalent) in Computer Science or IT.
• Very strong in SQL; 3-4+ years in large-scale datasets.
• Cloud-based data engineering with design, implementation, and ops of large-scale data and analytics solutions, ideally Snowflake.
• Experience with Python programming.
• Experience with ETL development lifecycle and data warehouses using Python, BigQuery, and GCP services.
• Experience in marketing/advertising is a plus.
• Excellent problem-solving and attention to detail.
• Strong communication and collaboration skills.
• Must be able to work under pressure.

Responsibilities

• Design, develop, and maintain Google BigQuery 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 issues.
• 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.

Skills

SQL

BigQuery

Python

ETL

GCP

Data Warehousing

Marketing knowledge

Communication

Collaboration

Problem solving

Education

Bachelor's degree in Computer Science or Information Technology

Job description

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

MissionOne 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 BigQuery 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, BigQuery, 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 hiringprocess or thereafter. Any information that you do provide will be recorded and maintained in aconfidential file.

As set forth in MissionOne 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 measurethe effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categoriesis as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.