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 ResponsibilitiesTechnical Qualifications

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
Environment Monitoring: Oversee pipelines interacting with VM environments and transactional databases (e.g., MySQL) to ensure reporting continuity
Transformation, Modeling & Standards
Advanced Modeling: Maintain and optimize existing SQL/Python scripts while formalizing transformations into production-ready tables using dbt
Performance Optimization: Implement incremental loading strategies, partitioning, and clustering within BigQuery to manage costs and query speed
Classification & Normalization: Apply and update complex logic to categorize media spend and performance. This includes normalizing varied vendor naming conventions into internal CP/Mavenn standards (Campaigns, Placements, Creatives, and UTM structures)
BI Strategy & Documentation
Omni Integration: Collaborate with the Analyst team to ensure BigQuery "Production" tables are optimized for the Omni Analytics modeling layer
Knowledge Transfer: Finalize and expand upon technical documentation to ensure no loss of institutional knowledge during the transition

Required

Expert BigQuery (SQL): Master-level SQL (window functions, UDFs, script optimization) and GCP environment management
Marketing Tech Stack: Deep experience with advertising data schemas (Meta, Google, TikTok, etc.) and ingestion tools like Supermetrics or Fivetran
Problem Solving: Proven ability to "reverse engineer" legacy scripts to extract and document business logic
Version Control: Proficiency with Git-based workflows (GitHub/Bitbucket)

Preferred

Analytics Engineering: Hands-on experience with dbt (data build tool)
Programming: Proficiency in Python for data ingestion, API interaction, and transformation
Agency Experience: Experience managing multi-client, multi-schema environments
BI Expertise: Familiarity with the Omni Analytics platform or similar modeling-first BI tools

Nice to Have

Familiarity with system design concepts and Java-based applications
Experience managing data flow from VM-hosted environments or transactional databases (MySQL)

Analytics Engineer (short-term)

Key Skills

Related Jobs

Apply for this Position

Fullstack Developer – NodeJS / Python / Express.js

Senior Data & Machine Learning Engineer (all genders)

Related Jobs

Apply for this Position

Fullstack Developer – NodeJS / Python / Express.js

Senior Data & Machine Learning Engineer (all genders)

Cookie Settings