Manager, Data Engineering

About BarkleyOKRP BarkleyOKRP is one of the largest full-service independent agencies in the U.S. As an alternative agency model, BarkleyOKRP is independent enough to make bold work that sticks with the modern consumer and big enough to build whole brands with our full spectrum of capabilities. The firm is also one of the largest Certified B Corporation agencies with industry recognition that includes four times on Ad Age’s A-List, as well as being named AdAge’s “Agency of the Year - Culture, Convergence;” AdWeek’s “Fastest Growing Agencies'' and “Agency of the Year” shortlist, The 4A’s Foundation “Independent Agency of the Year” for DEIB practices, and the ANA’s Multicultural Excellence award. Learn more at barkleyokrp.com.

BarkleyOKRP

We're building whole brands + delivering independent creativity at scale. We are Big Indie. #BCorp Certified

Innovation StrategyBrand PositioningBrand ArchitectureBrand CulturePurpose + SustainabilityData StrategyCustom ResearchIdentity DesignExperience DesignDesign Systems

B

barkleyokrp.com

501-1,000 employees

Advertising Services

Kansas City, MO

1964

Privately Held

35k LinkedIn followers

• 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.

• 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.