Apply on Employer Site

Connelly Partners · 13 hours ago

Analytics Engineer (Contractor)

Boston, MA

Contract

Onsite

Mid, Senior Level

Connelly Partners is a marketing agency that focuses on leveraging data to enhance business performance. They are seeking a highly skilled Analytics Engineer to maintain their media data infrastructure and ensure data integrity while migrating transformation logic into a scalable framework.

Advertising

No H1B

Responsibilities

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

Opportunity to audit and make recommended updates to infrastructure

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 standards (Campaigns, Placements, Creatives, and UTM structures)

Omni Analytics 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

Qualification

BigQuery (SQL)Advertising data schemasDbt (data build tool)PythonGit-based workflowsAgency ExperienceProblem SolvingBI ExpertiseSystem design conceptsData flow management

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)

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

Preferred

Familiarity with system design concepts and Java-based applications

Experience managing data flow from VM-hosted environments or transactional databases (MySQL)

Company

Connelly Partners

Connelly Partners is an independent marketing agency involved in digital entertainment sector.

Founded in 1999

Boston, Massachusetts, USA

51-200 employees

http://www.connellypartners.com

Funding

Current Stage

Growth Stage

Leadership Team

Sal DeLuca

CFO

Alyssa D'Arienzo Toro

Sr. Partner/Chief Creative Officer

Recent News

Boston Globe

Veolia president looks to build portfolio of energy technologies

2025-08-25

Boston Globe

Boston ad agency Connelly Partners acquires MMB

2025-08-19

Ad Age

How women are redefining advertising

2025-03-26

Company data provided by crunchbase