Analytics Engineer (Media Analytics)

TL;DR

Analytics Engineer (Media Analytics): Stabilizing and optimizing media data infrastructure, focusing on maintaining a complex Google BigQuery environment and migrating transformation logic to a scalable, transparent framework. Focus on advanced data modeling, performance optimization, and ensuring data integrity from diverse marketing sources.

Location: Working hours: Ideally 8-5pm EST. But we may have some flexibility, depending on the developer’s availability.

Company

hirify.global is seeking an Analytics Engineer to manage its media data infrastructure and support its transition to Omni Analytics.

What you will do

• Maintain and troubleshoot existing data ingestions, including Supermetrics, custom APIs, and Python-based scripts.
• Manage ingestion of varied vendor formats (CSV/ZIP) into BigQuery, handling dynamic schema changes.
• Oversee pipelines interacting with VM environments and transactional databases to ensure reporting continuity.
• Optimize existing SQL/Python scripts and formalize transformations into production-ready tables using dbt.
• Implement incremental loading strategies, partitioning, and clustering within BigQuery to manage costs and query speed.
• Collaborate with the Analyst team to ensure BigQuery production tables are optimized for the Omni Analytics modeling layer.

Requirements

• Master-level SQL proficiency in BigQuery (window functions, UDFs, script optimization) and GCP environment management.
• Deep experience with advertising data schemas (Meta, Google, TikTok) and ingestion tools like Supermetrics or Fivetran.
• Proven ability to reverse engineer legacy scripts to extract and document business logic.
• Proficiency with Git-based workflows (GitHub/Bitbucket).
• Ability to work effectively during EST (8-5pm) business hours, with some flexibility.

Nice to have

• Hands-on experience with dbt (data build tool).
• Proficiency in Python for data ingestion, API interaction, and transformation.
• Agency experience managing multi-client, multi-schema environments.
• Familiarity with the Omni Analytics platform or similar modeling-first BI tools.
• Familiarity with system design concepts and Java-based applications.
• Experience managing data flow from VM-hosted environments or transactional databases (MySQL).