Department
Analytics
Office Location
Boston, MA
Job Title
Analytics Engineer (Contractor)
Reports to
Director of Analytics
DEPARTMENT MISSION
The analytics team partners with its clients and agency co-workers to help answer three fundamental questions: what happened? so what? and what’s next? Our answers to these questions are rooted in and driven by data. As such, we are experts in leveraging data to measure marketing results, analyze trends and relationships, and identify opportunities for improving marketing and business performance over time. Ultimately, we believe data itself is not a competitive differentiator, rather how a company makes its data actionable that will determine its competitive advantage.
JOB PURPOSE
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.
ESSENTIAL JOB DUTIES
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.
- 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.
2. 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 standards (Campaigns, Placements, Creatives, and UTM structures).
3. BI Strategy & Documentation
- 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.
QUALIFICATIONS
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.
Nice to Have
- Familiarity with system design concepts and Java-based applications.
- Experience managing data flow from VM-hosted environments or transactional databases (MySQL).
ABOUT CONNELLY PARTNERS
At Connelly Partners, our vision is to be the world’s most aggressive advocate of the human voice and our day-to-day mission is to shine a light on the importance of human truths and their power in a data-driven world.
To protect our brands from self-importance, every team member has a role in amplifying their heartbeats and embracing empathy over entertainment. We value the importance of data, but also the power of emotion. We use data to ask better questions and are in the business of pursuing the WHY.
Headquartered in Boston, with a European hub in Dublin, not New York or London and another hub in Vancouver, not Toronto, we’re firmly rooted in shadow cities with an independent fire and a full-service approach. All resources are offered in-house for efficiency and consistency – strategic planning, creative, production (including an onsite studio), analytics, media, influencer marketing, social media, PR, technology and shopper marketing.
For more information on Connelly Partners, please visit www.connellypartners.com, follow us on Twitter (@ConnellyAgency) and Instagram (@ConnellyPartners), or like us on Facebook (www.facebook.com/ConnellyPartners).Connelly Partners is unable to sponsor visas at this time.
*To protect the interests of all parties, Connelly Partners will not accept unsolicited resumes from any source other than directly from a candidate. Connelly Partners will NOT pay a fee for any placement resulting from the receipt of an unsolicited resume.
Top Skills
What We Do
Not just independent people, an independent network.
When Steve Connelly, creative director and copywriter, established Connelly Partners in 1999, he set out to do one thing: to show the world that good people can do exceptional work.
