BarkleyOKRP logo
BarkleyOKRP
Posted 17 days agoVerified live 5h ago

Manager, Data Engineering

Brief overview

Remote
UndergradOr in progress
$70k–$125k/yrStated range
3+ yrsMinimum
SQLCloud-Based Data EngineeringSnowflakePythonETL DevelopmentData WarehousingGoogle BigQueryGoogle Cloud Platform (GCP)AWS

About the company

BarkleyOKRP logo
BarkleyOKRPbarkleyokrp.com

BarkleyOKRP is one of the largest independent ad agencies in the U.S., matching scale with soul to help build brands like Burger King, Corona Premier, Metro by T-Mobile, Planet Fitness, and Smoothie King.

Job description

Summary

BarkleyOKRP's MissionOne Media is an independent media partner providing media planning and buying, CRM, data, analytics, retail media, SEO, and digital experiences. The Manager, Data Engineering will maintain and manipulate operational and analytics data, develop scalable data warehouse and ETL solutions, and collaborate with data, analytics, reporting, and IT teams to implement requirements and resolve technical issues.

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

Skills

  • 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
  • Excellent problem-solving skills and attention to detail
  • Strong communication and collaboration skills
  • Must be able to work under pressure
  • Experience with marketing/advertising is a huge plus

Qualifications

Must Haves

  • 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
  • Excellent problem-solving skills and attention to detail
  • Strong communication and collaboration skills
  • Must be able to work under pressure

Nice to Haves

  • Experience with marketing/advertising is a huge plus

Benefits

  • Multiple health insurance options
  • Flexible PTO
  • Life insurance
  • 401K

More jobs like this