Analytics Engineer (short-term)

We are seeking a highly skilled Analytics Engineer to provide immediate coverage and stabilization for our media data infrastructure. As our primary data architect during this transition, you will be responsible for maintaining a complex Google BigQuery environment, ensuring data integrity from diverse sources (Supermetrics, APIs, and manual vendor files), and migrating our transformation logic into a scalable, transparent framework to support our move into Omni Analytics.

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

Key Responsibilities

1. Pipeline & Ingestion Management

• Maintain & Troubleshoot: Monitor existing data ingestions, including Supermetrics, custom APIs, and Python-based scripts.
• Vendor Data Handling: Manage ingestion of varied vendor formats (CSV/ZIP) into BigQuery, handling dynamic schema changes and sharded raw tables efficiently.
• ...