Arena Careers

Role

We’re looking for a hands-on Analytics Engineer to take ownership of our core data infrastructure and help us scale our analytics work. You’ll be the primary builder and maintainer of our data warehouse in Google BigQuery / GCP, integrating new data sources, structuring data for analytics and data science, and powering client-facing dashboards and performance reporting. You’ll also play a key role in translating data into clear, compelling narratives for clients – through dashboards, decks, and direct conversations.

This role is a key bridge between data engineering, analytics, and client services. You’ll spend your time building robust pipelines, designing efficient SQL models, turning messy real-world data into clean, documented, reliable datasets, and helping our team and clients understand what the data actually means.

If you love SQL, live in BigQuery, and enjoy turning business questions into both solid data models and client-ready insights, this will be a great fit.

Responsibilities

Data Infrastructure & Warehousing

• Design, build, and maintain data models and tables in Google BigQuery, including staging layers, cleansed models, and analytics/data-mart layers.
• Develop and maintain ETL/ELT pipelines to ingest data from APIs, files, and third-party platforms into GCP.
• Ensure data pipelines are reliable, monitored, and well-documented, and are version-controlled via Git/GitHub.
• Collaborate on overall data architecture and best practices (naming conventions, partitioning, clustering, cost optimization).
• Maintain clear internal documentation of data sources, transformations, and model logic so the broader team can understand and build on your work.

APIs & Integrations

• Own the process of connecting and integrating new data sources, especially advertising platforms (Meta, Google Ads, programmatic DSPs), CRMs, email/SMS platforms, and engagement tools.
• Implement and maintain API integrations (REST/GraphQL, webhooks, batch exports) to keep our warehouse in sync with external systems.
• Work with vendors and internal stakeholders to troubleshoot and resolve integration issues.

Analytics, Dashboards & Client Enablement

• Build and optimize structured SQL views and queries that power dashboards, reporting, and data science projects.
• Partner with internal stakeholders to define metrics, KPIs, and dimensions that meaningfully answer client questions.
• Support and extend Looker Studio (and/or other BI tools) dashboards by designing performant data sources and models.
• Translate client needs into clear data requirements, models, and deliverables, working closely with analytics and account teams.
• Contribute to client-facing presentations and decks that communicate performance insights, methodology, and recommendations in accessible, non-technical language.

Real-Time Monitoring & Data Quality

• Develop and maintain real-time or near-real-time performance monitoring for key programs, including ad platform delivery and pacing, email/SMS deliverability and engagement, and cross-channel campaign performance.
• Implement data quality checks, anomaly detection, and alerting so we catch issues early (missing data, schema changes, volume anomalies, API failures, etc.).
• Monitor warehouse performance and cost, and recommend improvements to queries, schemas, and infrastructure.

Collaboration & Prioritization

• Work closely with data science, analytics, account, and strategy teams to understand business use cases and design the right data solutions.
• Manage competing requests across teams and clients, communicating clearly about timelines, tradeoffs, and priorities.
• Contribute to internal playbooks and standards so that our data ecosystem is understandable and maintainable by the broader team.

Qualifications

Required

• Advanced SQL skills, especially in an analytical data-warehousing context (window functions, CTEs, complex joins, performance tuning).
• 3+ years of experience in data engineering, analytics engineering, or a similar role (or equivalent experience).
• Hands-on experience with Google BigQuery and the broader GCP ecosystem (Cloud Storage, Cloud Functions / Cloud Run, service accounts).
• Experience designing and maintaining data models and pipelines to support BI dashboards and reporting.
• Comfort working with APIs (REST/JSON; authentication, pagination, rate limits) and integrating external platforms.
• Experience setting up monitoring/alerting or real-time performance views for pipelines or campaigns (e.g., scheduled queries, checks, alerts).
• Strong ability to translate stakeholder and client needs into data requirements and models.
• Experience building or supporting dashboards in a BI tool (Looker Studio preferred, but Tableau/Looker/Power BI are fine).
• Familiarity with Git/GitHub for version control and collaborative development.
• Clear written and verbal communication skills; comfortable presenting data work to non-technical audiences and contributing to client-facing materials.

Preferred

• Experience in progressive political or advocacy data environments, especially in the Bonterra / NGP VAN / EveryAction ecosystem or similar CRMs and campaign tools, such as ActBlue and Frakture.
• Working knowledge of Python for data pipelines, API work, and automation (e.g., requests, pandas, google-cloud-bigquery).
• Experience with real-time or streaming data (event-level ad data, webhooks, pub/sub).
• Familiarity with modern analytics engineering tooling (dbt, Airbyte, Fivetran) and data modeling best practices (star/snowflake schemas).
• Background or strong interest in advertising, campaign analytics, civic tech, or advocacy work.

Compensation

Base Salary Range: $75,000-90,000

Benefits: Assemble offers a wide range of progressive benefits, including:
✔ 100% company-paid medical, dental, and vision insurance
✔ 401(k) program with an employer match
✔ Flexible vacation and time off policy
✔ Monthly phone reimbursement
✔ Unlimited sick time
✔ 12 weeks of paid parental leave
✔ Health and wellness reimbursement
✔ Flexible Spending Account (FSA)
✔ Childcare stipend for work travel

Location

Hybrid role in Washington D.C. or New York City. Remote available for the right candidate.

To Apply

Send an email with attached resume and cover letter to [email protected] with “Senior Engineer, Ad Tech & Data” in the subject line.