[Hiring] Data Engineer @Atomic HR

Role Description

The Senior Data Engineer sits at the center of the agency's Data and Analytics function, connecting every paid media platform and CRM the agency touches into a single, reliable source of truth. You'll own the full path data takes: from a client's ad accounts and CRM, through Adverity, into a BigQuery warehouse, through modular dbt/Dataform transformations, and out to the Looker Studio dashboards and automated Google Sheets reports the team and its partners rely on daily. Reporting to the Data and Analytics Manager, you're joining at a pivotal moment — the agency is scaling its roster of education and nonprofit partners, and this role is instrumental in evolving the automated reporting suite that makes that growth possible without sacrificing data quality or client trust.

• Own data ingestion & pipeline architecture
• Own CRM integration
• Own the data warehouse
• Own transformation & mapping
• Own CI/CD & data segregation
• Enable the reporting layer
• Drive data quality

Qualifications

• 5+ years of hands-on data engineering experience, ideally in a marketing or agency environment
• Strong experience configuring datastreams, transformations, and destinations in Adverity or a comparable ETL platform (Fivetran, Supermetrics, Funnel)
• Intermediate to advanced SQL, with proven BigQuery experience in transformation, partitioning, and modeling
• Expertise in dbt or Dataform, managing modular, version-controlled, documented SQL transformation pipelines
• Python proficiency for custom API connections and pipeline automation
• Experience with CRM data flows and integrations (Slate, Salesforce, and/or HubSpot)
• A deep understanding of marketing metrics (ROAS, CPA, CAC) and paid platform schemas, with a proven track record of structuring data to optimize Looker Studio performance
• Proficiency with Git and collaborative development workflows, and proven ability to manage multi-client data environments with strict data segregation
• An analytical, solution-driven mindset with a growth orientation, and strong communication skills that turn complex data workflows into clear narratives for non-technical audiences — education marketing experience (traditional or online) is especially valued

Requirements

• Experience integrating AI-driven insights or machine learning models into marketing data pipelines to sharpen predictive analytics and data utility
• Familiarity using AI or LLM tools to optimize performance forecasting, automated audience segmentation, or marketing workflows
• Experience connecting, managing, and maintaining APIs for generative AI platforms within a marketing data architecture
• Experience using AI/ML-driven anomaly detection to monitor pipelines and proactively flag data quality issues

Benefits

• Remote role with the flexibility that comes with a distributed, async-friendly team
• Competitive compensation based on experience and location
• A pivotal, high-visibility seat on a scaling Data & Analytics team, with real ownership over the agency's reporting infrastructure
• The chance to build the data backbone for an agency whose partners are education and nonprofit organizations working to build a better world
• A culture built around finding a better way, playing as a team of A-players, and treating results as the engine rather than the goal
• Direct impact: the pipelines and models you build directly shape how partners see (and trust) their own performance data

Interview Process

• Application Review (resume + a few questions)
• Screening Call with Atomic HR
• Hiring Team Interview (walkthrough of a pipeline or data model you've built)
• Technical Assessment (a real-world data engineering case study)
• Final Interview with company leadership